Suppose that you are the marketing director of a retail company. Your company creates, prints and distributes
Question:
Suppose that you are the marketing director of a retail company. Your company creates, prints and distributes weekly price promotion leaflets to attract new and existing shoppers. To encourage people to read the leaflets, they contain a crossword puzzle every week. There is a box in every store where the solution can be placed, and you reward 15 randomly selected respondents with a EUR 15,000 voucher. On average, 8,530 people solve the crossword and place the solution to the box, with a standard deviation of 2,105.
You would like to increase the attractiveness of the crossword puzzle and decide to provide a EUR 25,000 voucher to the selected 15 people. The first 10 weeks data show that on average 9,100 people solved the crossword.
- Execute a hypothesis test in Excel on the increase of the number of people solving the crossword.
- Calculate the p-value in Excel.
Evaluate (on 5% significance level) whether there is enough statistical evidence that the number of people solving the crossword has increased.
Statistics The Art and Science of Learning from Data
ISBN: 978-0321755940
3rd edition
Authors: Alan Agresti, Christine A. Franklin