Data Analysis Report: Movie Ratings, Hypothesis Testing, Regression

This report presents a comprehensive analysis of movie ratings across different networks (CBC, ABN, and BBS), evaluating their performance based on average ratings and standard deviation. The analysis includes an assessment of forecasting accuracy, revealing a low R-squared value, indicating limitations in predictive capabilities. Furthermore, hypothesis testing is conducted to determine the impact of stars on movie ratings, with recommendations provided to executives. The report also explores linear regression models, examining the influence of facts and stars on movie ratings, and evaluates the models' predictive power. The findings suggest that facts have a greater impact on ratings than stars, while both variables exhibit insignificant relationships with the dependent variable. The study concludes that the models lack the accuracy needed for reliable prediction, and the data points are scattered far from the regression line. The report is supported by a reference to Frost, J., 2014, discussing the interpretation of regression models with low R-squared and low P values.

Part B

(1)Answer the following questions
• (a)Average rating of CBC, ABN and BBS movies
• Average rating of CBC movies is 13.43 and same of ABN is 15.26
followed by mean value for BBS is 14.40. It can be said that mean rating
score is high in case of ABN then other networks. However, there is not
big difference between these networks.

(b)Comment on network doing best
Average rating of CBC 13.43333
Average rating of ABN 15.26842
Average rating of BBS 14.405

Continue
• Interpretation
• On basis of table it can be said that mean score is high in case of
ABN and its rating is also deviating at fast rate then other networks.
However, in terms of rating there is no big difference among these
networks. If standard deviation and minimum as well as maximum range
will be compared with each other similar results will be obtained. Hence,
it can be said that almost same performance is given by all these networks.

©Network doing best
• ABN is the network that is doing best in comparison to other networks as
mean score is high and maximum range is also higher then minimum
range relative to other networks. Hence, it can be said that ABN is
performing better than other networks.

(2) Accuracy of forecast
Average rating of CBC Average rating of ABN Average rating of BBS
12.5
13
13.5
14
14.5
15
15.5
13.4333333333333
15.2684210526316
14.405
f(x) = 0.48583333333335 x + 13.3972514619883
R² = 0.280038372597832
Chart Title

Continue
• There is lack of accuracy of forecast as it can be observed that value of R
square is 0.28 which is very low. Hence, this model cannot make accurate
forecast in respect to variable and cannot be used to make prediction.

(3) Hypothesis test
• (a)Null and alternative hypothesis
• H0: There is no significant mean difference between ratings of movies
with stars and without stars.
• H1: There is significant mean difference between ratings of movies with
stars and without stars.

(b)T test model

©Recommendation to executives
• There is no significant mean difference between CBC ratings in respect to
with and without star category as value of level of significance is
1.67>0.05. It is recommended that less number of stars must be hired in
order to promote movie because no difference is observed in case of stars
and without stars.
•

(4) Linear regression model

(a)Impact on IV on DV
• Fact component have impact on rating then stars. With change in fact 0.97
point change comes in rating and with change in stars 0.007 point change
comes in rating of movies. Thus, facts have more impact on movie then
stars.