Based on the scenario and data set, construct a document that addresses the questions outlined below. This assignment should be completed using Microsoft Word and Microsoft Excel, and both files should be submitted. The rubric shown in this Canvas dropbox lets you know how the assignment will be graded.

Summarize and graph your data.

Choosing one of the quantitative variables from your data set, construct a frequency distribution that has a minimum of 5 classes (please do not include more than 10 classes). The frequency distribution should contain the following columns:

Lower and Upper Class Limits

  1. Frequencies

Class Boundaries


Relative Frequencies

Cumulative Frequencies

Interpret the results of your frequency distribution in context of your chosen scenario.

  1. Using the same variable from your frequency distribution, construct a histogram.
  2. Summarize the results of your histogram.
  3. Discuss the construction of your histogram.
  4. What values were used on the horizontal and vertical axes?
  5. What does the height of the bars represent?
  6. What is the shape of the distribution?
  7. Interpret the results of your histogram in context of your chosen scenario.
  8. Discuss the importance of the Measures of Center and the Measures of Variation.

What are the measures of center and why are they important?

  1. What are the measures of variation and why are they important?

5.  Using the variable that you analyzed, calculate the measures of center and measures of variation. Interpret your results in context of the selected topic. Include the formula for any of the following statistics which are derived from formulas.

  1. Mean


  1. Mode
  2. Midrange
  3. Range
  4. Variance
  5. Standard Deviation

6. Conclusion

Recap your ideas by summarizing the information presented.