Question: Please help me. 1. (50 pts) The table below gives the average annual snowfall for selected U.S. cities in inches. 64.4 11.0 70.8 15.3 2.1
Please help me.

1. (50 pts) The table below gives the average annual snowfall for selected U.S. cities in inches. 64.4 11.0 70.8 15.3 2.1 16.2 0.9 21.5 0.2 56.9 1.5 44.3 20.6 42.8 26.2 93.6 79.3 21.1 77.8 0.7 34.0 5.6 55.8 38.0 57.6 1.9 28.2 64.5 2.6 60.3 33.3 41.3 20.3 80.6 5.3 67.7 40.8 23.6 73.3 49.6 46.9 0.4 23.9 1.0 97.0 19.9 11.5 1.2 16.1 5.2 16.4 43.8 5.1 47.0 49.9 0.4 0.4 10.1 28.3 0.2 28.6 7.8 9.5 16.7 30.1 20.8 43.6 70.4 6.5 36.0 7.5 24.3 13.8 11.7 58.7 0.7 0.4 11.4 41.2 48.6 23.2 19.6 37.1 1.2 10.2 17.1 15.9 2.4 Just copy and paste the data to the Excel sheet. a. Construct a frequency distribution using Excel. Let the first class be 0 - 10, second class is from 10.1 - 20.1, and so on. b. Use Excel to construct a Histogram of the data. Make sure to improve the Histogram. 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
