?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 Step 2 : The regression equation is 0.8217 y = 56.8202 * x Where, y = dependent variable which indicates the amount and x = independent variable which indicates the days of the week. From the graph we can see that the amount of money collection is decreasing day by day. When the film releases people rush into theaters and slowly it will decreases.