Use Excel to find a correlation coefficient between a set of data pairs

Описание: View full question and answer details: https://www.wyzant.com/resources/answ...

Question: Linear Regression Question
To compare textbook prices at the two most popular online booksellers, a Statistics student gathered information about 14 college textbooks from Amazon.com and bn.com on November 25, 2006. For each book, she recorded the name of the principal author, the title, the ISBN, the Amazon selling price (in dollars) and the B&N selling price (in dollars):

author
title
ISBN
Amazon
B&N


De Veaux
Intro Stats
321286715
120.67
103.20


Christensen
Introduction to Statistics
155459651
164.95
155.95


Thomas
Calculus
321185587
154.67
152.00


Stewart
Calculus
534393217
153.98
155.75


Simmons
Calculus with Analytic Geometry
70576424
150.00
159.75


Alexander
American Public School Law
534274242
128.95
115.85


Miller
Business Law Today
324204841
108.95
103.95


Cheeseman
Business Law
131984934
166.67
159.60


Berg
Biochemistry
716787245
149.95
148.91


Raymond
General Organic and Biological Chemistry
471447072
 95.95
98.95


Atkins
Chemical Principles
071675701X
141.95
139.75


Warren
F...

------------------------

Answered By:

Robert Z.
Wide experience tutoring practical applications of math
More information: https://www.wyzant.com/Tutors/MA/Ando...

------------------------

See full answer: https://www.wyzant.com/resources/answ...

------------------------

About: Wyzant Ask an Expert offers free answers to your toughest academic and professional questions from over 65,000 verified experts. It’s trusted by millions of students each month with the majority of questions receiving an answer within 1 hour of being asked. If you ever need more than just an answer, Wyzant also offers personalized 1-on-1 sessions with experts that will work with you to help you understand whatever you’re trying to learn.

Ask your own question for free: https://www.wyzant.com/resources/answ...
Find a tutor for a 1-on-1 session: https://www.wyzant.com?utm_source=you...
Subscribe to Wyzant on YouTube: https://www.youtube.com/subscription_...