STEP 1: CHOOSE A SET OF DATA TO WORK WITH.

Below are links to different Excel/csv files with sets of data reported by either the U.S. Census bureau, the U.S. Centers for Disease Control, or U.S. Department of Education Office of Civil Rights. You will choose one of these files to use for both parts of this project. If the Excel/csv file has more than one column of data, you will choose only one column to use. If you need help or clarification about what to do or what the data represents, PLEASE contact me. CSV (Comma Separated Values) files can be opened with Excel. Download the file, open Excel, and click on Data tab at the top. Then choose Import from Text. Open the file you downloaded. Choose Comma as the delimiter. Click Finish. Then you can save it as an Excel file after that. (Lots of videos on YouTube on how to do this).

STEP 2: CREATE A GROUPED FREQUENCY TABLE

Using the data set you chose in step 1, construct a grouped frequency table (distribution) that includes relative frequency, and cumulative relative frequency. You will insert this into your file for submission.

STEP 3: CREATE 2 GRAPHIC SUMMARIES OF THE DATA

Using the data you chose in step 1, construct 2 different graphic summaries of the data that are appropriate and easy to read or understand. Make sure your graph has a title and all necessary parts are clearly labeled. You will insert these 2 graphs into your file for submission. They can be either created by hand or with software.

STEP 4: MAKE AN EDUCATED GUESS/ESTIMATION OF THE MEAN OF THE DATA

Now that you have worked with the data, make a guess/estimation about what you believe the mean of the data set you chose in step 1.
DO NOT CALCULATE THE MEAN – this MUST be an ESTIMATION, and the accuracy of your guess will not be evaluated/graded. Type up your guess/estimation as a complete sentence of the form: I believe the mean of (insert description of the data) is (insert your guess as a single numerical value).
For example: I believe the mean of the average cost of a pack of cigarettes in the U.S. is $6.50.