W7 Discussion “Relationship of Height and Weight”
Business Statistics
Relationship of Height and Weight
•
•
•
Using the given Height and Weight data set, follow the steps in the weekly video or on
pages 584-585 of the textbook for performing a regression analysis using Excel to
analyze the Height and Weight Data set (assume height is the input variable x and weight
is the output variable y).
Once you have performed the analysis in Excel, state the correct simple linear regression
equation and use the regression equation to predict the weight (in pounds) of a person
who is 65 inches tall and the weight (in pounds) of a person who is 100 inches tall.
Why might the regression equation you have found not be a good predication of the
weight of someone who is 100 inches tall?
W7 Project Assignment "Project Week 7"
Business Statistics
Project Week 7
For these project assignments throughout the course you will need to reference the data in the
ROI Excel spreadheet.
Using the ROI data set:
For each of the two majors:
1. Draw the scatter diagram of Y = ‘Annual % ROI’ against X = ‘Cost’.
2. Obtain b0 and b1 of the regression equation defined as y ̂ = b0 + b1X and the coefficient
of determination (r2) from the Excel regression output.
3. Draw the fitted regression line on the scatter diagram.
4. Calculate the estimated ‘Annual % ROI’ when the ‘Cost’ (X) is $160,000.
5. Test the hypothesis:
o H0: β1 = 0
o Ha: β1 ≠ 0
6. Write a paragraph or more on any observations you make about the regression estimates,
coefficient of determination, the plots, and the results of your hypothesis tests.
School Type
Private
Private
Private
Public
Private
Public
Private
Private
Private
Private
Private
Private
Private
Private
Private
Public
Public
Private
Private
Private
Best College ROI by Majo 2013: Payscale.com
Cost
$222.700,00
$176.400,00
$212.200,00
$125.100,00
$212.700,00
$92.910,00
$214.900,00
$217.800,00
$225.600,00
$217.300,00
$226.500,00
$215.500,00
$223.500,00
$226.600,00
$189.300,00
$89.700,00
$87.030,00
$218.200,00
$229.900,00
$148.800,00
30 Year ROI
$1.786.000,00
$1.758.000,00
$1.714.000,00
$1.535.000,00
$1.529.000,00
$1.501.000,00
$1.485.000,00
$1.483.000,00
$1.444.000,00
$1.442.000,00
$1.441.000,00
$1.438.000,00
$1.428.000,00
$1.414.000,00
$1.397.000,00
$1.382.000,00
$1.376.000,00
$1.343.000,00
$1.339.000,00
$1.321.000,00
Annual ROI
7,70%
8,40%
7,80%
9,10%
7,40%
10,10%
7,30%
7,20%
7,00%
7,10%
7,00%
7,20%
7,00%
7,00%
7,50%
9,90%
10,00%
6,90%
6,70%
8,10%
School Type
Private
Private
Private
Private
Private
Public
Private
Private
Public
Private
Public
Private
Public
Private
Public
Public
Public
Public
Private
Public
Cost
$221.700,00
$213.000,00
$230.100,00
$222.600,00
$225.800,00
$87.660,00
$224.900,00
$221.600,00
$125.100,00
$215.700,00
$92.530,00
$217.800,00
$89.700,00
$229.600,00
$101.500,00
$115.500,00
$104.500,00
$69.980,00
$219.400,00
$64.930,00
30 Year ROI
Annual ROI
$2.412.000,00
8,70%
$2.064.000,00
8,30%
$1.949.000,00
7,90%
$1.947.000,00
8,00%
$1.938.000,00
8,00%
$1.937.000,00
11,20%
$1.915.000,00
7,90%
$1.878.000,00
7,90%
$1.854.000,00
9,80%
$1.794.000,00
7,90%
$1.761.000,00
10,60%
$1.752.000,00
7,70%
$1.727.000,00
10,70%
$1.716.000,00
7,50%
$1.703.000,00
10,20%
$1.694.000,00
9,70%
$1.690.000,00
10,10%
$1.685.000,00
11,50%
$1.676.000,00
7,60%
$1.668.000,00
11,70%
Height
67
68
67
60
64
61
79
61
71
66
59.5
71
72
55
64
65
65
71
68
71
67
70
68
72
71
65
67
66
63
62
70.5
64
64
69
75
65
67
65
75
57
68
73
68
62
68
73.5
Weight
125
140
142
110
97
106
210
110
150
145
113
175
145
110
112
135
135
140
130
152
127
143
165
160
185
114
116
113
145
116
155
107
104
137
200
150
140
125
240
140
135
178
122
145
190
180
63
72.5
66
68
72
63
65
75
69
72
69
62
64
62.5
78
63
73
69
62.5
63
63
69.5
69
70
60.5
65
72
69
70
67
64
70
71
72
66
65.5
71
68
66.5
67
69
66
71
65
62
65
68
125
165
115
125
210
118
135
225
145
240
170
105
125
130
190
115
280
125
120
145
132
195
168
160
105
112
215
150
150
125
135
185
127
178
123
145
135
135
145
145
193
125
148
125
120
119
160
67
62.5
64
61
62
62.5
70
73
73.5
79
71
63
72.5
69.5
75
62
67
64.5
66
69
60
67
65
66
69
73
73.5
65
67
67.5
62
64
63
65
61
73
74
72
65
73
74
75
70
62
68
57
72
140
115
125
95
126
165
167
250
280
180
175
120
125
156
185
130
140
120
140
155
105
125
115
130
170
247
172
147
160
160
140
120
110
115
115
165
180
182
130
160
190
180
165
140
165
125
160
66
65
63
66
74
64
67
71
60
64.5
61.5
64
66
70.5
69
70
64
62
77
62
69
70
71
71.5
67.5
69
63
65
66.5
67
73
63
73
63
68
69
69
63
64
69
63
64
63
67
71
68
64
128
115
135
118
130
130
140
174
118
133
107
145
150
165
143
155
138
147
245
130
135
150
135
160
110
155
96
140
120
130
155
105
160
112
125
132
175
150
105
135
134
115
123
170
162
140
115
73
67.5
67
60.5
69
65.5
64
76
64
63
62
62
70.5
67
68
71
67
64
70
62
73
79
75
71
65
69.5
205
130
145
125
180
135
140
185
135
127
115
135
142
140
135
178
135
127
153
110
165
165
160
170
117
185
Purchase answer to see full
attachment