Project 2 – Frequency Distribution, Histogram and Data Summary
Introduction: Using the data set from project 1 you will create a frequency distribution and histogram for one of the Quantitative fields from your data set.  We will then summarize the data.  This project closely follows Chapter 2 in the Excel Workbook.  If you choose to switch data sets , you will need to repeat project 1 on a new data set.

1. Analysis Toolpak : You will need to enable the Analysis Toolpak in Excel.  This is available on all school computers, and can be enabled by following the directions in Section 2-1.  If you are using your home computer, this step may require the installation disc.  In Excel 2007, you will need to access Excel options, click Add ins, select Analysis Toolpak and click Go.
2. Choose a field from your dataset that contains quantitative data you are interested in summarizing.
3. Create a frequency distribution following the steps in Section 2-2.  Follow the guidelines from class, making sure you have at least 5 classes.
   1. List on scratch paper the class limits, boundaries, midpoints.  Enter the upper class limits in a vertical list in your Excel table.
   2. Click Tools, Data Analysis, Histogram.  A dialog box will appear.
   3. Click in Input Range box, and then select all the data in the field you wish to create the histogram on.
   4. Click in the Bin Range box and then select all the data in your upper class limit list.
   5. Click Output Rangeand select a cell in the spreadsheet where you want the frequency distribution to be output.
   6. Click the check box Chart Output, this will create the histogram.
   7. Click OK.

4. Modify the Histogram Modify the histogram so that it is easy to read.  To get practice at this,  it will help to work through the example in the book in section 2-3.

1. Calculate Descriptive Statistics for the same field of the data set following the steps in Section 2-4 & 2-5.
   1. Click Tools, Data Analysis, Descriptive Statistics.
   2. Click Input Range, and then Select the data in the field you used in 3.
   3. Click Output Range, and then click in the cell where you want the Statistics to appear.
   4. Click Summary Statistics
   5. Click OK
2. Interpret your results.  What do the frequency distribution and histogram tell you about the data?  Can you identify any outliers?  What appears to be the "center" of the data?  Is the data tightly clustered, or spread out, skewed or symmetric?  Based on the summary statistics, what are the usual maximum and minimum values?  Are there any outliers in your data set based on the rule of 2 standard deviations?
3. Turn in using the dropbox .

Price: $9.99

Solution: The downloadable solution consists of 4 pages, 599 words and 1 charts.
Deliverable: Word Document