Task B: Graphical and Tabular Techniques

(Try to make your Excel spreadsheet narrow in width and long in length when composing answers)

Prepare an easy-to-follow summary such that:

1. What is the measurement level of data you collected?

2. What type of charts or graphs apply to the data you have collected?

3. Organize the data into a frequency distribution. Discuss:

• How many classes would you recommend?
• Use the guidelines discussed in class and support your recommendation.
• What class interval would you suggest? Use the guidelines discussed in class and provide calculations to support your recommendation.
• What lower limit would you recommend for the first class? Support your recommendation.

4. Use the frequency distribution to plot a histogram for the datasome Excel old version's plot might be damaged during uploading. If I cannot see the histogram, I have to take mark off so you may save your histogram as a jpg/png file then insert it into Excel as double insurance.