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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started