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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
