Use the Project 1 data set to create the graphs and tables in question 1-4 and to answer both parts of question 5.

1. 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 8 classes.
2. Add midpoint, relative frequency and cumulative frequency columns to your frequency distribution
3. create a frequency histogram using excel. (Or draw it)
4. create an ogive
5. a) do any of the temperatures appear to be unrealistic? If yes, which ones and why ? b) explain how this affects your confidence in the validity of this data set