1. (50 pts) The table below gives the average temperature for selected cities in Europe in the month of May in °F. 64.4 52.7 60.3 55.9 56.5 58.6 59.7 60.4 66.0 72.1 56.1 54.5 61.9 60.4 64.2 59.2 68.7 66.7 61.9 43.3 64.0 52.5 57.9 54.5 63.5 66.2 55.2 50.9 57.6 57.7 64.4 62.6 61.9 52.3 60.8 60.4 66.2 51.3 55.9 60.3 59.9 62.2 55.9 50.4 48.4 46.0 58.6 58.5 55.4 71.2 51.6 62.6 66.0 63.0 55.4 63.1 66.0 61.7 58.3 55.8 39.2 66.7 51.4 41.2 44.4 60.3 62.1 69.3 54.7 56.8 60.1 51.4 To work on the project, copy and paste the data to the Excel sheet. a. Construct a frequency distribution using Excel where the first class is 39.2 - 44.1. b. Use Excel to construct a Histogram of the data. Make sure to improve the Histogram by providing appropriate title, label, remove the space between bars etc. c. Use the histogram to answer the following questions: i. How many cities were included in the survey? ii. What is the modal class? iii. What is the width of each class? iv. What is the midpoint of the fourth class? d. Use Excel to construct a pie chart of the data and make sure to improve the pie chart by providing appropriate label and each sector should specify the percent of data. Work submitted must include the Excel file with both the graphs and answer to the questions in parts a and c.

Fig: 1