Data Charts

Instructions:

There are three (2) problems to work on in this assignment. These problems are found on the rest of the slides in this

deck. For each problem, take the data set and create the requested graph in Excel. In addition to the graph, please

answer the associated question(s) for that problem.

You can submit this in Excel, PowerPoint or Word. Hand drawn graphs will not be accepted on this assignment.

Problem #1 –

The following data are commute times (in minutes) from your professor’s home to work for 25

consecutive work days. Construct a histogram for these commute times. You can choose the bin size

of your choice, as long as there are at least 5 bin sizes. Follow the directions in the second set of

PowerPoint Lecture slides for this week if you want.

18.1 18.2 18.0 17.9 17.8 18.0 17.8 18.1 18.2 18.0 18.3 18.5 18.0

17.5 7.8 18.3 18.6 18.8 17.4 18.6 37.4 18.7 18.0 17.2 17.2

Questions:

1. Based on your histogram, which bin did the most commutes fall into?

2. Based on your histogram, which commute is the outlier? How can you tell?

Problem #2 –

The following data are commute times (in minutes) from your professor’s home to work for 25

consecutive work days. Construct a control chart for these commute times. Follow the directions in

the second set of PowerPoint Lecture slides for this week if you want.

18.1 18.2 18.0 17.9 17.8 18.0 17.8 18.1 18.2 18.0 18.3 18.5 18.0

17.5 7.8 18.3 18.6 18.8 17.4 18.6 37.4 18.7 18.0 17.2 17.2

Questions:

1. Based on your control chart, do you see any special cause variation? (yes or no)

2. If yes, please describe or highlight the special cause variation you observe.