Question

In: Statistics and Probability

Fill in the empty cells in the following table in order to calculate the standard error of the estimate.

 

Fill in the empty cells in the following table in order to calculate the standard error of the estimate. 

X

Y

     

3

3

6.00

-3.00

9.00

6

9

7.50

1.50

2.25

5

8

7.00

1.00

1.00

4

3

6.50

3.50

12.25

7

10

8.00

2.00

4.00

5

9

7.00

2.00

4.00

---------------

---------------

---------------

---------------

Sum = 32.5

Note: Sum in the last column is , which is SSresidual.

F. Use the formula and information on p.15 of the Week 12_3 slides. What is the value of the standard error of estimate?What is the value of the residual variance or error variance (MSresidual)? (2 decimals)  

= 2.85

MSresidual = 8.13

G. Use the correlation coefficient you have calculated and p.16 of the Week 12_3 slides. Calculate the coefficient of determination (r2) and interpret its meaning in one sentence. [2 marks]

r2 = 0.800

. Fill in the empty cells in the following table in order to calculate the standard error of the estimate. 

X

Y

     

3

3

6.00

-3.00

9.00

6

9

7.50

1.50

2.25

5

8

7.00

1.00

1.00

4

3

6.50

3.50

12.25

7

10

8.00

2.00

4.00

5

9

7.00

2.00

4.00

---------------

---------------

---------------

---------------

Sum = 32.5

Note: Sum in the last column is , which is SSresidual.

F. Use the formula and information on p.15 of the Week 12_3 slides. What is the value of the standard error of estimate?What is the value of the residual variance or error variance (MSresidual)? (2 decimals) 

= 2.85

MSresidual = 8.13

G. Use the correlation coefficient you have calculated and p.16 of the Week 12_3 slides. Calculate the coefficient of determination (r2) and interpret its meaning in one sentence.  

r2 = 0.800





Solutions

Expert Solution

X Y Fitted value (Y^) Residual (e)=Y-Y^ Residual square=e^2
3 3 6 -3 9
6 9 7.5 1.5 2.25
5 8 7 1 1
4 3 6.5 3.5 12.25
7 10 8 2 4
5 9 7 2 4
30 42 42 7 32.5

F. Use the formula and information on p.15 of the Week 12_3 slides. What is the value of the standard error of estimate? What is the value of the residual variance or error variance (MSresidual)? (2 decimals) [2 marks]

Ans:

Standard error of estimate=sqrt(SSresidual/(6-2))= sqrt(32.5/4)= 2.85

Residual variance= SSresidual/(6-2)= 32.5/4=MSresidual = 8.13

G. Use the correlation coefficient you have calculated and p.16 of the Week 12_3 slides. Calculate the coefficient of determination (r2) and interpret its meaning in one sentence. [2 marks]

r2 = 0.800

ANS;

Interpretation: 80.00% variation of the total variable of Y is explained by the explanatory variable X.


Related Solutions

a. For the cases below, calculate the standard error for estimate of the proportion?
a. For the cases below, calculate the standard error for estimate of the proportion?                                              n = 500 and p = 0.1                                             n = 100 and p = 0.92                       b. Comment on whether the sample sizes are large enough so that the sample proportions can be approximated by a normal distribution
Type or paste question here Fill in the empty cells and the values required in the...
Type or paste question here Fill in the empty cells and the values required in the last row of the table. These values will help you answer subsequent questions and calculate the Pearson’s r and the linear regression equation. (2 decimals) X Y ()( 3 3 -2.00 -4.00 4.00 16.00 8.00 6 9 1.00 2.00 1.00 4.00 2.00 5 8 0.00 1.00 0.00 1.00 0.00 4 3 -1.00 -4.00 1.00 16.00 4.00 7 10 2.00 3.00 4.00 9.00 6.00 5...
(a) What is the value of the standard error of the estimate?
Consider the data. xi 2 6 9 13 20 yi 6 19 10 25 23 (a) What is the value of the standard error of the estimate? (Round your answer to three decimal places.) (b) Test for a significant relationship by using the t test. Use α = 0.05. State the null and alternative hypotheses. H0: β1 = 0 Ha: β1 ≠ 0H0: β0 = 0 Ha: β0 ≠ 0    H0: β1 ≠ 0 Ha: β1 = 0H0: β0 ≠...
B – Compute the Standard Error of the estimate.
    Xi 3 12 6 20 14 Yi 55 40 55 10 15                 B – Compute the Standard Error of the estimate.           
In order to calculate the estimated standard error of the mean, one need only know A...
In order to calculate the estimated standard error of the mean, one need only know A the sample’s standard deviation and the size of the sample B the sample mean C the parameter mean D the standard deviation of the distribution of individual scores
Find the point estimate, the standard error, and the margin of error for the given confidence...
Find the point estimate, the standard error, and the margin of error for the given confidence level and values of x and n. x=45, n=97, confidence level 95% (a) Find the point estimate. (b) Find the standard error. (c) Find the margin of error.
Use Excel to calculate the values to fill in the empty boxes. Feel free to add...
Use Excel to calculate the values to fill in the empty boxes. Feel free to add additional tables and calculations as needed. Please use the assignment 1 discussion board to ask questions. Once completed, save this file and upload it in Canvas. Historical Demand Data 2012 to 2016: The table reproduced below is the demand data for a company (aggregated) for the previous five years. 2012 2013 2014 2015 2016 Q1 11632 15034 16117 15565 16470 Q2 22509 26824 24169...
Use Excel to calculate the values to fill in the empty boxes. Feel free to add...
Use Excel to calculate the values to fill in the empty boxes. Feel free to add additional tables and calculations as needed. Historical Demand Data 2012 to 2016: The table reproduced below is the demand data for a company (aggregated) for the previous five years. 2012 2013 2014 2015 2016 Q1 11632 15034 16117 15565 16470 Q2 22509 26824 24169 20151 42858 Q3 21646 13314 14505 13392 19278 Q4 11355 10698 11176 10613 13934 Annual Demand 67,142 65,870 65,967 59,721...
Fill in the following table, supplying all the missing information. Use this information to calculate the...
Fill in the following table, supplying all the missing information. Use this information to calculate the security’s beta. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your Return Deviations answers as a whole number percentage. Round Squared Deviations, Product of Deviations answers to 5 decimal places and Security's beta answer to 2 decimal places. Omit the "%" sign in your response.)...
Please fill in the rest of the table below. For theoretical potential, % error, cell reactions...
Please fill in the rest of the table below. For theoretical potential, % error, cell reactions for cathode, anode and net, and delta G in kJ. Table 1 Cell Measured Total Potential from Multimeter (V)1 Individual Half-Cell Potentials Cell Reactions (anode, cathode, and net) Delta G (kJ) Cu Electrode Standard Potential (V)2 Metal Electrode Experimental Potential (V)3 Metal Electrode Theoretical Potential (V)4 Metal Electrode Potential % Error Cu Sn 0.419 0.34 -0.079 Cu Al 0.632 0.34 -0.292 Cu Fe 0.461...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT