Construct a COMPARATIVE (also known as SIDE-BY-SIDE) box-and-whisker plot and find the summary statistics (including the quartiles) for net sales by each type of customer (regular/promotion). Make sure that you format the x-axes on each plot and compare the plots using the same scale. Describe the shape of the distribution for each type of customer, and compare the graphs by interpreting the summary statistics, particularly the five- number summary. What can you conclude? PLEASE EXPLAIN STEP BY STEP HOW TO DO ON EXCEL. Type of Customer Net Sales Regular 49.50 Promotional 112.40 Regular 32.50 Promotional 110.40 Regular 64.00 Regular 54.50 Promotional 88.00 Regular 32.50 Promotional 66.52 Regular 54.50 Regular 39.50 Promotional 41.60 Promotional 170.40 Promotional 74.50 Regular 59.50 Promotional 81.40 Promotional 104.00 Regular 64.50 Promotional 48.50 Promotional 54.80 Promotional 41.60 Promotional 80.82 Promotional 276.00 Regular 84.00 Promotional 49.50 Promotional 40.02 Regular 54.50 Promotional 202.80 Promotional 81.20 Promotional 28.00 Promotional 73.20 Regular 85.00 Promotional 73.20 Regular 50.00 Promotional 115.50 Regular 39.50 Regular 112.50 Promotional 127.50 Promotional 23.23 Regular 62.50 Promotional 208.80 Promotional 29.50 Regular 133.50 Promotional 72.40 Promotional 33.80 Promotional 49.60 Regular 35.00 Promotional 73.64 Promotional 24.82 Promotional 155.20 Promotional 186.62 Promotional 128.80 Regular 68.00 Regular 84.00 Regular 59.50 Promotional 151.60 Promotional 133.10 Promotional 90.40 Promotional 75.20 Promotional 123.00 Promotional 118.80 Promotional 69.91 Promotional 63.60 Promotional 41.60 Promotional 59.50 Promotional 49.60 Promotional 69.50 Promotional 156.80 Promotional 57.20 Promotional 105.05 Promotional 165.32 Promotional 68.00 Regular 79.00 Promotional 56.50 Promotional 55.22 Promotional 94.74 Regular 49.00 Promotional 121.14 Promotional 96.80 Regular 99.00 Promotional 88.00 Promotional 63.20 Promotional 68.50 Promotional 56.00 Regular 47.50 Promotional 30.80 Regular 154.00 Regular 117.00 Promotional 41.60 Promotional 67.60 Promotional 105.20 Promotional 32.42 Regular 169.75 Promotional 239.50 Regular 76.00 Regular 49.50 Promotional 263.00 Promotional 297.59 Promotional 57.60 Promotional 38.44

Construct a COMPARATIVE (also known as SIDE-BY-SIDE) box-and-whisker plot and find the summary statistics (including the quartiles) for net sales by each type of customer (regular/promotion) . Make...

Construct a COMPARATIVE (also known as SIDE-BY-SIDE) box-and-whisker plot and find the summary statistics (including the quartiles) for net sales
by each type of customer (regular/promotion).
Make sure that you format the
x-axes on each plot and compare the plots using the same scale. Describe the shape of the distribution for each type of customer, and compare the graphs by interpreting the
summary statistics, particularly
the five- number summary. What can you conclude?

PLEASE EXPLAIN STEP BY STEP HOW TO DO ON EXCEL.

Type of Customer	Net Sales
Regular	49.50
Promotional	112.40
Regular	32.50
Promotional	110.40
Regular	64.00
Regular	54.50
Promotional	88.00
Regular	32.50
Promotional	66.52
Regular	54.50
Regular	39.50
Promotional	41.60
Promotional	170.40
Promotional	74.50
Regular	59.50
Promotional	81.40
Promotional	104.00
Regular	64.50
Promotional	48.50
Promotional	54.80
Promotional	41.60
Promotional	80.82
Promotional	276.00
Regular	84.00
Promotional	49.50
Promotional	40.02
Regular	54.50
Promotional	202.80
Promotional	81.20
Promotional	28.00
Promotional	73.20
Regular	85.00
Promotional	73.20
Regular	50.00
Promotional	115.50
Regular	39.50
Regular	112.50
Promotional	127.50
Promotional	23.23
Regular	62.50
Promotional	208.80
Promotional	29.50
Regular	133.50
Promotional	72.40
Promotional	33.80
Promotional	49.60
Regular	35.00
Promotional	73.64
Promotional	24.82
Promotional	155.20
Promotional	186.62
Promotional	128.80
Regular	68.00
Regular	84.00
Regular	59.50
Promotional	151.60
Promotional	133.10
Promotional	90.40
Promotional	75.20
Promotional	123.00
Promotional	118.80
Promotional	69.91
Promotional	63.60
Promotional	41.60
Promotional	59.50
Promotional	49.60
Promotional	69.50
Promotional	156.80
Promotional	57.20
Promotional	105.05
Promotional	165.32
Promotional	68.00
Regular	79.00
Promotional	56.50
Promotional	55.22
Promotional	94.74
Regular	49.00
Promotional	121.14
Promotional	96.80
Regular	99.00
Promotional	88.00
Promotional	63.20
Promotional	68.50
Promotional	56.00
Regular	47.50
Promotional	30.80
Regular	154.00
Regular	117.00
Promotional	41.60
Promotional	67.60
Promotional	105.20
Promotional	32.42
Regular	169.75
Promotional	239.50
Regular	76.00
Regular	49.50
Promotional	263.00
Promotional	297.59
Promotional	57.60
Promotional	38.44

Jun 08, 2022

SOLUTION.PDF

Construct a COMPARATIVE (also known as SIDE-BY-SIDE) box-and-whisker plot and find the summary statistics (including the quartiles) for net sales by each type of customer (regular/promotion) . Make...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment