a) The worksheet \"Counts8Year\" provides the number Top30 TVshows aired on each network by year. Run a two-way ANOVA withoutreplication using the data in columns A to E of the \"Counts8Year\"worksheet. (Do not include row 1 and check labels.) Two hypothesistests will be performed, one for the Year (row) factor and theother for the Network (column) factor. What is the value of thetest statistic, F_calc, for the test on theNetwork factor? Provide your answer with 2 decimal places.

.

b) R-square (R²) is the proportion of thevariation in the data (number of top 30 shows) that can beexplained by the factors (year and network). ComputeR² = 1 - SSE/SST.   Provideyour answer with 4 decimal places.  

.

c) What is the conclusion of the ANOVA hypothesis test at a 5%significance level?  (Click to select)At least one pairof network means differ. At least one pair of the yearly meansdiffer.None of the network means differ. None of the yearly meansdiffer.All of the network means differ. All of the yearly meansdiffer.None of the network means differ. At least one pair ofyearly means differ.At least one pair of network means differ. Noneof the yearly means differ.None of the network means differ. All ofthe yearly means differ.All of the network means differ. None ofthe yearly means differ.

.

d) Based on the ANOVA test results, which means aresignificantly different? (Click to select)Years 2015 and 2016ABC,CBSFOX, NBCCBS, NBCABC, FOXABC, NBCCBS, FOXNo pairs of means differsignificantlyABC, CBS, FOX, NBC

.

e) Which of the following methods/test would NOT be appropriatefor testing the assumptions of this ANOVA test?

Number of Shows inTop 30 for the last 8 Years
Year	ABC	CBS	FOX	NBC
2016	4	15	4	9
2015	6	19	1	4
2014	6	17	2	5
2013	6	18	3	3
2012	7	17	4	2
2011	8	16	3	3
2010	9	15	5	1
2009	8	15	5	3