2. [EXCEL] Karl Duncker’s results on his ‘Candle Problem’ werepublished posthumously in 1945. Participants were asked to mount acandle on a wall in an upright position so that it would burnnormally. One group of participants was given a candle, a book ofmatches, and a box full of tacks. A different, independent group ofparticipants were given the same items, except that the box and thetacks were presented separately. The solution is to use the tacksto nail the box to the wall, put the candle in the box and use thematches to light it. Functional fixedness is the idea that peoplein the first group will take longer to solve the problem, becausethey will have difficulty seeing a function for the box as a shelfdifferent from its current use as a container. For eachparticipant, the amount of time to solve the problem in seconds wasrecorded. We want to test whether there is sufficient evidence thatthe first group took longer to solve the problem. Data similar toDuncker’s is given in the “Question 2” tab in the file“DataAssignment4.xlsx”.

Box of Tacks	Tacks and Box Separate
120	43
146	24
160	68
81	35
95	47
135	45
115	42
131	50
175	37
140	49
87	41
92	48
90	39
132	34
87	27
137	51
96	52
151	43
94	43
158	46
88
112
137
149
92

(a) Define the parameter to be tested. (b) State the null andalternative hypothesese you would use. (c) Use Excel to find thesample size, mean, and standard deviation of each sample. (d) Wouldyou use a pooled or unpooled test? Why? (e) Get the output tablefrom Excel for the hypothesis test. (f) Add a row under your outputclearly stating the observed value of your test statistic and yourp-value. Write a sentence explaining whether there is sufficientevidence at the α = 0.01 significance level that participants whowere given a box of tacks took longer to solve the problem.