Based on the list created for task 1 determine how

This preview shows page 1 - 2 out of 2 pages.

2.Based on the list created for Task 1, determine how you will measure progress on meeting the requirements. For example, you might have
3.After analyzing survey information, you decide to create a Pareto diagram to easily see which types of recreational programs and company-sponsored classes most people were interested in. First, create a spreadsheet in Excel using the data in the table below. List the most frequently requested programs or classes first. Add a column called “% of Total” and another one called “Cumulative %.“ Then enter formulas to calculate those items. Next, use the Excel Chart Wizard to create a Pareto diagram based on this data. Use the Line — Column on 2 Axis custom type chart so your resulting chart looks similar to the one in Figure 8-1. Requested Programs/Classes# of times requestedWalking program7,115Volleyball program2,054Weight reduction class8,875Stop smoking class4,889Stress reduction class1,894Soccer program3,297Table tennis program120Softball program976
Figure 8-1. Sample Pareto Diagram

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture