Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ben, a local fisherman in Wollongong, is certain that the average price of a fishing rod is less than $100 in his local area
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.] a Excel Assessment Data for Questions.xls - Compatibility Mode Autusave ... Draw Page Layout Formulas Deta Review View Tell me shar comant Home Insert , Calb (odyl A A 13 wran Tae v Number 11 EDae Condiienal Fermat Femaing as Teble Stles Cell Sort Eind& Analya Cate Peate BIU EMerge & Centra v $v % 3 E Fermat Scerativity Fher Select A1 X Fhing Rod Prices C. M Hitineat Pres ouV LIG 03 .03 11 $ 145 a 20 120 0 19 01 225 3703 Datal Data Datal Reay IDON
Step by Step Solution
★★★★★
3.51 Rating (164 Votes )
There are 3 Steps involved in it
Step: 1
The excel summary output is fishing road prices Mean 125...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started