To analyze customer age, construct a frequency distribution, graph, and find the summary statistics (including the quartiles) by each type of customer (regular/promotion) . (Think whether you should...


To analyze customer age, construct a frequency distribution, graph, and find the summary statistics (including the quartiles)
by each type of customer (regular/promotion).  (Think whether you should create an ungrouped or grouped frequency distribution.)
Label the graphs completely.
Describe the shape of the distribution for each type of customer and discuss similarities or differences by interpreting the graphs and summary statistics. Discuss the measures of center and variation in detail. What can you conclude?



Please explain step by step how to do on EXCEL.

























































































































































































































































































































































































































Type of CustomerAge
Regular18
Promotional18
Regular18
Promotional18
Regular18
Regular20
Promotional20
Regular20
Promotional20
Regular20
Regular20
Promotional20
Promotional20
Promotional22
Regular22
Promotional22
Promotional22
Regular22
Promotional22
Promotional22
Promotional22
Promotional24
Promotional24
Regular24
Promotional26
Promotional26
Regular26
Promotional26
Promotional26
Promotional26
Promotional28
Regular28
Promotional28
Regular28
Promotional28
Regular30
Regular30
Promotional30
Promotional30
Regular32
Promotional32
Promotional32
Regular32
Promotional32
Promotional32
Promotional32
Regular32
Promotional34
Promotional34
Promotional34
Promotional34
Promotional34
Regular34
Regular34
Regular36
Promotional36
Promotional36
Promotional36
Promotional36
Promotional36
Promotional36
Promotional36
Promotional36
Promotional38
Promotional38
Promotional38
Promotional38
Promotional38
Promotional38
Promotional40
Promotional40
Promotional40
Regular42
Promotional42
Promotional44
Promotional44
Regular44
Promotional44
Promotional44
Regular44
Promotional44
Promotional44
Promotional44
Promotional46
Regular46
Promotional48
Regular50
Regular50
Promotional50
Promotional52
Promotional52
Promotional52
Regular54
Promotional58
Regular58
Regular60
Promotional62
Promotional64
Promotional68
Promotional84
Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here