Using the given Height and Weight data set, perform a regression analysis using
ID: 3152687 • Letter: U
Question
Using the given Height and Weight data set, perform 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).
Height Weight 67 125 68 140 67 142 60 110 64 97 61 106 79 210 61 110 71 150 66 145 59.5 113 71 175 72 145 55 110 64 112 65 135 65 135 71 140 68 130 71 152 67 127 70 143 68 165 72 160 71 185 65 114 67 116 66 113 63 145 62 116 70.5 155 64 107 64 104 69 137 75 200 65 150 67 140 65 125 75 240 57 140 68 135 73 178 68 122 62 145 68 190 73.5 180 63 125 72.5 165 66 115 68 125 72 210 63 118 65 135 75 225 69 145 72 240 69 170 62 105 64 125 62.5 130 78 190 63 115 73 280 69 125 62.5 120 63 145 63 132 69.5 195 69 168 70 160 60.5 105 65 112 72 215 69 150 70 150 67 125 64 135 70 185 71 127 72 178 66 123 65.5 145 71 135 68 135 66.5 145 67 145 69 193 66 125 71 148 65 125 62 120 65 119 68 160 67 140 62.5 115 64 125 61 95 62 126 62.5 165 70 167 73 250 73.5 280 79 180 71 175 63 120 72.5 125 69.5 156 75 185 62 130 67 140 64.5 120 66 140 69 155 60 105 67 125 65 115 66 130 69 170 73 247 73.5 172 65 147 67 160 67.5 160 62 140 64 120 63 110 65 115 61 115 73 165 74 180 72 182 65 130 73 160 74 190 75 180 70 165 62 140 68 165 57 125 72 160 66 128 65 115 63 135 66 118 74 130 64 130 67 140 71 174 60 118 64.5 133 61.5 107 64 145 66 150 70.5 165 69 143 70 155 64 138 62 147 77 245 62 130 69 135 70 150 71 135 71.5 160 67.5 110 69 155 63 96 65 140 66.5 120 67 130 73 155 63 105 73 160 63 112 68 125 69 132 69 175 63 150 64 105 69 135 63 134 64 115 63 123 67 170 71 162 68 140 64 115 73 205 67.5 130 67 145 60.5 125 69 180 65.5 135 64 140 76 185 64 135 63 127 62 115 62 135 70.5 142 67 140 68 135 71 178 67 135 64 127 70 153 62 110 73 165 79 165 75 160 71 170 65 117 69.5 185Explanation / Answer
The regression model is
y=a+bx
From Excel
The fitted model is
y= -207.45 +5.25 (height)
Coefficients Standard Error t Stat P-value Intercept -207.7463157 23.773632 -8.73852 7.4E-16 Height 5.253581087 0.352449725 14.9059 8.41E-35Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.