A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
10th Edition
ISBN: 9780134753119
Author: Sheldon Ross
Publisher: PEARSON
Bartleby Related Questions Icon

Related questions

Question

Please help me solve this using excel. Our topic is Line Regression

Assignment
The following data were collected to determine the relationship
between high school rank in class and the grade-point average at the
end of the freshman year in college:
a) Find the equation of the regression line to predict the grade-point
average of college freshmen from high school rank in class;
b) B) Predict the grade-point average for an entering freshman who
ranks in the third decile of her graduating class.
x
y xy sum(
ху
En
expand button
Transcribed Image Text:Assignment The following data were collected to determine the relationship between high school rank in class and the grade-point average at the end of the freshman year in college: a) Find the equation of the regression line to predict the grade-point average of college freshmen from high school rank in class; b) B) Predict the grade-point average for an entering freshman who ranks in the third decile of her graduating class. x y xy sum( ху En
grade-point average y
decile rank x
1.93
2.55
1.72
2.48
2.87
1.87
1.34
3.03
2.54
2.34
1.4
1.45
1.72
3.8
2.13
1.81
2.33
2.53
2.04
3.2
3
2
1
1
1
3
4
1
2
2
8
4
8
1
5
6
1
1
2
2
expand button
Transcribed Image Text:grade-point average y decile rank x 1.93 2.55 1.72 2.48 2.87 1.87 1.34 3.03 2.54 2.34 1.4 1.45 1.72 3.8 2.13 1.81 2.33 2.53 2.04 3.2 3 2 1 1 1 3 4 1 2 2 8 4 8 1 5 6 1 1 2 2
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
A First Course in Probability (10th Edition)
Probability
ISBN:9780134753119
Author:Sheldon Ross
Publisher:PEARSON
Text book image
A First Course in Probability
Probability
ISBN:9780321794772
Author:Sheldon Ross
Publisher:PEARSON