Ements Ns 5 Shown Below Is A Portion Of An Excel Output For Regression Analysis Relating Y Dependent Variable And X I 1 (477.61 KiB) Viewed 58 times
Ements Ns 5 Shown Below Is A Portion Of An Excel Output For Regression Analysis Relating Y Dependent Variable And X I 2 (227.81 KiB) Viewed 58 times
ements ns 5 Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). The percent of the variability in the prediction of Y that can be attributed to the variable X Regression Statistics Multiple R 0.7732 R Square 0.5978 Adjusted R Square 0.5476 Standard Error 3.0414 Observations 10 ANOVA df Significance F Regression 1 Residual 8 Total 9 SS 110 74 184 MS 110 9.25 F 11.892 0.009
ANOVA df SS Regression 1 110 Residual 8 74 9.25 Total 9 184 Coefficients Standard Error t Stat Intercept 39.222 5.942 6.600 X -0.556 0.161 -3.448 O is 59.78% none of the stated answers is correct O is 39.22% O is 54.76%. O is 77.32% MS 110 F 11.892 P-value 0.000 0.009 Significance F 0.009
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!