Solution Found!
Finding the Best Model. Construct a
Chapter 10, Problem 9 BSC(choose chapter or problem)
Problem 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 PotterListed below are the amounts (millions of dollars) grossed during the first three weeks of the movieHarry 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.)
58.2 |
22.0 |
26.8 |
29.2 |
21.8 |
9.9 |
9.5 |
7.5 |
6.9 |
9.3 |
11.2 |
8.9 |
4.0 |
4.0 |
4.6 |
3.8 |
5.4 |
6.8 |
5.8 |
2.5 2.4 |
Questions & Answers
QUESTION:
Problem 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 PotterListed below are the amounts (millions of dollars) grossed during the first three weeks of the movieHarry 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.)
58.2 |
22.0 |
26.8 |
29.2 |
21.8 |
9.9 |
9.5 |
7.5 |
6.9 |
9.3 |
11.2 |
8.9 |
4.0 |
4.0 |
4.6 |
3.8 |
5.4 |
6.8 |
5.8 |
2.5 2.4 |
ANSWER:
Solution 9 BSC
Step 1 of 3
The amount grossed during the three weeks of the harry potter movie is used to fit. A suitable model for the same is given and a suitable non linear regression can be obtained through excel add in excel stat as follows:
• In excel Stat choose –Modeling data-nonlinear regression
• Choose the dependent and the independent variable and define the function or choose a inbuilt function available in functions option of the diagonal box
• Click ok to obtain the result as follows:
