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?
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?
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.
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?
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.
|Due By (Pacific Time)||03/20/2014 10:00 am|
out of 1971 reviews
out of 766 reviews
out of 1164 reviews
out of 721 reviews
out of 1600 reviews
out of 770 reviews
out of 766 reviews
out of 680 reviews