# Project #10372 - Statistics

 The director of admissions of a small college selected 240 student scores at random from the new freshman class in a study to determine whether a student's GPA (Y) at the end of the freshman year could be predicted from the ACT test score(X). The results of the study are listed in the Excel file "Name_Final". Assume a first order regression. a. Obtain the least square estimates of Bo & B1, and state the estimated regression function (equation) b. Plot the estimated regression function and the data, does the estimated model fit the data well? c. Obtain point estimates of the mean freshman GPA for students with ACT scores given by 1. Xi1= 32, 2. Xi2=29 & 3. Xi3=22.5 d. Analyze the value of R squared from the regression output, what does it mean? e. Obtain descriptive statistics using Excel f. Comment on the standard deviations for GPA and ACT g. Is this model better than the model obtained by using the data of 120 students (see solutin file posted on Moodle)? Why is it better / worse / no different? Question g is optional and for extra credit only Submit your regression solution as one single Excel file only, with your name in the file name as "John_Final"

 Subject Mathematics Due By (Pacific Time) 08/17/2013 12: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