Plz to using Excel to give me the answers!!!!!

[answerhappygod]

Plz to using Excel to give me the
answers!!!!!

Plz To Using Excel To Give Me The Answers 1 (197.19 KiB) Viewed 67 times

Excel Assessment Questions Question 1 Ben, a local fisherman in Wollongong, is certain that the average price of a fishing rod is less than $100 in his local area so he conducts a survey of prices of fishing rods from 25 local fishing stores. Is there enough evidence to support his claim at the 10% level of significance? (The data can be found in the Excel Worksheet Datal) [Note: you will need to produce output in excel using the t-Test: Two-Sample Assuming Unequal Variances tool, you may also use the Descriptive Statistics tool to obtain the sample mean and the sample standard deviation.] [HINT: When formulating your 6-step hypothesis test for this question you will use the hypothesis test for population mean with population standard deviation unknown.] Question 2 Ben also believes that the prices of fishing rods in his local area are more expensive than the average price in Sydney. He collects samples of data from his local area and also from Sydney. Is there evidence to support his claim at the 5% level of significance? (The data can be found in the Excel Worksheet Data2) [Note: you will need to produce output in excel using both the t-Test: Two-Sample Assuming Unequal Variances AND t-Test: Two-Sample Assuming Equal Variances tools.] [HINT: When formulating your hypothesis for this question be careful which variable is variable 1 (Sydney) and which is variable 2 (Wollongong), your 6-step hypothesis tests for this question you will use both the Pooled-Variance t-test and the Separate-Variance t-test.]
2 0 0 13 1 Fishing Rod Pr DUMMY $ 101.00 3 $ 110.00 4 $ 150.00 5 $ 200.00 6 $ 203.00 7 $ 95.00 8 $ 82.00 9 $ 105.00 10 $ 112.00 11 $ 145.00 12 $ 206.00 $ 75.00 14 $ 60.00 15 $ 130.00 16 $ 86.00 17 $ 300.00 18 $ 150.00 19 $ 50.00 20 $ 120.00 21 $ 155.00 22 $ 97.00 23 $ 84.00 24 $ 45.00 25 $ 66.00 26 $ 203.00 27 28 29 0 0 0 0 0