I don't have the time to do this and I just need it done! The professor told us that it can be done on Microsoft excel. 1. The local town government has been keeping track of interest rates and construction permits. Below is the data that they have gathered. Rates 5.6% 3.7% 6.2% 8.5% 4.8% 5.0% 3.5% Permits 1150 1650 800 420 1300 870 1550 a) Is the data linear? (Find correlation coefficient) b) Develop an equation to predict the number of construction permits based upon interest rates. c) Forecast the number of construction starts if the interest rate is 4.6 2. A marketing professor at Givens College is interested in the relationship between hours spent studying, sat composite score (Verbal and Math), and the total points earned in a course. Data collected on 10 students who took the course last quarter follow. Hrs. Studying 55 35 90 60 105 65 90 80 55 75 SAT Score 1150 950 1200 1150 1120 960 1210 1070 870 1140 Total Pts. Earned 45 38 73 66 90 50 90 80 45 65 a) Develop an estimated regression equation relating total points earned to hours spent studying. b) Test the significance of the model with α=.05. 1) H0 β0 = 0 Ha β0 ≠ 0 2) H0 β1 = 0 Ha β1 ≠ 0 3) H0 β2 = 0 Ha β2 ≠ 0 c) Predict the total points earned by a student, if she spent 70 hours studying and an SAT of 1090. 3.Given the following output: SUMMARY OUTPUT Regression Statistics Multiple R 0.653135248 R Square 0.826585652 Adjusted R Square 0.818322066 Standard Error 1.482595134 Observations 6 ANOVA df SS MS F Significance F Regression 1 6.540980004 6.540980004 2.975758485 0.159606191 Residual 4 8.792353329 2.198088332 Total 5 15.33333333 Coefficients Standard Error t Stat P-value Intercept 42.73236651 0.093240674 1.725031246 0.9603422 X Variable 1 0.160843771 14.85314478 3.876753452 0.3414746 a) Write the regression model. b) What is the coefficient of determination? What does it mean? c) Test H0 β1 = 0 vs. Ha β1 ≠ 0, for α=.05.

Subject | Mathematics |

Due By (Pacific Time) | 05/12/2014 05:00 pm |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |