Statistics questions

profileadebola

Observation

Network

Month

Day

Rating

Fact

Stars

1

 

BBS

1

1

15.6

0

1

2

 

BBS

1

7

10.8

1

0

3

 

BBS

1

7

14.1

0

1

4

 

BBS

1

1

16.8

1

1

5

 

BBS

2

1

14.3

1

1

6

 

BBS

2

1

17.1

1

1

7

 

BBS

3

1

15.8

0

0

8

 

BBS

3

7

16.2

1

0

9

 

BBS

4

7

12.6

0

1

10

 

BBS

5

1

13.5

0

1

11

 

BBS

5

7

15.6

0

0

12

 

BBS

5

1

12.1

0

1

13

 

BBS

5

1

15.8

1

0

14

 

BBS

9

7

15

1

0

15

 

BBS

9

7

16.3

0

0

16

 

BBS

9

7

13.3

0

1

17

 

BBS

10

7

10.8

0

1

18

 

BBS

10

7

14.4

1

0

19

 

BBS

11

7

14.4

1

1

20

 

BBS

11

7

13.6

1

0

21

 

ABN

1

7

14.6

0

0

22

 

ABN

1

2

10.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

14

1

1

28

 

ABN

3

7

19.5

1

1

29

 

ABN

3

2

14.7

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

11.5

0

0

34

 

ABN

3

7

16

1

0

35

 

ABN

3

2

11.7

0

1

36

 

ABN

4

2

14.2

0

0

37

 

ABN

4

7

11.2

0

0

38

 

ABN

4

2

10.9

0

0

39

 

ABN

4

7

13.3

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

12.3

0

1

44

 

ABN

5

2

13.3

1

0

45

 

ABN

9

7

15.4

0

1

46

 

ABN

9

2

10.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

10

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

59

 

CBC

1

7

14

0

1

60

 

CBC

1

1

11.3

1

0

61

 

CBC

2

1

13.6

0

0

62

 

CBC

2

7

12.9

1

0

63

 

CBC

3

1

13.2

1

0

64

 

CBC

3

7

16

1

0

65

 

CBC

4

1

14.6

1

1

66

 

CBC

4

7

16.6

0

1

67

 

CBC

5

1

17.5

1

0

68

 

CBC

5

7

11.6

0

0

69

 

CBC

5

7

8.9

0

0

70

 

CBC

6

1

15.6

0

0

71

 

CBC

6

7

9.2

0

1

72

 

CBC

6

1

11.8

0

0

73

 

CBC

7

7

11

0

0

74

 

CBC

7

1

9.5

1

0

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

0

79

 

CBC

9

1

13.8

1

0

80

 

CBC

9

7

11.9

1

0

81

 

CBC

10

1

14.6

0

0

82

 

CBC

10

1

15.8

1

1

83

 

CBC

10

1

15.4

0

1

84

 

CBC

11

1

12.8

0

0

85

 

CBC

11

7

12.8

0

0

86

 

CBC

12

1

15.1

0

0

87

 

CBC

12

1

11.4

0

1

88

 

CBC

12

1

19.1

1

0

 

1.       Answer the following questions:

a.       What is the average rating for all CBC movies? How about ABN movies and BBS movies

b.      Include a table that shows the average and the other descriptive statistics ( using the data analysis toolpack in excel) for the ratings of the three networks (one column for each  network). Explain what you learn from each of the metrics in the table.

 

c.       Comment on which network is doing best. 

  • 6 years ago
  • 15
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    unit6.pptx
  • attachment
    unit6.xls
Bids(0)