The data from exercise 1 follow.
Excel file: data14-23.xls
Compute the mean square error using equation (14.15) (to 3
decimals).
Compute the standard error of the estimate using equation
(14.16) (to 3 decimals).
Compute the estimated standard deviation of b1 using
equation (14.18) (to 3 decimals).
Use the t test to test the following hypotheses ( =
.05):
Compute the value of the t test statistic (to 2
decimals).
What is the p-value?
Selectless than .01between .01 and .02between .02 and .05between
.05 and .10between .10 and .20between .20 and .40greater than
.40Item 5
What is your conclusion?
SelectConclude a significant relationship exists between x and
yCannot conclude a significant relationship exists between x and
yItem 6
Use the F test to test the hypotheses in part (d) at a
.05 level of significance.
Complete the F table below. Calculate the Sum of Squares
(to 1 decimal), the Mean Squares (to 3 decimals if necessary), and
the Fratio (to 2 decimals).
| Source of Variation | Degrees of Freedom | Sum of Squares | Mean Square | F |
| Regression | ||||
| Error | ||||
| Total |
What is the p-value?
Selectless than .01between .01 and .025between .025 and .05between
.05 and .10greater than .10Item 16
What is your conclusion, based on this F test?
SelectConclude a significant relationship exists between x and
yCannot conclude a significant relationship exists between x and
yItem 17
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
