Explore BrainMass
Share

SPC Chart

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Complete the following actions, using the Excel file "Optional Problem Data Student File" for the actions involve Excel:

1. Prepare an SPC chart in Excel for each concourse using the data collected during the period 8/4 to 8/13 (data provided below).
2. Paste each SPC chart into a separate slide in a PowerPoint presentation (select the graph in Excel, right click and select Copy, go to PowerPoint slide, go to Home tab, click on the down arrow below Paste in the upper left of toolbar, select Paste Special, select "Picture (Enhanced Metafile)", and then select OK.
3. On each PowerPoint slide (one for each concourse) annotate each data point on the control chart with a C (common cause variation) or an S (special cause variation).
4. Specify whether the process associated with each concourse is or is not in control on each slide;
5. Specify whether the process associated with each concourse is or is not capable on each slide;
6. Explain the managerial implications of the data for each concourse. State clearly how you would address the situation on Concourse A and the situation on Concourse B - include these notes on additional slide(s) in your PowerPoint presentation;
7. Submit your PowerPoint presentation and Excel spreadsheet.

© BrainMass Inc. brainmass.com October 25, 2018, 8:30 am ad1c9bdddf
https://brainmass.com/business/managerial-statistics/prepares-spc-chart-data-542868

Attachments

Solution Summary

The expert prepares an SPC chart in Excel. The managerial implications of the data for each concourse are determined.

$2.19
See Also This Related BrainMass Solution

Process Capability and SPC

This solution analyzes the process capability and SPC of a process. The solution analyzes the Xbar and R charts for the process.

View Full Posting Details