How to compute for the 1.  ∑x2   2.  ∑ y2 3. ∑xy of this data set for linear regression using Excel?

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
1st Edition
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:HOUGHTON MIFFLIN HARCOURT
Chapter6: Exponential Functions And Sequences
Section6.6: Geometric Sequence
Problem 55E
icon
Related questions
Question

How to compute for the

1.  ∑x2  

2.  ∑ y2

3. ∑xy

of this data set for linear regression using Excel?

grade-point average y
decile rank x
1.93
3
2.55
2
1.72
1
2.48
1
2.87
1
1.87
3
1.34
4
3.03
1
2.54
2.34
2
1.4
8
1.45
4
1.72
8
3.8
1
2.13
1.81
2.33
1
2.53
1
2.04
2
3.2
2
Mean
2.254
2.9
Sum
45.08
58
Sum of squares of x
2.
5.
Transcribed Image Text:grade-point average y decile rank x 1.93 3 2.55 2 1.72 1 2.48 1 2.87 1 1.87 3 1.34 4 3.03 1 2.54 2.34 2 1.4 8 1.45 4 1.72 8 3.8 1 2.13 1.81 2.33 1 2.53 1 2.04 2 3.2 2 Mean 2.254 2.9 Sum 45.08 58 Sum of squares of x 2. 5.
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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning