Procter and gamble (p&g) wants to anazlyzs the average weekly sales of their Gil
ID: 3220832 • Letter: P
Question
Procter and gamble (p&g) wants to anazlyzs the average weekly sales of their Gillette fusion razor in supermarkets that have a video advertisement for the razor and in supermarkets that do not. Use the data in razor sheet in this workbook to generate excel output to answer the following questions. Round to the fifth decimal.e Excel output must start in E11. That means F11 (and possibly G11) s u MUST follow the CHAP10 and CHAP11 sheets in the Excel Templates Video sample size 29 Sample Mean 994 3793 949 1724 Sample Standard Deviation 5781 99.3885 56 Pooled Sample Standard Deviation 922509 Confidence Intervalla terms of Video-No Vide Confidence Coetficient Lower Limit Upper Llama 01.4062 value (U 0.0337 P-value mwo Tain 0.0674 ions a Hw
Explanation / Answer
5 )b)
86 % confidence interval = (8.9276 ,81.4862)
c) X1bar - X2bar =994.3792 -949.1724 = 45.2068
s_p = 92.2809
sqrt(1/n1 +1/n2) = sqrt(1/29+1/29 ) sqrt(2/29)
t -distribution with 56 degree of freedom
t0.05 = 1.672
hence
CI = (45.2068 - 1.672*92.2809*sqrt(2/29)),( (45.2068 + 1.672*92.2809*sqrt(2/29)))
(4.687298,85.72630)
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.