Question 1:

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

1. 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.
2. Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact. Use data from CBC only. CBC Management has several questions:
   1. Executives wish to know how much being fact-based or having one star contributes to a movies rating. What can you tell them about this?
   2. Are either, both, or neither of the independent variables significantly related to the ratings at 95% confidence? Justify your answers referring to the relevant figures.
   3. How well does this regression analysis explain the ratings? Should the executives count on the results from this analysis? Justify your answers referring to the relevant figures.

Question 2

Increased blood vessel formulation is a predictive factor in survival for a certain disease. One treatment is stem cell transplantation with the patient's own stem cells. The accompanying data table represents the microvessel density for pati who had a complete response to the stem cell transplant. The measurements were taken immediately prior to the stem cell transplant and at the time the complete response was determined. Complete parts (a) through (d) below. Click the icon to view the data table. H1: HD CU H1 : HD 20 X Patient Data The test statistic is tSTAT = 1.92 . (Round to two decimal places as needed.) Patient Before After The p-value is 0.057 . 157 276 (Round to three decimal places as needed.) 218 115 225 243 Since the p-value is greater than the value of a, do not reject Ho. There is insufficient evidence to conclude that the mean microvessel density is 362 251 NOUAWN 376 253 417 165 b. Interpret the meaning of the p-value in (a). Choose the correct answer below. 432 305 O A. The p-value is the probability of not rejecting the null hypothesis when it is false. B. The p-value is the probability of obtaining a sample mean difference of greater than or equal to the sample mean difference from the data if the Ime. O C. The p-value is the probability of rejecting the null hypothesis when it is true. Print Done O D. The p-value is the probability of obtaining a sample mean difference of less than or equal to the sample mean difference from the data if the pop c. Construct and interpret a 99% confidence interval estimate of the mean difference in microvessel density before and after the stem cell transplant. SHD SO Round to one decimal place as needed.)