Conduct an analysis and hypothesis test of your choice on the data you collected. Write a 250-500 word research summary of the findings generated in the assignments for Topics 2 through 5. The research summary should address the following. Explain what t
Michelle_Michy
2018022722504520180207002505stats_3__number_3__2_.xlsxRaw Data
| custName | custCountry | Number of Family Members (family size) | salesChannel | Frequency of purchase of groceries in a year |
| Female | Africa | 5 | Retail | 120 |
| Male | North America | 3 | Retail | 72 |
| Male | Africa | 10 | Direct | 204 |
| Male | Africa | 1 | Direct | 12 |
| Female | Africa | 8 | Retail | 168 |
| Male | Asia | 4 | Online | 132 |
| Female | Asia | 4 | Online | 84 |
| Female | Europe | 8 | Retail | 120 |
| Female | Asia | 4 | Online | 72 |
| Female | Australia | 4 | Online | 120 |
| Female | Central America | 2 | Online | 72 |
| Male | Europe | 1 | Online | 24 |
| Male | Europe | 6 | Retail | 156 |
| Male | Australia | 6 | Online | 144 |
| Female | Asia | 3 | Online | 60 |
| Male | Asia | 10 | Retail | 156 |
| Male | Africa | 7 | Online | 192 |
| Female | Africa | 1 | Retail | 12 |
| Male | Asia | 2 | Retail | 36 |
| Female | Asia | 4 | Retail | 132 |
| Male | Europe | 5 | Retail | 108 |
| Female | Asia | 3 | Retail | 144 |
| Male | Asia | 7 | Direct | 132 |
| Male | Africa | 1 | Direct | 12 |
| Female | Asia | 4 | Online | 72 |
| Female | Asia | 10 | Online | 192 |
| Female | Europe | 7 | Retail | 144 |
| Male | Asia | 7 | Retail | 168 |
| Male | Africa | 9 | Online | 168 |
| Male | Europe | 10 | Retail | 192 |
| Female | Asia | 3 | Retail | 72 |
| Female | Africa | 6 | Online | 120 |
| Male | Africa | 8 | Retail | 156 |
| Female | North America | 2 | Online | 48 |
| Female | Europe | 2 | Online | 36 |
| Female | Europe | 5 | Online | 132 |
| Male | Asia | 1 | Direct | 12 |
| Female | Africa | 5 | Online | 108 |
| Female | Asia | 8 | Retail | 168 |
| Male | Asia | 5 | Retail | 96 |
| Male | South America | 5 | Retail | 108 |
| Female | South America | 7 | Online | 168 |
| Female | North America | 7 | Online | 132 |
| Male | Africa | 9 | Retail | 192 |
| Female | Asia | 4 | Online | 96 |
| Male | South America | 5 | Online | 108 |
| Female | North America | 6 | Online | 108 |
| Male | Africa | 9 | Retail | 36 |
| Male | North America | 2 | Retail | 48 |
| Female | North America | 1 | Online | 24 |
| Male | North America | 3 | Online | 24 |
| Female | Asia | 4 | Retail | 144 |
| Female | South America | 2 | Retail | 96 |
2
| 1. Frequency of purchase of groceries in a year (raw data) | |||||||||
| Frequency of purchase of groceries in a year | Confidence Level | Z-value | Lower Bound | Upper Bound | Interpretation | ||||
| 120 | Mean | 95% | 1.96 | 91.64 | 121.64 | There is a 95% chance that the true mean of the population lies between 91.64 and 121.64 | |||
| 72 | 106.641509434 | 90% | 1.645 | 94.05 | 119.23 | There is a 90% chance that the true mean of the population lies between 94.05 and 119.23 | |||
| 204 | 98% | 3 | 86.92 | 126.36 | There is a 98% chance that the true mean of the population lies between 86.92 and 126.32 | ||||
| 12 | Standard deviation | ||||||||
| 168 | 55.7242849765 | ||||||||
| 132 | |||||||||
| 84 | |||||||||
| 120 | |||||||||
| 72 | |||||||||
| 120 | |||||||||
| 72 | |||||||||
| 24 | |||||||||
| 156 | |||||||||
| 144 | |||||||||
| 60 | |||||||||
| 156 | |||||||||
| 192 | |||||||||
| 12 | |||||||||
| 36 | |||||||||
| 132 | |||||||||
| 108 | |||||||||
| 144 | |||||||||
| 132 | |||||||||
| 12 | |||||||||
| 72 | |||||||||
| 192 | |||||||||
| 144 | |||||||||
| 168 | |||||||||
| 168 | |||||||||
| 192 | |||||||||
| 72 | |||||||||
| 120 | |||||||||
| 156 | |||||||||
| 48 | |||||||||
| 36 | |||||||||
| 132 | |||||||||
| 12 | |||||||||
| 108 | |||||||||
| 168 | |||||||||
| 96 | |||||||||
| 108 | |||||||||
| 168 | |||||||||
| 132 | |||||||||
| 192 | |||||||||
| 96 | |||||||||
| 108 | |||||||||
| 108 | |||||||||
| 36 | |||||||||
| 48 | |||||||||
| 24 | |||||||||
| 24 | |||||||||
| 144 | |||||||||
| 96 | |||||||||
