# Question 3: From the data below;x1 1 2 3 4 5y1 3 7 5 11 14a) Compute the mean square error b) Compute the standard error of the estimate c) Compute the estimated standard deviation of b1 d) Use the t-test to test the following hypothesis (α= .05)Ho: β1 = 0Ha: β1 ≠ 0e) Use the F-test to test the hypotheses in part (d) at a 0.5 level of significance. Present in the analysis of variance format.

Question
3 views

Question 3:
From the data below;
x1 1 2 3 4 5
y1 3 7 5 11 14

a) Compute the mean square error
b) Compute the standard error of the estimate
c) Compute the estimated standard deviation of b1
d) Use the t-test to test the following hypothesis (α= .05)
Ho: β1 = 0
Ha: β1 ≠ 0
e) Use the F-test to test the hypotheses in part (d) at a 0.5 level of significance. Present in the analysis of variance format.

check_circle

Step 1

(a)

Step-by-step procedure to obtain the mean square error using EXCEL software:

• Create the variable time in first column and 2 indicator variables in second and third columns.
• Select Data > Data Analysis > Regression.
• Click OK.
• Under Input Y Range enter \$A\$1:\$A\$6.
• Under Input X Range enter \$B\$1:\$C\$6.
• Click the box of Labels.
• Under...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in