?11 BSC 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. Richter Scale?The table lists different amounts (metric tons) of the explosive TNT and the corresponding value on the Richter scale used for explosions of the TNT.
Solution 11 BSC Step 1 : Given, the amount of (metric tons) the explosive TNT and the corresponding value on the richter scale used for explosions of the TNT We have to fit the best model. By using Excel > choose modeling nonlinear regression > choose dependent and independent variables and define function or choose a inbuilt function variable in functions option of the diagonal box. > OK Step 2 : The chart is The logarithmic model is R = 3.2318 + 0.293ln(x) Here, R = Richter scale and X = TNT