Question

In: Statistics and Probability

a. Construct a scatterplot of the data and tell why a linear regression model is appropriate....

a. Construct a scatterplot of the data and tell why a linear regression model is appropriate. (Include this graph in your report.)   b. Run the linear regression procedure on StatCrunch and include the output in your report. c. Give the regression equation using the correct notation. d. Give the Coefficient of Determination AND interpret it.   e. Check the assumptions of the model by constructing each of the following plots and commenting on what they suggest in terms of the assumptions. (Include these graphs in your report.) 1. Fitted line plot 2. QQ-Plot of the residuals 3. Predicted values vs residuals


f. Test to see if the ‘before reading’ is useful in predicting the ‘after reading’. (Use ? = 0.05.) g. Instruct StatCrunch to save the 95% confidence intervals for the mean response. BUT DO NOT INCLUDE THE TABLE IN YOUR PROJECT. IT’S VERY BIG.   h. Use the table you created in part g to give the 95% confidence interval for the average ‘after reading’, when the ‘before reading’ is 60 bpm. i. Test to see if the ‘before reading’ and the ‘after reading’ are positively linearly correlated. (Use ? = 0.05.)

NOTE: Opinions may differ on whether or not the assumptions are met. For the sake of instruction, assume you can continue with the linear regression model to complete the project.

Pulse Rate Before (bpm) Pulse Rate After (bpm)
89 77
85 70
82 73
58 56
61 58
64 61
60 59
59 57
63 61
61 59
64 62
63 58
68 60
65 65
66 72
60 54
59 55
59 56
60 57
58 57
59 57
82 77
73 68
77 75
75 73
79 75
81 78
78 69
80 72
76 69
90 83
87 82
94 82
92 84
105 86
108 84
85 70
80 67
77 66
83 65
72 69
70 68
75 75
98 87
107 90
103 88
100 84
95 82
105 91
93 88
102 90
110 89
57 41
49 39
50 37
53 49
56 50
49 44
57 55
48 49
50 48
69 65
67 64
68 66
82 64
75 66
79 71
77 76
74 72
76 72
74 74
72 69
75 73
73 77
72 77
70 73
75 62
70 64
72 77
61 46
63 57
64 75
85 57
79 61
77 73
73 67
76 61
78 69
68 64
71 60
77 69
91 84
89 87
86 88
74 69
77 73
76 70
75 57
79 61
73 61
75 59
79 65
72 80
74 70
92 86
66 72
65 66
64 66
62 60
66 70
63 68

Solutions

Expert Solution

Answer using Excel:

a. Construct a scatterplot of the data and tell why a linear regression model is appropriate. (Include this graph in your report.)  

b. Run the linear regression procedure on StatCrunch and include the output in your report.

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.858003
R Square 0.73617
Adjusted R Square 0.733749
Standard Error 6.102274
Observations 111
ANOVA
df SS MS F Significance F
Regression 1 11325.64 11325.64 304.1442 2.57E-33
Residual 109 4058.914 37.23775
Total 110 15384.56
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 13.51595 3.180927 4.249059 4.54E-05 7.211453 19.82044 7.211453 19.82044
Pulse Rate Before (bpm) 0.733551 0.042062 17.43973 2.57E-33 0.650185 0.816917 0.650185 0.816917

c. Give the regression equation using the correct notation.

y = 0.733x + 13.51

d. Give the Coefficient of Determination AND interpret it.

R = Coefficient of Defermination = sqrt(R squared) =0.858.

Correlation is positive and strong.

Post remaining questions saperately. Hope thsi will be helpful. Thanks and God Bless You :)


Related Solutions

Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and...
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and determine the predicted total sales value if the number of promotions is 6. Is there a significant relationship? Clearly explain your reasoning using the regression results. Number of Promotions Total Sales 3 2554 2 1746 11 2755 14 1935 15 2461 4 2727 5 2231 14 2791 12 2557 4 1897 2 2022 7 2673 11 2947 11 1573 14 2980
Using the data from boston_housing.xls (accessible online) a.) do the appropriate multiple linear regression model procedures...
Using the data from boston_housing.xls (accessible online) a.) do the appropriate multiple linear regression model procedures to obtain a final model
When we estimate a linear multiple regression model (including a linear simple regression model), it appears...
When we estimate a linear multiple regression model (including a linear simple regression model), it appears that the calculation of the coefficient of determination, R2, for this model can be accomplished by using the squared sample correlation coefficient between the original values and the predicted values of the dependent variable of this model. Is this statement true? If yes, why? If not, why not? Please use either matrix algebra or algebra to support your reasoning.
a. What is data transformation in the context of linear regression and why it is needed?...
a. What is data transformation in the context of linear regression and why it is needed? b. Please list different transformation techniques with a brief explanation for each.
Construct a scatterplot, find the value of the linear correlation coefficient r, find the critical value...
Construct a scatterplot, find the value of the linear correlation coefficient r, find the critical value of r from Table A-6 by using a 0.05, and determine whether there is a linear correlation between the two variables. Song Audiences and Sales The table below lists the numbers of audience impressions (in hundreds of millions) listening to songs and the corresponding numbers of albums sold (in hundreds of thousands). The number of audience impressions is a count of the number of...
Discuss the underlying assumptions of a simple linear regression model; multiple regression model; and polynomial regression.
Discuss the underlying assumptions of a simple linear regression model; multiple regression model; and polynomial regression.
The following data is to be used to construct a regression model: x 5 7 4...
The following data is to be used to construct a regression model: x 5 7 4 15 12 9 y 8 9 10 22 16 12 The value of SSE is ____________.
Use Excel to estimate a simple linear regression model for the following data (Y is a...
Use Excel to estimate a simple linear regression model for the following data (Y is a dependent variable and X is an independent variable): Y X 0 -2 0 -1 1 0 1 1 3 2 Fill in Multiple Blanks: What is the slope of the estimated line?  In your answer, show one (1) digit to the right of the decimal point, for example, 1.0, 1.2. Apply the appropriate rounding rule if necessary. What is the Y-intercept?
Explain why you choose multiple regression with dummy variables but not linear trend model and why...
Explain why you choose multiple regression with dummy variables but not linear trend model and why do you believe this technique is appropriate to forecast your data?
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary...
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.                                                           Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.                                                           
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT