I just cannot get this one... it is killing me. I have spent 3 hours and now res
ID: 3255042 • Letter: I
Question
I just cannot get this one... it is killing me. I have spent 3 hours and now resorted to Chegg. Someone please help me solve this.
Must use Excel Megastat to solve the problem. Your calculated values MUST come from the excel output. Copy and paste relevant excel output on this assignment or attach excel output to it – do not include the data, fit all excel output on ONE page (i.e. shrink columns or decrease font size).
Be sure to write in all required information below each question, you will NOT receive credit if you only turn it the output. Your answers must be full and complete in order to receive credit.
Show ALL the steps.
Advertising study case
A marketing firm working for large market players wants to find out if an advertising campaign will influence customer buying decision on a new brand of laundry detergent. The firm has the design of the detergent bottle and an ad to promote the product. 10 respondents are presented only with the bottle design and asked about the likelihood of purchasing the detergent, on a scale from 1 to 100, before watching the ad; the responses are labeled “pre-exposure attitude scores”. Subsequently, each of the 10 respondents watched the ad and stated their likelihood of buying the detergent after watching the ad, represented by “post-exposure attitude scores”.
Assuming that the differences between pairs of post-exposure and pre-exposure scores are normally distributed, answer the following questions:
Set up the null and alternative hypotheses needed to attempt to establish that the advertisement increases the mean attitude score (that is, that the mean post-exposure attitude score is higher than the mean pre-exposure attitude score).
Test the hypotheses you set up in part “a” at the .10 level of significance and the critical value approach (use the 7 step hypothesis testing technique).
How much evidence is there that the advertisement increases the mean attitude score? (use the p-value and alpha to answer this question)
Estimate, at 95% confidence, the difference between the mean post-exposure score and the mean pre-exposure score.
a. Show the confidence interval in the form demonstrated in class.
b. Does seeing the ad increase the likelihood of buying the new detergent (i.e. is there significant difference between post- and pre-exposure attitude scores)? Why? Interpret the practical meaning of your confidence interval in the context of the problem, be sure to incorporate all answers of the above questions (for b.).
Pre-Exposure and Post-Exposure Attitude Scores for an Advertising Study Subject Pre-exposure Attitude scores Postexposure Attitude scores Attitude Change (di) 1 50 53 3 2 25 27 2 3 30 38 8 4 50 55 5 5 60 61 1 6 80 85 5 7 45 45 0 8 30 31 1 9 65 72 7 10 70 78 8Explanation / Answer
SOl:
performed paired t test in excel
Set up the null and alternative hypotheses needed to attempt to establish that the advertisement increases the mean attitude score (that is, that the mean post-exposure attitude score is higher than the mean pre-exposure attitude score).
HO:no change before and after
Ho: d =0
H0: 1 -2 =0
1---after
2--before
Alternative hypothesis:
H1:d >0
H1:1 -2 >0
H1:1 >2
alpha=level of significance=0.10
Test the hypotheses you set up in part “a” at the .10 level of significance and the critical value approach (use the 7 step hypothesis testing technique).
test statistic:
p value=0.00117
p<0.10 reject null hypothesis
conclusion:
there is sufficient evidence at 10% level of significance that the advertisement increases the mean attitude score
t-Test: Paired Two Sample for Means postexposureattitudescores preexposureattitudescores Mean 54.5 50.5 Variance 389.3889 341.3889 Observations 10 10 Pearson Correlation 0.989669 Hypothesized Mean Difference 0 df 9 t Stat 4.190582 P(T<=t) one-tail 0.00117 t Critical one-tail 1.383029 P(T<=t) two-tail 0.002339 t Critical two-tail 1.833113