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

profileMichelle_Michy
2018022722464720180207002504stats_3__number_2__2_.xlsx
Home>Applied Sciences homework help>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

Raw 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 Formula Used:
120 Mean 95% 1.96 91.64 121.64
72 106.641509434 90% 1.645 94.05 119.23
204 98% 3 86.92 126.36
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