Ben, a local fisherman in Wollongong, is certain that the average price of a fishing rod...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
The excel summary output is fishing road prices Mean 125... View the full answer
Related Book For
Finite Mathematics and Its Applications
ISBN: 978-0134768632
12th edition
Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair
Posted Date:
Students also viewed these accounting questions
-
In December 2010, the average price of regular unleaded gasoline excluding taxes in the United States was $3.06 per gallon, according to the Energy Information Administration. Assume that the...
-
A real estate agent claims that the average price of a home sold in Beaver County, Pennsylvania, is $60,000.Arandom sample of 36 homes sold in the county is selected, and the prices in dollars are...
-
In December 2014, the average price of regular unleaded gasoline excluding taxes in the United States was $3.06 per gallon, according to the Energy Information Administration. Assume that the...
-
One joule of work is done on a system, raising its temperature by one degree centigrade. Can this increase in temperature be harnessed to do one joule of work? Explain.
-
AgriChem, Inc., has introduced an innovative new producta combination fertilizer, weed killer, and insecticide that makes it much easier for soybean farmers to produce a profitable crop. The product...
-
Wet wood chips are dried in a continues rotary dryer that operates at atmospheric pressure. The chips enter at 19C with a water content of 40 wt% and must leave with a moisture content of less than...
-
A solid conducting sphere of radius \(R\) is embedded in an electrically neutral nonconducting spherical shell that has inner radius \(R\), has outer radius \(2 R\), and is made of a material having...
-
Mary Decker is suing the manufacturer of her car because of a defect that she believes caused her to have an accident, and kept her out of work for a year. She is suing the company for $3.5 million....
-
31 (i) Explain why the refractive index of any material with respect to air is always greater 1. (ii) In the figure below a light ray travels from air into the semi-circular plastic block. Give a...
-
Refer to Exercise 12-25. Stanmore Corporation makes a special-purpose machine, D4H, used in the textile industry. Stanmore has designed the D4H machine for 2017 to be distinct from its competitors....
-
Uber is partnering with Toyota and together they are working on re - engineering cars to be driverless. What sort of advantage is Uber creating with this partnership?
-
If a company generates gains, this is considered a financing activity this is separate and distinct from sales revenue this represents income from ordinary activities this is not considered income.
-
Mental health in prisons is a real issue that no one wants to talk about or deal with. What do you think?
-
Is an action ethical simply because the action is legal? Why or why not?
-
What if you registered for a class at the college and it was the last class you needed before graduation. The class did not fill and the college cancelled the class. Because the college cancelled the...
-
Can a contractor be excluded from competition for the rework of a government contract terminated for default?
-
A 5 1 - kg woman eats a 5 7 1 Calorie ( 5 7 1 kcal ) jelly doughnut for breakfast. ( a ) How many joules of energy are the equivalent of one jelly doughnut? J ( b ) How many steps must the woman...
-
If (x) 0 on the interval [a, b], the definite integral gives the exact area under the curve between x = a and x = b.
-
Suppose that the conglomerate of Example 2 experiences a doubling in the demand for business forms. At what levels should the computer and semiconductor divisions produce?
-
An office manager placed an order for computers, printers, and scanners. Each computer cost $1000, each printer cost $100, and each scanner cost $400. She ordered 15 items for $10,200. Give two...
-
A community fitness center has a pool and a weight room. The admission prices (in dollars) for residents and nonresidents are given by the matrix The average daily numbers of customers for the...
-
Consider a strictly risk averse agent endowed with initial wealth \(w_{0}\) and with a strictly increasing and twice differentiable utility function. Let \(r_{f}\) and \(\tilde{r}\) denote the return...
-
Consider the optimal portfolio choice problem in the presence of \(N\) risky assets with returns \(\left(\tilde{r}_{1}, \ldots, \tilde{r}_{N} ight)\) and of a risk free asset with return \(r_{f}>0\)....
-
Consider a quadratic utility function \(u(x)=x-\frac{b}{2} x^{2}\), an initial wealth \(w_{0}=100\), a risk free rate \(r_{f}=1.1\) and a risky asset with expected return...
Study smarter with the SolutionInn App