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.

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!