Question

In: Statistics and Probability

a. Develop the estimated regression equation by using the formula for computing the values for bo...

a. Develop the estimated regression equation by using the formula for computing the values for bo and b1. “ SHOW YOUR WORK” means WRITE the formula and create the columns as needed below follow the steps through. If you need more space below, create them by pressing ENTER
b. Compute SSE, SST, and SSR using only Computing formulas.
c. Compute the coefficient of determination r (The same as R ). Comment on the goodness of fit (That is, what does the value of r tell you about the goodness of the fit). Explain why.
d. Compute the sample correlation coefficient (r). (Hint: You do not need to use the formula for r !)
e. Determine if the slope is significant at Alpha = 0.05ant

y   -3 -1   0   0   7   5   13
x   1   2   3   4   5   6   7

Solutions

Expert Solution

X Y (x-x̅)² (y-ȳ)² (x-x̅)(y-ȳ)
1 -3 9 36 18
2 -1 4 16 8
3 0 1 9 3
4 0 0 9 0
5 7 1 16 4
6 5 4 4 4
7 13 9 100 30
ΣX ΣY Σ(x-x̅)² Σ(y-ȳ)² Σ(x-x̅)(y-ȳ)
total sum 28 21 28 190 67
mean 4 3 SSxx SSyy SSxy

sample size ,   n =   7      
here, x̅ =   4   ,   ȳ =   3
              
SSxx =    Σ(x-x̅)² =    28      
SSxy=   Σ(x-x̅)(y-ȳ) =   67      

a)

slope ,    ß1 = SSxy/SSxx = 67/28 = 2.393          
                  
intercept,   ß0 = y̅-ß1* x̄ = 3-2.393*4 = -6.571          
                  
so, regression line is   Ŷ =   -6.5714   +   2.3929   *x

b)

SSE=   (Sx*Sy - S²xy)/Sx = (28*190-67²)/28 = 29.68

SST=SSyy = 190

SSR=SST-SSE=190-29.68=160.32

c)

coefficient of determination,R² = SSR/SST=0.8438

84.38% of obeservation of Y is explained by X, so, it is a good estimate.

d)

sample correlation coefficient (r). =√R² =√0.8438 = 0.9186

e)

std error ,Se =    √(SSE/(n-2)) =    2.4363

slope hypothesis test              

Ho:   ß1=   0          
H1:   ß1╪   0          
n=   7              
alpha=   0.05              
estimated std error of slope =Se(ß1) =                s/√Sxx = 2.4363/√28 = 0.4604
                  
t stat =    ß1 /Se(ß1) = 2.3929/0.4604 = 5.197   
                  
df=n-2 = 5   
p-value =    0.0035              
decision :    p-value<α , reject Ho

so, there is enough evidence that slope is significant at α=0.05


Related Solutions

a. Develop the estimated regression equation by using the formula for computing the values for bo...
a. Develop the estimated regression equation by using the formula for computing the values for bo and b1. “ SHOW YOUR WORK” means WRITE the formula and create the columns as needed below follow the steps through. If you need more space below, create them by pressing ENTER b. Compute SSE, SST, and SSR using only Computing formulas. c. Compute the coefficient of determination r (The same as R ). Comment on the goodness of fit (That is, what does...
a. Develop an estimated regression equation for the data of the form y-hat = bo + b1 x.
Consider the following data for two variables, X and Y X 6 29 21 15 24 Y 10 30 22 14 25 a. Develop an estimated regression equation for the data of the form y-hat = bo + b1 x. Comment on the adequacy of this equation for predicting y . Enter negative value as negative number. The regression equation is Y = [          ] + [            ] X (to 2 decimals)   S = [       ] (to 3 decimals)...
Develop a scatter diagram for these data. Develop the estimated regression equation.
Given the following: X: 1    2    3 4    5 Y: 3    7    5    11    14 Develop a scatter diagram for these data. Develop the estimated regression equation. Use the estimated regression equation to predict the value of Y when X = 4
Develop an estimated regression equation with annual income and household size as the independent variables. Discuss...
Develop an estimated regression equation with annual income and household size as the independent variables. Discuss your findings - Income ($1000s) Household Size Amount Charged ($) 54 3 4,016 30 2 3,159 32 4 5,100 50 5 4,742 31 2 1,864 55 2 4,070 37 1 2,731 40 2 3,348 66 4 4,764 51 3 4,110 25 3 4,208 48 4 4,219 27 1 2,477 33 2 2,514 65 3 4,214 63 4 4,965 42 6 4,412 21 2 2,448...
Explain the differences between the regression model, the regression equation, and the estimated-regression equation. Discuss the...
Explain the differences between the regression model, the regression equation, and the estimated-regression equation. Discuss the application of regression analysis in business decision making. Give examples on how the regression analysis can be used in business.
a. Develop an estimated regression equation for the data of the form . Comment on the adequacy of this equation for predicting . Enter negative value as negative number.
Consider the following data for two variables,  and . x 6 33 21 17 28 y 12 30 22 16 29 a. Develop an estimated regression equation for the data of the form . Comment on the adequacy of this equation for predicting . Enter negative value as negative number. The regression equation is      (to 2 decimals) (to 3 decimals)   % (to 1 decimal)   % (to 1 decimal) Analysis of Variance SOURCE DF SS (to 2 decimals) MS (to 2...
Develop estimated regression equations, first using annual income as the independent variable and then using household...
Develop estimated regression equations, first using annual income as the independent variable and then using household size as the independent variable. Which variable is the better predictor of annual credit card charges? Discuss your findings - Income ($1000s) Household Size Amount Charged ($) 54 3 4,016 30 2 3,159 32 4 5,100 50 5 4,742 31 2 1,864 55 2 4,070 37 1 2,731 40 2 3,348 66 4 4,764 51 3 4,110 25 3 4,208 48 4 4,219 27...
Develop estimated regression equations, first using annual income as the independent variable and then using household...
Develop estimated regression equations, first using annual income as the independent variable and then using household size as the independent variable. Which variable is the better predictor of annual credit card charges? Discuss your findings - Income ($1000s) Household Size Amount Charged ($) 54 3 4,016 30 2 3,159 32 4 5,100 50 5 4,742 31 2 1,864 55 2 4,070 37 1 2,731 40 2 3,348 66 4 4,764 51 3 4,110 25 3 4,208 48 4 4,219 27...
Using the data in the Excel file under the tab Problem1, develop a regression equation for...
Using the data in the Excel file under the tab Problem1, develop a regression equation for a country’s lung cancer death rate based on cigarette consumption. Is this a good regression model?  Why or why not? If Cigarette Consumption was 725, what would you predict the Lung Cancer Death Rate to be? Using your regression model, what is the Residual Value for Finland? Do you think there are any outliers in the model?  If so, what would you do with them? Country...
Consider the following estimated regression equation, based on 10 observations. y^=29.1270+.5906x1+.4980x2 The values of SST and...
Consider the following estimated regression equation, based on 10 observations. y^=29.1270+.5906x1+.4980x2 The values of SST and SSR are SST= 6724.125 and SSR = 6216.375, respectively. a) Compute the value of MSR. your answers to 3 decimal places. b) For the estimated regression equation given, compute R2(multiple coefficient of determination).Round your answers to 3 decimal places. c) Predict a value of y when x1=180 and x2=310 (Round your answers to 3 decimal places). d) For the estimated regression equation given, compute...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT