Four different brands of batteries are to be compared by testing each brand in five sets of garden string lights. Twenty sets of string lights are selected randomly into four groups of five lights each. Then each group of lights uses a different brand of battery. The lifetimes of the batteries (in hours) were obtained as follows:

Brand A	Brand B	Brand C	Brand D
28	27	23	28
24	22	26	35
36	28	33	43
39	21	37	32
29	32	30	31

Create an Analysis of Variance table in Excel for the single-factor fixed effect model, using Excel as a calculator for each of the value in the table. In other words, calculate the Sum of Squares, the Mean Squares, and the F-statistics, using Excel as a calculator and without using the Data Analysis ToolPack in Excel. No points will be given if the calculations are not shown in each cell for those values! (3 points)

Then answer the following questions:

1. What hypotheses are we testing for this problem? Be as specific as possible. (1 pt)
2. Do you reject H0? Why? (1 pt)
3. State your conclusion in laymens terms. (1 pt)