Homework Help is Here – Start Your Trial Now!
Math
Statistics
Instruction. Please use excel to answer the following problems. Present your solution and your answers in MS Word. (Copy the result of the excel in MS Word) 1. You have to examine the relationship between the age and price for used instrument sold in the last year by a company. Here is the table of the data: Used Instrument (in Price Year) 4 315 4 290 5 285 225 7 225 7 210 8 205 9 155 10 105 4 300 3 309 a. Determine the degree of relationship between in instument's age and the price. b. Identify the equation of linear regression. c. How much will a used instrument worth after 6 years? 12 years? 15 years?

Instruction. Please use excel to answer the following problems. Present your solution and your answers in MS Word. (Copy the result of the excel in MS Word) 1. You have to examine the relationship between the age and price for used instrument sold in the last year by a company. Here is the table of the data: Used Instrument (in Price Year) 4 315 4 290 5 285 225 7 225 7 210 8 205 9 155 10 105 4 300 3 309 a. Determine the degree of relationship between in instument's age and the price. b. Identify the equation of linear regression. c. How much will a used instrument worth after 6 years? 12 years? 15 years?

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter11: Data Analysis And Probability
Section11.3: Using Data Displays
Problem 2C
See similar textbooks
icon
Related questions
Question

Can you please indicate the step by step on excel please. 

Instruction. Please use excel to answer the following problems. Present your solution and your answers in MS Word. (Copy the result of the excel in MS Word) 1. You have to examine the relationship between the age and price for used instrument sold in the last year by a company. Here is the table of the data: Used Instrument (in Price Year) 315 4 290 285 5 225 7 225 7 210 205 155 8 10 105 4 300 3 309 a. Determine the degree of relationship between in instument's age and the price. b. Identify the equation of linear regression. c. How much will a used instrument worth after 6 years? 12 years? 15 years? d. Explain the predicting capability of the equation.
Transcribed Image Text:Instruction. Please use excel to answer the following problems. Present your solution and your answers in MS Word. (Copy the result of the excel in MS Word) 1. You have to examine the relationship between the age and price for used instrument sold in the last year by a company. Here is the table of the data: Used Instrument (in Price Year) 315 4 290 285 5 225 7 225 7 210 205 155 8 10 105 4 300 3 309 a. Determine the degree of relationship between in instument's age and the price. b. Identify the equation of linear regression. c. How much will a used instrument worth after 6 years? 12 years? 15 years? d. Explain the predicting capability of the equation.
Expert Solution
steps

Step by step

Solved in 2 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Elementary Algebra
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
SEE MORE TEXTBOOKS