SPSS Help

project_1_data_set.xlsdata_set_for_both.xlsproject1-_multiple_regression_-_outline project2_-_methods_of_quality_improvement

Attached files are questions with data sets

2

>Sheet

1

single-family residences

00)

1

3.5

5 2

2

.0

90

6 3

3

.5

8 2 36

4

.9

5 3

5

.0

4

6 3

6

.0

1204 5 3 10

8 4 64

8

00

7 3

9

.0

5

5 3 16

10

9.0

10 5 17

.0

5 3

12

.0

4 2 41

6 3 35

14

8 3 52

7 3 12

16

9 4

17

6 3

.5

2

5 2 69

19

7 3

20

.4

6

6 3 11

7 3 9

5 2 14

23

5 3 11

5 3 14

25

9 3 16

6

6 3

27

.0

1008 5 2 35

5 3 20

29

5 2 74

30

.5

9 4 15

5 3 15

.0

6 3 16

63.0

5 2 24

34 60.0

6 3 26

35

3 1 42

36

5 2 9

37

6 3 30

38

8 4

39 60.0

7 4 32

40

5 2 24

41

8 4 74

42

6 3 14

1736 7 3 16

83.0

6 3 12

8 4 12

46

5 2 34

6 3 29

48

.0

5 3 33

49

7 3 2

50

8 4 15

60.0

6 3 36

52

8 3 37

53

1120 5 3 27

7 3 79

55

5 3 20

56

5 3 2

73.0 1400 5 3 2

58

6 3

12 4

60

6 3 29

61

6 3 9

62

6 3 4

63 55.0

5 2 21

Data on																		6																																										3
Residence	Sales Price (in $ Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper			10	Square feet	Rooms	Bedrooms	Age
																									5	100									8				35
												4							9						12				36
	50	8	60
	49	912			41
		52		1			20		40
		55
								7	80.5			17	64
86.0						16		19
	69	1	25
				14	3600
		11		46	864			37
	38	720
13	49.5		1008
105.0	1950
			15	152.5	2086
85.0	2011	76
			60.0	1465	102
18		58	1	23
101.0		1736	67
	79	1			29
	21	125.0	1996
22	87.9	18		74
80.0	1580
		24	94.0	1920
74.0	14		30
	26	69.0	1	48			27
		63
28	67.5	1282
35.0	11		34
1		42	2400
31	92.2	1701
	32		56	1020
	33	10	53
1728
34.0	416
52.0	1040
75.0	1496
93.0	1936		39
1904
	73.0	1080
71.0	1768
	83.0	1503
43	90.0
44	1695
45	115.0	2186
50.0	888
47	55.2		1120
	61		1400
147.0	2165
210.0	2353
51	1536
100.0	1972
44.5
54	55.0	1664
53.4	925
65.0	1288
57
40.0	1376	103
59	141.0	2038		62
68.0	1572
139.0	1545
140.0	1993
1130

Sheet2

Sheet3

2

>Sheet

1 1

.1

.2

.9

.1

.3

2

.9

20

3

21.4

4

20

5 22.6

21.4

18

6 19.1 19 22.3 21.5 17.8 19.2

7

19.4

20.9 21.8 21 19.8

8

22 19.6 19.6 20

9

.1

.1

.6

25.8

.2

.5

29 28

.7

28 27

28.2

26 30

22.1 21.4

19.8 20.5 19

18.5 19.2 18

22 20.2 19.5

21.4

22 19.2 18

19.5

17 18.4

18.1 19.2

20.9 19.6

18 20.1 19.8 22.3

21.8

23

19 20 17.5 21

19.5

18.1

20 22.3 18.2 21.5 19 19.4 20.5 20
21 20.1 19 20.9

18.1

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

23.1 22.8

24.2 25.2

30 25.1 24.3 26 23.1 25.8 27 26.5

25.8

28.5 29.1 27.8 29 28

28.2 27.5 29.3

27.6 28 27

28.2 28.6 28.1 26 30 28.5 28.3

22.1 21.4 23.3 20.5 19.8 20.5 19

18.5 19.2 18 20.1 22 20.2 19.5

21.4 20.3 22 19.2 18 17.9 19.5

18.4 16.5 18.1 19.2 17.5 20.9 19.6

20.1 19.8 22.3 22.5 21.8 22.7 23

20 17.5 21 18.2 19.5 17.2 18.1

22.3 18.2 21.5 19 19.4 20.5 20

25.1 24.3 26 23.1 25.8 27 26.5

25.8 29.2 28.5 29.1 27.8 29 28

28.2 27.5 29.3 30.7 27.6 28 27

28.2 28.6 28.1 26 30 28.5 28.3

22.1 21.4 23.3 20.5 19.8 20.5 19

18.5 19.2 18 20.1 22 20.2 19.5

21.4 20.3 22 19.2 18 17.9 19.5

18.4 16.5 18.1 19.2 17.5 20.9 19.6

Sample	X1	X2	X	3	X	4	X	5	X	6	X	7
											20			1	9							20.9										22		1	8										18						21
								19			17		21.2		20.4								22.3						21.5
			22.6												21.4					22.1													19.2		20.6		18.7
						18.1		20.8				17.8									19.6									19.8		21.7
			19.1						21.8					18.4										19.5
					19.4
	17.1		18.6
				20.2		22.4					18.5
	21.9		24					23		22.8		25		24.2		25.2
10			25.1			24.3							26			23.1						25.8							27			26.5
11					29								28			29.1			27.8
12						28.2			27.5			29.3					30			27.6
13			28.6			28.1					28.5			28.3
14			23.3								20.5
15						20.1
16			20.3			17.9
		16.5					17.5
	22.5		22.7
			18.2		17.2
22.2	18.9	21.3
24.1	25.6
31		29.2
32		30.7
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

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?