Asked Sep 11, 2019

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.



Expert Answer

Step 1


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...

Image Transcriptionclose

SUMMARY OUTPUT Regression Statistics Multiple R R Square 0.919238816 0.845 0.793333333 Adjusted R Square Standard Error 2.033060091 Observations ANOVA Significance F 67.6 16.35483871 0.027214829 df SS MS Regression 1 67.6 3 Residual 12.4 4.133333333 Total 4 80 Lower 95.0 % Lower 95% Coefficients Standard Error Upper 95% Upper 95.0 % t Stat P-value 0.2 2.132291412 0.09379581 0.931184657 -6.585902927 6.985902927 -6.585902927 6.985902927 Intercept X1 2.6 0.642910051 4.044111609 0.027214829 0.553973284 4.646026716 0.553973284 4.646026716


Want to see the full answer?

See Solution

Check out a sample Q&A here.

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



Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: How to prove that n peices of information in Sumation of i=1 to n (xi-xbar) = zero. also known as no...

A: We want to prove 


Q: Determine the level of measurement of the variable. Favorite colorChoose the correct level of measur...

A: The level of measurement of the variable “favorite color” is nominal level of measurement, that is, ...


Q: How do I Identify the class with the​ greatest, and the class with the​ least, relative frequency?

A: The aim is to find the way to find the class with the greatest, and the class with the least, relati...


Q: Stories in the Tallest Builidings The numbers of stories in the 13 tallest buildings are for two dif...

A: Measures of variability:The measure of variability or the measures of dispersion can be measured usi...


Q: What are the differences between content validity, construct validity, and concurrent validity?

A: Click to see the answer


Q: If a given line has a negative slope, then what is the sign of the slope of the line that is perpend...

A: Relationship between slopes of two perpendicular straight lines:The slopes of two lines, which are p...


Q: Use a χ2​-test to test the claim σ2=0.49 at the α=0.10 significance level using sample statistics s2...

A: In order to test the hypothesis of H0: sigma square  is equal to 0.49  versus Ha: sigma square not e...


Q: Nearly one half of americans aged 25 to 29 are unmarried.  How large a sample is necessary to estima...

A: The formula for the sample size is as follows:


Q: What are criterion, convergent, divergent, and diagnostic validity?

A: Criterion-related validity:A test is said to have criterion-related validity, if it helps to predict...