Purchase Solution

SPC Chart

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.