?9 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. Harry Potter?Listed below are the amounts (millions of dollars) grossed during the first three weeks of the movie?Harry Potter and the Half Blood Prince.?Use the best model to predict the gross amount on the 22nd day of the movie’s release. Is the result close to the actual amount of $2.2 million? Is there any characteristic of the data not revealed by the model??{Hint:?The movie opened on a Wednesday.) 9 . 3 2 . 5 2 . 4

Solution 9 BSC Step 1 : The amount grossed during the first three weeks of the movie harry potter and the half blood prince. Non Linear regression model be the suitable model it can be obtained through Excel. From Excel > Choose Stat - Modeling data - nonlinear regression > Choose dependent and independent variable and define function and choose inbuilt function in function option of the dialog box > ok