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
Report DMCA
TutorRating
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..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy