Reference no: EM131304532
Instructions:
- Individual work, consultations with the instructor will only be for clarification of the question.
- Please submit at the start of the exam using this page as cover page.
- Please sign affidavit below.
Question #1
The data set given on the next page corresponds to certain measured variable during the initial production phase of a new product (Ramp period). Because the process is new you are interested in detecting variations and determining the Upper and Lower Control Limits for the process. Each sample of data collected corresponds to four daily measurements taken every 6 hours during the initial phase of production from November 1st (Sample #1) to November 25th (Sample #25).
a. Use Excel to compute the average and the Range for each day, present your result using the table format given with the data with two decimal figures. Also compute the mean and standard deviation for the daily averages. Your name should be included at the top of the table.
b. Use Excel to create a histogram for the raw data (all 100 points) using 12 bins. The title of the histogram should be "25-Day Critical Parameter Raw Data Histogram. The header for this page should read "Question 1.b - Your name." Briefly comment on the type of distribution you see.
c. Generate the statistical process control (SPC) chart for the daily averages of the data set for the 25-day period under study showing each daily average point, the mean of the distribution (X-bar), the Upper Control Limit (UCL) line, and the Lower Control Limit (LCL) line. Following what you learned in the course the UCL and LCL are to be computed with three standard deviations. Title your chart "SPC Chart for New Product Critical Parameter - Ramp Phase". Use Landscape page layout; the header for this page should read "Question 1.c - Your name"
All the pages for Part 1 must be stapled in sequential order.
Critical Parameter - 25-day collected data during Ramp Phase
|
Sample #
|
1
|
2
|
3
|
4
|
Daily Average
|
Daily Range
|
|
1
|
10
|
9
|
4
|
8
|
|
|
|
2
|
6
|
6
|
12
|
7
|
|
|
|
3
|
7
|
6
|
11
|
9
|
|
|
|
4
|
8
|
12
|
10
|
8
|
|
|
|
5
|
3
|
3
|
4
|
5
|
|
|
|
6
|
2
|
3
|
3
|
4
|
|
|
|
7
|
13
|
9
|
12
|
10
|
|
|
|
8
|
12
|
8
|
9
|
7
|
|
|
|
9
|
5
|
9
|
9
|
7
|
|
|
|
10
|
5
|
7
|
5
|
4
|
|
|
|
11
|
8
|
9
|
8
|
9
|
|
|
|
12
|
7
|
9
|
8
|
9
|
|
|
|
13
|
8
|
7
|
8
|
11
|
|
|
|
14
|
13
|
17
|
16
|
18
|
|
|
|
15
|
10
|
8
|
9
|
10
|
|
|
|
16
|
10
|
9
|
7
|
13
|
|
|
|
17
|
8
|
9
|
11
|
7
|
|
|
|
18
|
9
|
9
|
10
|
8
|
|
|
|
19
|
10
|
10
|
7
|
8
|
|
|
|
20
|
11
|
10
|
7
|
9
|
|
|
|
21
|
6
|
10
|
12
|
8
|
|
|
|
22
|
9
|
10
|
8
|
8
|
|
|
|
23
|
6
|
4
|
6
|
8
|
|
|
|
24
|
6
|
12
|
9
|
5
|
|
|
|
25
|
6
|
13
|
5
|
7
|
|
|
|
|
|
Daily Averages X-bar =
|
|
|
Daily Averages Stdev =
|
|
How do organizations create opportunitiy for illegal conduct
: How do organizations create opportunities for illegal conduct?Identify the external factors that impact corporate crime. Describe Karl Marx's theory of crime as it relates to white collar crime. Discuss the limitations of the Marxist theory.
|
|
Historical context of immigration in the jamiaca plain
: Write about the historical context of immigration in the Jamiaca Plain, Boston MA. Mention the History of immigration in that area and why it attracts so many people.
|
|
Why did he consider this term to be more appropriate
: Explain why, in your opinion, Jefferson chose to change "property" into "the pursuit of happiness"? Why did he consider this term to be more appropriate for the American Declaration of Independence? ?Think about this from multiple perspectives.
|
|
Write a paper on impact of oil industry innovation on canada
: Write a research paper about impact of oil industry innovation on canada economy. The paper should be 10 pages (tittle page and references not included), double space.
|
|
Generate the statistical process control chart
: MAE 400 - Fall 2016 - Generate the statistical process control (SPC) chart for the daily averages of the data set for the 25-day period under study showing each daily average point, the mean of the distribution (X-bar), the Upper Control Limit (UC..
|
|
What is the expected real interest rate on the treasury bill
: What is the yield to maturity on a Treasury bill that matures one year from now, has a price of $1,010, and has a face value of $1,000? If the consumer price index is expected to decline during the year from 250 to 245, what is the expected real i..
|
|
Produce a simple command processor
: Now that the OS has a keyboard driver, it is possible to produce a simple command processor. You should expand the Run() method in command.c to produce a simple command processor that implements the following commands: cls- Clear the screen
|
|
What particular ideologies played a role
: How did the culture in which the work was created influence the work? (What particular ideologies played a role in its creation and where do you see this influence reflected in the work you chose?) Make sure to point to specific examples of the in..
|
|
Show the impact on the market for u.s. treasury bonds
: Use one graph to show the impact of this change in tax rates on the market for municipal bonds and another graph to show the impact on the market for U.S. Treasury bonds.
|