A group collected data in an experiment to learn to draw suitable trendline in a graph. They don't know the theoretical model, so they are trying to determine one through this experiment. They used Excel to display the data and to find good fit. They tried linear, exponential, and power trendlines. The result of each trial is shown below. The title of the plot contains the name of the trendline used to fit. What should be their analysis based on the result they have so far? Exponential trendline Power trendline 20 18 y = 0.8374e0.47x R² = 0.9851 y=0.8045x1538 R² = 0.981 16 15 14 12 10 10 8 4 2 1 3 4. 6 1 4 5 6 7 Linear trendline 20 y = 3.0209x - 4.6606 R² = 0.9293 15 10 4 6. 8. The linear trendline is good fit The exponential trendline is good fit Any one of the three trendlines seems good candidate The power trendline is the best fit ㅇ

College Physics
11th Edition
ISBN:9781305952300
Author:Raymond A. Serway, Chris Vuille
Publisher:Raymond A. Serway, Chris Vuille
Chapter1: Units, Trigonometry. And Vectors
Section: Chapter Questions
Problem 1CQ: Estimate the order of magnitude of the length, in meters, of each of the following; (a) a mouse, (b)...
icon
Related questions
Question
A group collected data in an experiment to learn to draw suitable trendline in a graph. They don't know
the theoretical model, so they are trying to determine one through this experiment. They used Excel to
display the data and to find good fit. They tried linear, exponential, and power trendlines. The result of
each trial is shown below. The title of the plot contains the name of the trendline used to fit.
What should be their analysis based on the result they have so far?
Exponential trendline
20
Power trendline
18
y = 0.8374e047x
R? = 0.9851
16
y = 0.8045x1.538.
R2 = 0.981
15
14
12
10
10
.....
4
..... .......
2
1
3
4
1
7
Linear trendline
20
y = 3.0209x - 4.6606
15
R? = 0.9293
10
........
2
4
6
8
The linear trendline is good fit
The exponential trendline is good fit
Any one of the three trendlines seems good candidate
The power trendline is the best fit
2.
2.
Transcribed Image Text:A group collected data in an experiment to learn to draw suitable trendline in a graph. They don't know the theoretical model, so they are trying to determine one through this experiment. They used Excel to display the data and to find good fit. They tried linear, exponential, and power trendlines. The result of each trial is shown below. The title of the plot contains the name of the trendline used to fit. What should be their analysis based on the result they have so far? Exponential trendline 20 Power trendline 18 y = 0.8374e047x R? = 0.9851 16 y = 0.8045x1.538. R2 = 0.981 15 14 12 10 10 ..... 4 ..... ....... 2 1 3 4 1 7 Linear trendline 20 y = 3.0209x - 4.6606 15 R? = 0.9293 10 ........ 2 4 6 8 The linear trendline is good fit The exponential trendline is good fit Any one of the three trendlines seems good candidate The power trendline is the best fit 2. 2.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Half life
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, physics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Physics
College Physics
Physics
ISBN:
9781305952300
Author:
Raymond A. Serway, Chris Vuille
Publisher:
Cengage Learning
University Physics (14th Edition)
University Physics (14th Edition)
Physics
ISBN:
9780133969290
Author:
Hugh D. Young, Roger A. Freedman
Publisher:
PEARSON
Introduction To Quantum Mechanics
Introduction To Quantum Mechanics
Physics
ISBN:
9781107189638
Author:
Griffiths, David J., Schroeter, Darrell F.
Publisher:
Cambridge University Press
Physics for Scientists and Engineers
Physics for Scientists and Engineers
Physics
ISBN:
9781337553278
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning
Lecture- Tutorials for Introductory Astronomy
Lecture- Tutorials for Introductory Astronomy
Physics
ISBN:
9780321820464
Author:
Edward E. Prather, Tim P. Slater, Jeff P. Adams, Gina Brissenden
Publisher:
Addison-Wesley
College Physics: A Strategic Approach (4th Editio…
College Physics: A Strategic Approach (4th Editio…
Physics
ISBN:
9780134609034
Author:
Randall D. Knight (Professor Emeritus), Brian Jones, Stuart Field
Publisher:
PEARSON