Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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)

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote