Question- You are an event planner for a large global company.
You have been asked to prepare a report on the best time of year to visit one of three different cities: Rome, Miami, and Honolulu. You have researched their temperatures for the entire year and obtained them on a daily basis. You have decided to find the two week period during the year when the temperatures average 72 degrees.
Explain in detail how you would develop a spreadsheet to find the average two week temperature and arrange the data so that the two weeks period most close to 72 degrees are presented for each city in the appropriate table.