Question: 1. Using the data for CBC movies: a. Use a line graph of the monthly average ratings for CBC for the year. Note that there
1. Using the data for CBC movies:
a. Use a line graph of the monthly average ratings for CBC for the year. Note that there are multiple ratings data for the months; you will need to calculate an average for each month first, and then plot the averages.
b. After you use the graph, fit a linear trend line and a 2nd order polynomial trend line, displaying the formula and the r-squared.
c. Explain if you can use this time series data to forecast the ratings of upcoming months. Which forecasting method is better? How accurate can you expect this forecast to be?
| Network | Month | Day | Rating | Fact | Stars |
| CBC | 1 | 7 | 14.7 | 0 | 1 |
| CBC | 1 | 1 | 11.3 | 1 | 0 |
| CBC | 2 | 1 | 13.5 | 0 | 1 |
| CBC | 2 | 7 | 12.9 | 1 | 0 |
| CBC | 3 | 1 | 13.2 | 1 | 0 |
| CBC | 3 | 7 | 12.8 | 1 | 0 |
| CBC | 4 | 1 | 13.2 | 1 | 1 |
| CBC | 4 | 7 | 13.5 | 0 | 1 |
| CBC | 5 | 1 | 17.5 | 1 | 0 |
| CBC | 5 | 7 | 11.6 | 0 | 0 |
| CBC | 5 | 7 | 12.1 | 0 | 0 |
| CBC | 6 | 1 | 15.6 | 0 | 0 |
| CBC | 6 | 7 | 12.6 | 0 | 1 |
| CBC | 6 | 1 | 11.8 | 0 | 0 |
| CBC | 7 | 7 | 12.3 | 0 | 0 |
| CBC | 7 | 1 | 14.2 | 1 | 1 |
| CBC | 8 | 7 | 11.6 | 0 | 0 |
| CBC | 8 | 1 | 13.3 | 1 | 0 |
| CBC | 8 | 1 | 13.6 | 1 | 0 |
| CBC | 9 | 1 | 12.4 | 0 | 1 |
| CBC | 9 | 1 | 13.8 | 1 | 0 |
| CBC | 9 | 7 | 11.9 | 1 | 0 |
| CBC | 10 | 1 | 14.6 | 0 | 0 |
| CBC | 10 | 1 | 15.8 | 1 | 1 |
| CBC | 10 | 1 | 15.4 | 0 | 1 |
| CBC | 11 | 1 | 13.1 | 0 | 1 |
| CBC | 11 | 7 | 12.8 | 0 | 0 |
| CBC | 12 | 1 | 15.1 | 0 | 0 |
| CBC | 12 | 1 | 12.4 | 0 | 1 |
| CBC | 12 | 1 | 19.1 | 1 | 0 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock