# FOR MATH ACER ONLY

**Project 1 Instructions**

**Based on Larson & Farber: section 2.1**

A temperature data set has been posted under Course Content>>Assignment Instructions>>Projects in Blackboard. Use the data in that data set to create the graphs and tables in questions 1â€“4 and to answer both parts of question 5. If you canâ€™t figure out how to make the graphs and tables in Excel, you are welcome to draw them by hand and then submit them as a scanned document or photo.

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. **(8 points)**

2. Add midpoint, relative frequency, and cumulative frequency columns to your frequency distribution. **(8 points)**

3. 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.

If you cannot get the histogram or bar graph features to work, you may draw a histogram by hand and then scan or take a photo (your phone can probably do this) of your drawing and email it to your teacher.

**(8 points)**

4. Create a frequency polygon in Excel (or by hand). For help, view http://www.youtube.com/watch?v=IDnnXMLdmS0

**(8 points)**

5. A. Do any of the temperatures appear to be unrealistic or in error? If yes, which ones and why. **(4 points)**

B. Explain how this affects your confidence in the validity of this data set. **(4 points)**

Submit your work through the assignment link by 11:59 p.m. (ET) on Monday of Module/Week 1.