7. Determine the equation, which will represent the best line for the following set of data and plot the graph of the equation in an MS Excel worksheet. Method of Least Squares Y XX ху 1 4.6 2 1 7.1 1 7.1 2 9.5 4 19.0 4 3 11.5 9 34.5 5 4 13.7 16 54.8 6 5 15.9 25 79.5 7 18.6 36 111.6 8 7 20.9 49 146.3 8 23.5 64 188.0 10 25.4 81 228.6

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 1GP
icon
Related questions
Question
Show the graph
7. Determine the equation, which will represent the best line for the following set of data and
plot the graph of the equation in an MS Excel worksheet.
Method of Least Squares
Y
4.6
XX
ху
1
2
7.1
1
7.1
3
9.5
4
19.0
4
11.5
9
34.5
5
4
13.7
16
54.8
5
15.9
25
79.5
7
18.6
36
111.6
8
7
20.9
49
146.3
8
23.5
64
188.0
10
9
25.4
81
228.6
Transcribed Image Text:7. Determine the equation, which will represent the best line for the following set of data and plot the graph of the equation in an MS Excel worksheet. Method of Least Squares Y 4.6 XX ху 1 2 7.1 1 7.1 3 9.5 4 19.0 4 11.5 9 34.5 5 4 13.7 16 54.8 5 15.9 25 79.5 7 18.6 36 111.6 8 7 20.9 49 146.3 8 23.5 64 188.0 10 9 25.4 81 228.6
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
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