A department of transportation's study on driving speed and miles per gallon for midsize automobiles resulted in the following data. Speed (Miles per hour) 30 50 40 55 30 25 60 25 50 55 Miles per Gallon 29 24 25 23 29 31 21 35 27 26 Compute the sample correlation coefficient using the =CORREL(x,y) function in excel. (Round your answer to two decimal places.) Interpret the sample correlation coefficient. There is --Select--- relationship between the driving speed and miles per gallon. For driving speed between 25 and 60 miles per hour, higher speeds are associated with ---Select-- miles per gallon.
A department of transportation's study on driving speed and miles per gallon for midsize automobiles resulted in the following data. Speed (Miles per hour) 30 50 40 55 30 25 60 25 50 55 Miles per Gallon 29 24 25 23 29 31 21 35 27 26 Compute the sample correlation coefficient using the =CORREL(x,y) function in excel. (Round your answer to two decimal places.) Interpret the sample correlation coefficient. There is --Select--- relationship between the driving speed and miles per gallon. For driving speed between 25 and 60 miles per hour, higher speeds are associated with ---Select-- miles per gallon.
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.6: Regression And Median-fit Lines
Problem 1AGP
Related questions
Question
Transcribed Image Text:A department of transportation's study on driving speed and miles per gallon for midsize automobiles resulted in the following data.
40
Speed (Miles per Hour) 30
50
40
Miles per Gallon
29
24
24
25
25
55 30
23
23 29
31
60
25
60
50
50
55
21
21 35 27
26
Compute the sample correlation coefficient using the = CORREL(x,y) function in excel. (Round your answer to two decimal places.)
Interpret the sample correlation coefficient.
There is ---Select---
gallon.
relationship between the driving speed and miles per gallon. For driving speed between 25 and 60 miles per hour, higher speeds are associated with ---Select--- | miles per
Transcribed Image Text:The following data were used in a regression study.
Observation 1
2
3
4
5
6 7 8
6
00
xi
2
3
4
5
7 7
7
8
9
Yi
5
5
st
4
st
60
4
6
10
9
5
11
(a) Develop an estimated regression equation for these data. (Round your numerical values to two decimal places.)
ŷ =
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
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…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
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…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL