Instructions: Full work must be shown for each example or no credit will be awar
ID: 3436685 • Letter: I
Question
Instructions: Full work must be shown for each example or no credit will be awarded. Explain each result that you provide. Keep your solutions neat and do your best to conform to the format of the exam. The answer to each question should be typed right after the specific question and for full credit it should be complete and correct.
Q5. (10 POINTS)Consider the following excel regression analysis output.
Explain the significance of the r, p, F value; Give the regression equation.
summary output regression statistics multipl R .875179 r square .765938 adjusted r square .73668 standard error 3.802138 observations 10 anova df ss ms f significance f regression 1 378.45 378.45 26.17898833 0.000911066 residual 8 115.65 14.45625 total 9 494.1 coefficient standard error t stat p-value lower 95% upper 95% lower 95.0% upper 95.0% intercept 75.4 2.082517 36.2062 3.71E-10 70.59770833 80.20229167 70.59770833 80.20229167 X Variable 1 -4.35 0.850184 -5.11654 0.000911066 -6.310527365 -2.389472635 -6.310527365 -2.389472635Explanation / Answer
Well, I canno make out what exactly is required to be answered due to clumsyness of the question. But since you asked for r,p F values, I can provide what do they mean.
r= correlation coefficient between two variables under consideration,
p=p-value the estimated probability of false rejection of null hypothesis. Which if > chosen level of significance will lead to rejection of null hypothsis.
F= F-statistic used to test the significance of regression.