Open a blank excel file and create a grouped frequency distribution

1.Go to this website. http://temperature.12dt.com/monthly 2.Open a blank Excel file and create a grouped frequency distribution of the maximum daily temperatures for the 50 states for a 30 day period. Use temperature intervals of ten degrees. E.g. 40–50, 51–60, 61–70, etc. See the Project 1 opening announcement posted by your instructor in order to know which date range to use. 3.Add midpoint, relative frequency, and cumulative frequency columns to your frequency distribution. 4.Create a frequency histogram using Excel. You will probably need to load the Data Analysis Add in within Excel. If you do not know how to create a histogram in Excel, view the video located at: http://www.youtube.com/watch?v=_gQUcRwDiik. Or a simple bar graph will also work. 5.Create a frequency polygon in Excel. For help, view http://www.youtube.com/watch?v=IDnnXMLdmS0 6.Explain what the data you analyzed means. •For example, if Colorado says Max–97 and Min–37, where might these values come from geographically within Colorado? Are they good indicators of the weather in the various states? Does it make sense to say Colorado was 72 degrees today? 7.Look through the data. Do you see any outliers? Are the values in the data set realistic or do you have questions about the accuracy? Explain.