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 =
|