Hint(s) Check My Work Consider the following data for a dependent variable y and two independent variables, x1 and *2. X2 30 12 94 47 11 109 25 17 113 50 17 178 40 6 95 52 20 175 75 8 171 37 12 118 60...

I need help with what to input in excel to help me solve this.

Hint(s) Check My Work<br>Consider the following data for a dependent variable y and two independent variables, x1 and *2.<br>X2<br>30<br>12<br>94<br>47<br>11<br>109<br>25<br>17<br>113<br>50<br>17<br>178<br>40<br>6<br>95<br>52<br>20<br>175<br>75<br>8<br>171<br>37<br>12<br>118<br>60<br>13<br>143<br>76<br>16<br>211<br>The estimated regression equation for these data is<br>ŷ = -20.03 + 1.95x1 + 4.92x2<br>Here SST = 14,990.1, SSR = 13,918.4, 8i, = 0.2382, and si, = 0.9506.<br>a. Test for a significant relationship among a1, x2, and y. Use a = 0.05.<br>F =<br>(to 2 decimals)<br>The p-value is<br>Select your answer -<br>

Extracted text: Hint(s) Check My Work Consider the following data for a dependent variable y and two independent variables, x1 and *2. X2 30 12 94 47 11 109 25 17 113 50 17 178 40 6 95 52 20 175 75 8 171 37 12 118 60 13 143 76 16 211 The estimated regression equation for these data is ŷ = -20.03 + 1.95x1 + 4.92x2 Here SST = 14,990.1, SSR = 13,918.4, 8i, = 0.2382, and si, = 0.9506. a. Test for a significant relationship among a1, x2, and y. Use a = 0.05. F = (to 2 decimals) The p-value is Select your answer -

Jun 11, 2022

SOLUTION.PDF

Hint(s) Check My Work Consider the following data for a dependent variable y and two independent variables, x1 and *2. X2 30 12 94 47 11 109 25 17 113 50 17 178 40 6 95 52 20 175 75 8 171 37 12 118 60...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment