For all hypothesis tests, assume that the level of significance is 0.05 unless otherwise stated.

Exercise-2: See Appendix 6.2 for chart with trendline.

Using the data in the Excel file Student Grades, construct

a scatter chart for midterm versus final exam grades

and add a linear trendline. What is the regression model

and R^2? If a student scores 85 on the midterm, what

would you estimate her grade on the final exam to be?

Exercise-4:

Use the 2010 data in the Excel files S&P 500 and Google

Stock Prices to find the beta risk of Google stock using simple linear regression. How do you interpret your result?

Exercise-7:

Using the data in the Excel file Student Grades, run

a regression analysis using the midterm grade as the

independent variable and the final exam grade as the

dependent variable. Interpret all key regression results,

hypothesis tests, and confidence intervals in the output.

Exercise-10:

A deepâ€Âfoundation engineering contractor has bid on a

foundation system for a new world headquarters building for a Fortune 500 company. A part of the project

consists of installing 311 auger cast piles. The contractor

was given bid information for costâ€Âestimating purposes,

which consisted of the estimated depth of each pile;

however, actual drill footage of each pile could not be

determined exactly until construction was performed.

The Excel file Pile Foundation contains the estimates

and actual pile lengths after the project was completed.

Develop a linear regression model to estimate the actual

pile length as a function of the estimated pile lengths.

What do you conclude?

Exercise 12:

Using the data in the Excel file Home Market Value,

develop a multiple linear regression model for estimating the market value as a function of both the age and

size of the house. Find a 95% confidence interval for the

mean market value for houses that are 30 years old and

have 1,800 square feet and a 95% prediction interval for

a house that is 30 years old with 1,800 square feet.

Subject | General |

Due By (Pacific Time) | 03/20/2014 10:00 am |

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