Question
Each table in the accompanying LineFit data contains a set of data that describes a functional relationship between the dependent variable y and the independent
Each table in the accompanying LineFit data contains a set of data that describes a functional relationship between the dependent variable y and the independent variable x. Construct a scatter chart of each data set and use the Trendline tool in Excel to determine thebest-fitting functions to model these data sets. Do not consider polynomials beyond the third degree
Data:
x y
1 -103.4
1.5 -35.1
2 -5.6
2.5 -18.0
3 -5.8
3.5 -3.7
4 -2.0
4.5 -0.1
5 0.0
5.5 0.2
6 0.9
6.5 3.3
7 8.9
7.5 9.9
8 20.5
8.5 51.2
9 102.1
9.5 143.0
10 24.7
10.5 188.2
What is the equation for thebest-fitting function for the first dataset? Select the correct choice below and fill in any answer boxes to complete your choice.
(Type integers or decimals rounded to three decimal places asneeded.)
A.
y=
nothing
ln(x)+
B.
y=
nothing
x3+
x2+
x+
C.
y=
nothing
x+
D.
y=
nothing
x2+
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started