Unit 1 Lab: Summarizing Data Using Excel


  1. Get the “Audit” Data file (attached).
  2. Follow the instructions under “using excel to construct a frequency distribution” in Chapter 2 of textbook.
  3. Develop Figure 2.10 and add relative frequency and cumulative frequency. Keep in mind that “count of audit time” is frequency only.
  4. Upload the final figure showing classes, frequency (count of audit time), relative frequency, and cumulative frequency.