**PLEASE NOTE** - I am using Excel and it is CRUCIAL that I know the excel funct
ID: 3221643 • Letter: #
Question
**PLEASE NOTE** - I am using Excel and it is CRUCIAL that I know the excel functions to discover the answers. PLEASE HELP ME UNDERSTAND THIS BY LISTING THEM!!! Finding the answer isn't as hard for me as being able to input the functions via excel. THANK YOU SO MUCH!!!!
**PLEASE NOTE** - I am using Excel and it is CRUCIAL that I know the excel functions to discover the answers. PLEASE HELP ME UNDERSTAND THIS BY LISTING THEM!!! Finding the answer isn't as hard for me as being able to input the functions via excel. THANK YOU SO MUCH!!!!
Used Coupon? No No No Yes No No Yes No No No No No No No No No No No No No No No No No Yes No No Yes No No No No No No No No Yes No No No No No No No No No No No No Yes Yes No Yes No No No No No No No No No No No No No No No Yes No No No No Yes No No No No No No No No No No No No No No No No Yes No Yes Yes No No No No No No Eagle Outfitters is a chain of stores specializing in outdoor apparel and camping gear. They are considering a promotion that involves mailing discount coupons to all their credit card customers. This promotion will be considered a success if more than 10% of those receiving the coupons use them. Before going national with the promotion, coupons were sent to a sample of 100 credit card Customers a) Develop hypotheses that can be used to test whether the population proportion of those who will use the coupons is sufficient to go nationa b) Using the sample data, develop a point estimate of the population proportion c) Use a 05 to conduct your hypothesis test. Provide a one-sentence conclusion Don't just tell me "reject" or "fail to reject". Give an answer appropriate to the context of the question d) Should Eagle go national with the promotion? Why or why not. Be sure to show all calculations and label your answers appropriately.Explanation / Answer
Solution:-
a)
x = 13, n = 100
Point estimate for population proportion is = pyes = 13/100 = 0.13
State the hypotheses. The first step is to state the null hypothesis and an alternative hypothesis.
Null hypothesis: P < 0.13
Alternative hypothesis: P > 0.13
Note that these hypotheses constitute a one-tailed test. The null hypothesis will be rejected only if the sample proportion is too small.
Formulate an analysis plan. For this analysis, the significance level is 0.05. The test method, shown in the next section, is a one-sample z-test.
Analyze sample data. Using sample data, we calculate the standard deviation () and compute the z-score test statistic (z).
= sqrt[ P * ( 1 - P ) / n ]
= 0.03
z = (p - P) /
z = 1
where P is the hypothesized value of population proportion in the null hypothesis, p is the sample proportion, and n is the sample size.
Since we have a one-tailed test, the P-value is the probability that the z-score is more than 1.
Thus, the P-value = 0.1587
Interpret results. Since the P-value (0.1587) is greater than the significance level (0.05), we have to accept the null hypothesis.
From the above test we have not sufficient evidence in the favor of the claim the people who uses coupen are not sufficient to go national.
Eagle should not go with the promotion.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.