X Y 12.39999962 11.19999981 14.30000019 12.5 14.5 12.69999981 14.89999962 13.10000038 16.10000038 14.10000038 16.89999962 14.80000019 16.5 14.39999962 15.39999962 13.39999962 17 14.89999962 17.89999962 15.60000038 18.79999924 16.39999962 20.29999924 17.70000076 22.39999962 19.60000038 19.39999962 16.89999962 15.5 14 16.70000076 14.60000038 17.29999924 15.10000038 18.39999962 16.10000038 19.20000076 16.79999924 17.39999962 15.19999981 19.5 17 19.70000076 17.20000076 21.20000076 18.60000038

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter3: Data Representation
Section: Chapter Questions
Problem 4PE
icon
Related questions
Question

please use python
Following is a small dataset of list price vs. best price for a new GMC pickup truck in  $1000s. The x represents the list price, whereas the y represents the best price values (please see picture). 

a. Determine the Pearson’s correlation coefficient between the list price and best price.  

b. Establish a linear regression relationship between list price and best price.  

c. Based on the relationship you found, determine the best price of a pickup whose list price is 25.2 in $1000s. 

 

X
Y
12.39999962 11.19999981
14.30000019
12.5
14.5 12.69999981
14.89999962 13.10000038
16.10000038 14.10000038
16.89999962 14.80000019
16.5 14.39999962
15.39999962 13.39999962
17 14.89999962
17.89999962 15.60000038
18.79999924 16.39999962
20.29999924 17.70000076
22.39999962 19.60000038
19.39999962 16.89999962
15.5
14
16.70000076 14.60000038
17.29999924 15.10000038
18.39999962 16.10000038
19.20000076 16.79999924
17.39999962 15.19999981
19.5
17
19.70000076 17.20000076
21.20000076 18.60000038
Transcribed Image Text:X Y 12.39999962 11.19999981 14.30000019 12.5 14.5 12.69999981 14.89999962 13.10000038 16.10000038 14.10000038 16.89999962 14.80000019 16.5 14.39999962 15.39999962 13.39999962 17 14.89999962 17.89999962 15.60000038 18.79999924 16.39999962 20.29999924 17.70000076 22.39999962 19.60000038 19.39999962 16.89999962 15.5 14 16.70000076 14.60000038 17.29999924 15.10000038 18.39999962 16.10000038 19.20000076 16.79999924 17.39999962 15.19999981 19.5 17 19.70000076 17.20000076 21.20000076 18.60000038
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning