a were collected to determine the relationship nool rank in class and the grade-point average at nan year in college: tion of the regression line to predict the grade-p llege freshmen from high school rank in class; grade-point average for an entering freshman w mird decile of her graduating class. ху sum ( Ey

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
1st Edition
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:HOUGHTON MIFFLIN HARCOURT
Chapter11: Data Analysis And Displays
Section: Chapter Questions
Problem 5CT
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
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
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
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
PREALGEBRA
PREALGEBRA
Algebra
ISBN:
9781938168994
Author:
OpenStax
Publisher:
OpenStax