Question: Remaining Time: Unlimited Copy and paste the following data into Excel. Create a scatterplot of the data and use the scatterplot to determine if the

Remaining Time: Unlimited Copy and paste the following data into Excel. Create a scatterplot of the data and use the scatterplot to determine if the data would best be represented by a linear, quadratic, or exponential trendline. Then use Excel to find the equation of the appropriate trendline X y 5 94932.9 4.9 67521 3 24 535.33 3.9 9943.32 4.5 44726.3 2.8 1264.07 4.7 53429 3.4 4357.41 1.4 63.314 Equation of trendline: y= Note: For all trendlines, be sure to enter all the decimal places shown by Excel If your answer is an exponential trendline, enter your answer in the form: a*exp(bx)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
