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.

Please help me. 1. (50 pts) The table below gives the average

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!