2
>Sheet
1 |
Sample |
X1 |
X2 |
X
| 3 |
X
| 4 |
X
| 5 |
X
| 6 |
X
| 7 |
1
|
|
|
|
|
|
|
|
|
|
| 20 |
.1
|
| 1
| 9 |
|
|
|
|
|
| 20.9 |
|
|
|
|
|
|
|
|
| 22 |
.2
| 1
| 8 |
.9
|
|
|
|
|
|
|
|
| 18 |
.1
|
|
|
|
| 21 |
.3
2
|
|
|
|
|
|
|
| 19 |
|
| 17 |
.9
| 21.2 |
| 20.4 |
20
|
|
|
|
|
|
| 22.3 |
|
|
|
|
| 21.5 |
3
|
|
| 22.6 |
|
|
|
|
|
|
|
|
|
|
| 21.4 |
21.4
|
|
|
| 22.1 |
|
|
|
|
|
|
|
|
|
|
|
| 19.2 |
| 20.6 |
| 18.7 |
4
|
|
|
|
|
| 18.1 |
| 20.8 |
|
|
| 17.8 |
|
|
|
|
|
|
|
| 19.6 |
|
|
|
|
|
|
|
| 19.8 |
| 21.7 |
20
5 22.6
|
|
| 19.1 |
21.4
|
|
|
|
| 21.8 |
|
|
|
| 18.4 |
18
|
|
|
|
|
|
|
|
| 19.5 |
6 19.1 19 22.3 21.5 17.8 19.2
|
|
|
|
| 19.4 |
7
| 17.1 |
19.4
| 18.6 |
20.9 21.8 21 19.8
8
|
|
|
| 20.2 |
| 22.4 |
22 19.6 19.6 20
|
|
|
| 18.5 |
9
| 21.9 |
| 24 |
.1
|
|
|
| 23 |
.1
| 22.8 |
| 25 |
.6
| 24.2 |
| 25.2 |
10 |
|
| 25.1 |
|
| 24.3 |
|
|
|
|
|
| 26 |
|
| 23.1 |
|
|
|
|
| 25.8 |
|
|
|
|
|
| 27 |
|
| 26.5 |
11 |
25.8
|
|
|
| 29 |
.2
|
|
|
|
|
|
| 28 |
.5
|
| 29.1 |
|
| 27.8 |
29 28
12 |
|
|
|
|
| 28.2 |
|
| 27.5 |
|
| 29.3 |
|
|
|
| 30 |
.7
|
| 27.6 |
28 27
13 |
28.2
|
| 28.6 |
|
| 28.1 |
26 30
|
|
|
| 28.5 |
|
| 28.3 |
14 |
22.1 21.4
|
| 23.3 |
|
|
|
|
|
|
| 20.5 |
19.8 20.5 19
15 |
18.5 19.2 18
|
|
|
|
| 20.1 |
22 20.2 19.5
16 |
21.4
|
| 20.3 |
22 19.2 18
|
| 17.9 |
19.5
17 18.4
|
| 16.5 |
18.1 19.2
|
|
|
| 17.5 |
20.9 19.6
18 20.1 19.8 22.3
| 22.5 |
21.8
| 22.7 |
23
19 20 17.5 21
|
|
| 18.2 |
19.5
| 17.2 |
18.1
20 22.3 18.2 21.5 19 19.4 20.5 20
21 20.1 19 20.9
22.2 |
18.9 |
18.1
21.3 |
22 19 17.9 21.2 20.4 20 22.3 21.5
23 22.6 21.4 21.4 22.1 19.2 20.6 18.7
24 18.1 20.8 17.8 19.6 19.8 21.7 20
25 22.6 19.1 21.4 21.8 18.4 18 19.5
26 19.1 19 22.3 21.5 17.8 19.2 19.4
27 17.1 19.4 18.6 20.9 21.8 21 19.8
28 20.2 22.4 22 19.6 19.6 20 18.5
29 21.9
24.1 |
23.1 22.8
25.6 |
24.2 25.2
30 25.1 24.3 26 23.1 25.8 27 26.5
31 |
25.8
| 29.2 |
28.5 29.1 27.8 29 28
32 |
28.2 27.5 29.3
| 30.7 |
27.6 28 27
33 |
28.2 28.6 28.1 26 30 28.5 28.3
34 |
22.1 21.4 23.3 20.5 19.8 20.5 19
35 |
18.5 19.2 18 20.1 22 20.2 19.5
36 |
21.4 20.3 22 19.2 18 17.9 19.5
37 |
18.4 16.5 18.1 19.2 17.5 20.9 19.6
38 |
20.1 19.8 22.3 22.5 21.8 22.7 23
39 |
20 17.5 21 18.2 19.5 17.2 18.1
40 |
22.3 18.2 21.5 19 19.4 20.5 20
41 |
25.1 24.3 26 23.1 25.8 27 26.5
42 |
25.8 29.2 28.5 29.1 27.8 29 28
43 |
28.2 27.5 29.3 30.7 27.6 28 27
44 |
28.2 28.6 28.1 26 30 28.5 28.3
45 |
22.1 21.4 23.3 20.5 19.8 20.5 19
46 |
18.5 19.2 18 20.1 22 20.2 19.5
47 |
21.4 20.3 22 19.2 18 17.9 19.5
48 |
18.4 16.5 18.1 19.2 17.5 20.9 19.6
Sheet2
Sheet3
Project#1- Multiple Regression – Outline
Step 1
Select a sample of 35 to 45 random homes from the data set. You can do it manually.
Provide the following:
Step 2
1. Specify the regression model.
2. Identify the independent and dependent variables.
3. Explain your regression model in your own words.
4. Explain the basic assumptions in regression model in your words.
Step 3
5. Find the descriptive statistic of all the variables.
6. Graphs (Histogram with normal curve, Stem-leaf and Q-Q plot).
7. Interpret the major findings (in tasks# 5 and 6).
Step 4
8. Conduct the correlation analysis, with SPSS.
9. Explain the findings of correlation analysis.
Step 5
10. Conduct the multiple regression analysis with SPSS.
11. Explain the findings of the regression analysis.
12. Conduct one forecast for a set of independent variables and find the residual.
13. Conduct hypothesis testing for the slopes any two independent variables.
Step 6
14. Draw conclusions from your analysis.
Step 7
15. Write a report with all the findings, following the format given below.
Report Format
Title Page (with your name, Course# 2112, Spring 2013)
I. Introduction. (Also include a brief narrative of the case)
II. Methodology (containing Step 2: Tasks# 1, 2, 3 and 4).
III. Descriptive Statistics and Graph (containing Step 3: Tasks#5, 6 and 7).
IV. Correlation Analysis (containing Step 4: Tasks# 8 and 9).
V. Regression Analysis (containing Step 5: Tasks# 10, 11, 12 and 13).
VI. Conclusions (containing Step 6, Task#15).
Project#2– Methods of Quality Improvement
Individual Project. Due by the last week of the semester
The data set shows 48 samples (for 48 hours) of size n=7 collected to test the production process of a filling machine for soft drink bottling. The target filling is 20 fluid ounces.
Your tasks:
Select a random sample of 24 hours of data. [Feel free to do it manually, if you cannot use the sample selection procedure in the software. ]
Using the sample data, accomplish the following:
Part 1
1. Construct an x-bar chart. Need to use graph paper.
2. Calculate and plot the centerline and upper and lower control limits for the charts.
3. Calculate and plot the A, B and C zone boundaries of the x-bar chart.
4. Plot the 24 sample means on the x-bar chart.
5. Based on x-bar findings, is the process under statistical control? Explain and justify your answer.
Part 2
6. Construct an R-chart. Need to use graph paper.
7. Calculate and plot the centerline and upper and lower control limits for the charts.
8. Calculate and plot the A, B and C zone boundaries of the R-chart.
9. Plot the sample ranges on the R-chart.
10. Analyze the pattern of the R-chart.
11. Based on R-chart findings, is the process under statistical control? Explain and justify your answer.
Part 3
12. Theoretically, what is the difference between x-bar chart and R-chart? Explain briefly.
13. How are they used? That is, what is their purpose? Explain briefly.
Part 4
14. Compare the findings from your x-bar chart and R-chart.
15. Explain why rational sub-groupings are used in constructing control charts?
16. What are the major findings from the study? Explain briefly.
17. What are your conclusions from the study? Explain briefly.
Report:
Submit your findings and analysis in a report format (used in Project 1).
HVCC Custom Ed
nina86: did you look over the last lesson
nina86: i sent u
nina86: thats for question #9
Me: okay
nina86: i just sent u different notes on the lessons but my book is similar to Elementary Linear Algebra 7e ISBN : 1133110878
Me: ok
Me: based on which chapter?
Turn in your highest-quality paper
Get a qualified writer to help you with
“ SPSS Help ”
Get high-quality paper
NEW! AI matching with writer