Question

A teacher wishes to investigate if there is any relationship between a student’s exam score in...

A teacher wishes to investigate if there is any relationship between a student’s exam score in Mathematics (X) and the exam score in Accounting (Y). A sample of 11 students is randomly selected and the results are summarized in the ANOVA table below:
                                                                                                                   15 Marks
df SS
Regression 1 1305.68
Residual 9 81.96
Total 10 1387.64

Coefficients Standard Error t Stat p-value
Intercept 24.13 4.657 5.182 0.005
MathScore 0.759 0.063 11.974 0.001
a. What is the estimated regression equation that relates the exam score in accounting (Y) to the score in mathematics (X)?
b. What is the estimated exam score in accounting if a student got a score of 80 in mathematics?
c. Is the regression relationship significant? Use the p-value approach and 3% level of significance.
d. Compute the coefficient of determination between the exam score in accounting and the exam score in mathematics. Interpret the result in the context of the problem.

Homework Answers

Answer #1

(a) The estimated regression equation is:

y = 24.13 + 0.759*x

(b) Put x = 80

y = 24.13 + 0.759*80

y = 84.85

(c) The hypothesis being tested is:

H0: β1 = 0

H1: β1 ≠ 0

The p-value from the output is 0.001.

Since the p-value (0.001) is less than the significance level (0.03), we can reject the null hypothesis.

Therefore, we can conclude that the regression relationship is significant.

(d) The coefficient of determination between the exam score in accounting and the exam score in mathematics is 1305.68/1387.64 = 0.941.

94.1% of the variability in exam scores in accounting is explained by the exam score in mathematics.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
3. The accountant at Walmart wants to determine the relationship between customer purchases at the store,...
3. The accountant at Walmart wants to determine the relationship between customer purchases at the store, Y ($), and the customer monthly salary, X ($). A sample of 15 customers is randomly selected and the results are summarized in the ANOVA table below: df SS Regression 1 186952 Residual 13 99236 Total 14 286188 Coefficients Standard Error t Stat p-value Intercept 78.58 7.540 1.202 0.035 Salary 0.066 0.013 4.948 0.003 a. What is the estimated regression equation that relates the...
A teacher is interested in the relationship between the time spent studying for an exam and...
A teacher is interested in the relationship between the time spent studying for an exam and exam score. The table lists scores for 5 students. The value of b0 = 67.91 and the value of b1 = 0.75 Hours studied 5 18 3 15 17 Exam score 63 87 79 72 82 . Step 3 of 6 : Calculate the Sum of Squares Regression (SSR). Round intermediate values and final answer to two decimal places
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 39947.80 Residual (Error) 10 8280.81 Total 11 48228.61 Coefficients Standard Error t Stat P-value Intercept 69.190 26.934 2.569 0.02795 X 2.441 0.351 6.946 0.00004 1.   What is the estimated regression equation that relates Y to X? 2.   Is the regression relationship significant? Use the p-value approach and alpha = 0.05 to answer this question. 3.   What is the...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 3348.312 Residual 8 9529.811 Total 9 12878.123 Coefficients Standard Error t Stat P-value Intercept 247.56 83.280 1.689 0.030 X 148.62 38.312 1.283 0.075 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...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 39947.80 Residual (Error) 10 8280.81 Total 11 48228.61 Coefficients Standard Error t Stat P-value Intercept 69.190 26.934 2.569 0.02795 X 2.441 0.351 6.946 0.00004 1.   What is the estimated regression equation that relates Y to X? (2 Points) 2.   Is the regression relationship significant? Use the p-value approach and alpha = 0.05 to answer this...
A manager at a local bank analyzed the relationship between monthly salary (y, in $) and...
A manager at a local bank analyzed the relationship between monthly salary (y, in $) and length of service (x, measured in months) for 30 employees. She estimates the model: Salary = β0 + β1Service + ε. The following ANOVA table summarizes a portion of the regression results.     df SS MS F Regression 1 555,420 555,420 7.64 Residual 27 1,962,873 72,699 Total 28 2,518,293 Coefficients Standard Error t-stat p-value Intercept 784.92 322.25 2.44 0.02 Service 9.19 3.20 2.87 0.01...
A large city hospital conducted a study to investigate the relationship between the number of unauthorized...
A large city hospital conducted a study to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was selected and the following data were collected.    Distance in Miles, Number of days absent 1, 8 3, 5 4, 8 6, 7 8 ,6 10, 3 12, 5 14, 2 14, 4 18, 2 If required, enter negative values...
A manager at a local bank analyzed the relationship between monthly salary (y, in $) and...
A manager at a local bank analyzed the relationship between monthly salary (y, in $) and length of service (x, measured in months) for 30 employees. She estimates the model: Salary = β0 + β1 Service + ε. The following ANOVA table summarizes a portion of the regression results. df SS MS F Regression 1 555,420 555,420 7.64 Residual 27 1,962,873 72,699 Total 28 2,518,293 Coefficients Standard Error t-stat p-value Intercept 784.92 322.25 2.44 0.02 Service 9.19 3.20 2.87 0.01...
A sales manager for an advertising agency believes there is a relationship between the number of...
A sales manager for an advertising agency believes there is a relationship between the number of contacts that a salesperson makes and the amount of sales dollars earned. A regression analysis shows the following results: Coefficients Standard Error t Stat p value Intercept −12.201 6.560 −1.860 0.100 Number of contacts 2.195 0.176 12.505 0.000 ANOVA df SS MS F Significance F Regression 1.00 13555.42 13555.42 156.38 0.00 Residual 8.00 693.48 86.68 Total 9.00 14248.90 Additional information needed to perform the...
A business is evaluating their advertising budget, and wishes to determine the relationship between advertising dollars...
A business is evaluating their advertising budget, and wishes to determine the relationship between advertising dollars spent and changes in revenue. Below is the output from their regression. SUMMARY OUTPUT Regression Statistics Multiple R 0.95 R Square 0.90 Adjusted R Square 0.82 Standard Error 0.82 Observations 8 ANOVA df SS MS F Significance F Regression 3 23.188 7.729 11.505 0.020 Residual 4 2.687 0.672 Total 7 25.875 Coefficients Std Error t Stat P-value Lower 95% Upper 95% Intercept 83.91 2.03...