STATISTICS 1013- Shown below is a portion of an Excel output for a regression
Question # 00549702
Posted By:
Updated on: 06/21/2017 01:40 AM Due on: 06/21/2017
Final Exam
1. Shown below is a portion of an Excel output for a regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 24.011 Residual 8 67.989 Coefficients Standard Error t Stat Pvalue Intercept 11.065 2.043 5.415 0.001 x 0.511 0.304 1.681 0.131
1. Shown below is a portion of an Excel output for a regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 24.011 Residual 8 67.989 Coefficients Standard Error t Stat Pvalue Intercept 11.065 2.043 5.415 0.001 x 0.511 0.304 1.681 0.131
1. What is the estimated regression equation that relates y to x? (2 points)
2. Is the regression relationship significant? Use a p value and alpha = 0.05. (2 points)
3. What is the estimated value of y if x = 12? (2 points)
4. Interpret the meaning of the value of the coefficient of determination if it is 0.26 in this case. Be very specific. (2 points)
2. Salary information regarding male and female employees of a large company is shown below. Male Female Sample Size 64 36 Sample Mean Salary (in 1,000) 44 41 128 72 Sample Standard Deviation
3. Calculate the t statistic. (2 points)
1. What is the set of null and alternative hypotheses if we want to determine whether the mean salary of male and female employees is the same? (2 points)
2. Using a level of significance of 0.05, what is the rejection rule for this test using the critical value approach if the degrees of freedom (df) for this test is given to be df = 97? (2 points)
Final Exam
3. Calculate the t statistic. (2 points)
4. Based on the above, what is the conclusion of this statistical test? (2 points)
-
Rating:
/5
Solution: STATISTICS 1013- Shown below is a portion of an Excel output for a regression