Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the following questions: What is the average rating for all CBC movies? How about ABN movies and BBS movies? Provide a bar chart that

Answer the following questions:

  1. What is the average rating for all CBC movies? How about ABN movies and BBS movies? Provide a bar chart that compares these averages.
  2. Include a table that shows the descriptive statistics using the data analysis tool pack in Excel for the ratings of the three networks (one column for each network).
  3. Comment on how the networks are performing, by comparing and interpreting the metrics in the descriptive statistics table. Your analysis must extend beyond simply comparing the average ratings for each network
observation Network Month Day Rating Fact Stars
59 CBC 1 7 14.7 0 1
60 CBC 1 1 11.3 1 0
61 CBC 2 1 13.5 0 1
62 CBC 2 7 12.9 1 0
63 CBC 3 1 13.2 1 0
64 CBC 3 7 12.8 1 0
65 CBC 4 1 13.2 1 1
66 CBC 4 7 13.5 0 1
67 CBC 5 1 17.5 1 0
68 CBC 5 7 11.6 0 0
69 CBC 5 7 12.1 0 0
70 CBC 6 1 15.6 1 0
71 CBC 6 7 12.6 0 1
72 CBC 6 1 11.8 0 0
73 CBC 7 7 12.3 0 0
74 CBC 7 1 14.2 1 1
75 CBC 8 7 11.6 0 0
76 CBC 8 1 13.3 1 0
77 CBC 8 1 13.6 1 0
78 CBC 9 1 12.4 0 1
79 CBC 9 1 13.8 1 0
80 CBC 9 7 11.9 0 0
81 CBC 10 1 14.6 0 0
82 CBC 10 1 15.8 1 1
83 CBC 10 1 15.4 1 1
84 CBC 11 1 13.1 0 1
85 CBC 11 7 12.8 0 0
86 CBC 12 1 15.1 0 0
87 CBC 12 1 12.4 0 1
88 CBC 12 1 19.1 1 0

observation Network Month Day Rating Fact Stars
21 ABN 1 7 14.6 0 0
22 ABN 1 2 9.8 0 1
23 ABN 1 7 16.2 0 0
24 ABN 1 2 12.8 0 0
25 ABN 1 7 16 0 1
26 ABN 2 7 18.9 0 1
27 ABN 2 2 17.6 1 1
28 ABN 3 7 19.5 1 1
29 ABN 3 2 16.9 1 0
30 ABN 3 7 16.3 0 1
31 ABN 3 7 15.8 1 0
32 ABN 3 7 17.1 0 1
33 ABN 3 2 15.8 0 0
34 ABN 3 7 16 1 0
35 ABN 3 2 27.4 0 1
36 ABN 4 2 14.2 0 0
37 ABN 4 7 18.1 0 0
38 ABN 4 2 15.2 0 0
39 ABN 4 7 19.8 0 1
40 ABN 4 7 15.5 1 0
41 ABN 4 2 16.6 1 0
42 ABN 5 7 16.3 1 0
43 ABN 5 7 23.8 0 1
44 ABN 5 2 16.8 1 0
45 ABN 9 7 15.4 0 1
46 ABN 9 2 14.7 0 0
47 ABN 9 7 15.5 0 0
48 ABN 9 2 14.7 1 0
49 ABN 10 7 15.9 1 0
50 ABN 10 7 13.8 1 0
51 ABN 10 2 14.9 0 1
52 ABN 11 7 12.9 0 1
53 ABN 11 2 15.4 1 0
54 ABN 11 7 14.5 0 2
55 ABN 12 7 12.6 0 2
56 ABN 12 2 11.8 0 0
57 ABN 12 2 12.8 0 0
58 ABN 12 7 16.8 0 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practicing Statistics Guided Investigations For The Second Course

Authors: Shonda Kuiper, Jeff Sklar

1st Edition

321586018, 978-0321586018

More Books

Students also viewed these Mathematics questions

Question

1. Background knowledge of the subject and

Answered: 1 week ago