Finding the Best Model. Construct a scatterplot and identify the mathematical model that best fits the given data. Assume that the model is to be used only for the scope of the given data, and consider only linear, quadratic, logarithmic, exponential, and power models.
Deaths from Motor Vehicle CrashesListed below are the numbers of deaths in the United States resulting from motor vehicle crashes. Use the best model to find the projected number of such deaths for the year 2020.
Step 1 of 1</p>
In Excel draw the scatter plot for year and deaths.
Right click on any point, click on ‘add trendline’ option.
Click ‘Linear’ and choose ‘display equation on chart’ and ‘R-squared value’.
Follow the same steps for quadratic, logarithmic, exponential, and power models.