Question: you decide to create a Pareto chart to see which types of guidelines for running an event generated the most interest. First, create a spreadsheet

you decide to create a Pareto chart to see which types of guidelines for running an event generated the most interest.

First, create a spreadsheet in Excel using the data in the following table.

List the most frequently requested guidelines first (already done using sort command in Ms Excel).

Use the Excel template called pareto_chart.xls (attached herein) and also found in the texts companion website and check your entries so the resulting chart looks like the one in Figure 8-7 (included in the attached document)

Give an interpretation of your graph (your interpretation should include the 80/20 rule and relate this rule to the problem at hand)

Your file for submission should be in Ms Excel file format

Requested Guidelines

# of Times Requested

How to find good participants

24

How participants should present their ideas

20

How to find local sharks

15

How to select participants

12

How to manage and engage the audience

7

How to set up the facilities

3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!