For a store need to know: Is there a good reason to believe that on average evening customers purchase more than day customers? Perform a statistical test on the difference between the meanday purchase and the mean evening purchase (use a two-tail test).
Excel datafile is attached.
Hint: 1)Difference of means test: determines whether two samples are likely to have come from different populations. 2) Are evening customers significantly different from day customers in their buying behavior?. 3) Two-tail test as the difference can go ether way. 4) Excel will do almost all calculations.
I got day time customers mean = $28.34 & evening customers mean $30.52
Please check attachment for solution.
Day Purchase Evening …
The solution gives detailed step on a two-sample t-test. All works are done in excel.