A researcher has laid different types of moth traps in various locations in an effort to find the ideal trap type and location for capturing spruce moths. Traps were placed on the ground, on lower branches, on middle branches, and on high branches of trees. In each location, scent lures, sugar lures, and chemical lures were used. The Excel file provides the data set, which displays the number of moths caught in each kind of trap after 48 hours. Based on that, answer the following questions:

1. How many of each type of trap was placed in each location? How many traps in all were placed?
2. Perform the two-way ANOVA test with the Data Analysis tool in Excel. Are there any significant (p < 0.05) main effects? What does this tell you about moth trap lures and locations?
3. Is there a significant (p < 0.05) interaction effect? What does this indicate?
4. In the first five tables of the output, notice that several sums are shown.
   1. Which trap height proved most effective?
   2. Which lure type was most effective?
   3. Which trap/lure combo was most effective?
   4. What is interesting about your answers to 1,2 and 3?

please provide excel steps. Thanks

Question 2
Location	Scent	Sugar	Chemical
Top	28	35	32
19	22	29
32	24	16
15	16	18
13	17	20
Middle	33	36	37
12	38	40
42	44	18
25	37	28
21	22	36
Lower	44	42	35
21	17	39
38	31	32
32	23	31
29	37	29
Ground	17	18	22
12	27	25
23	15	23
19	20	16
14	16	25