# Project #25504 - Statistics HW

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
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews