Question: Looking for step by step excel input instructions: Include a table that shows the descriptive statistics using the data analysis tool pack in Excel for

Looking for step by step excel input instructions:

  1. 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). Show steps of how to get the table
  2. The executives wish to know if they should hire stars for their programs. To answer this question, run a hypothesis test to see if the ratings of shows with stars are higher compared to those without stars. Use the data for CBC movies only. Use 95% confidence. Your answer should include the following:
    1. The null and alternative hypotheses (state in full sentences).
    2. The test results: Run the test using Excel and include the output table. Use a t-test assuming equal variances.
    3. What is your recommendation to the executives? Justify your answer referring to the relevant figures.

For Q2 I need step by step of how I can do this on excel

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!