the data consists of 400 customer orders during a period of several months for the fictional Elecmart company.

Low Date Day 3/6/15 Tue 3/6/15 Tue 3/6/15 Tue 3/6/15 Tue 3/6/15 Tue 3/6/15 Tue 3/7/15 Wed 3/7/15 Wed 3/7/15 Wed 3/8/15 Thu 3/8/15 Thu 3/8/15 Thu 3/9/15 Fri 3/9/15 Fri 3/10/15 Sat 3/10/15 Sat 3/10/15 Sat 3/10/15 Sat 3/11/15 Sun 3/11/15 Sun 3/12/15 Mon 3/12/15 Mon 3/12/15 Mon 3/13/15 Tue 3/13/15 Tue 3/14/15 Wed 3/14/15 Wed 3/14/15 Wed 3/15/15 Thu 3/15/15 Thu 3/16/15 Fri 3/16/15 Fri 3/16/15 Fri 3/16/15 Fri 3/17/15 Sat 3/17/15 Sat 3/17/15 Sat 3/18/15 Sun 3/18/15 Sun 3/18/15 Sun 3/18/15 Sun 3/18/15 Sun 3/18/15 Sun 28/15 Sun Time Region Card Typ Gender Buy Cates Orderea Total Cost High Item Morning West Elec Mart Female High 4 $136.97 $79.97 Morning West Other Female Medium 1 $25.55 $25.55 Afternoon West Elec Mart Female Medium 5 $113.95 $90.47 Afternoon NorthEast Other Female Low 1 $6.82 $6.82 Afternoon West ElecMart Male Medium 4 $147.32 $83.21 Afternoon NorthEast Other Female Medium 5 $142.15 $50.90 Evening West Other Male Low 1 $18.65 $18.65 Evening South Other Male High 4 $178.34 $161.93 Evening West Other Male Low 2 $25.83 $15.91 Morning MidWest Other Female Low 1 $18.13 $18.13 Morning NorthEast Elec Mart Female Medium 2 $54.52 $54.38 Afternoon South Other Male Medium 2 $61.93 $56.32 Morning NorthEast ElecMart Male High 3 $147.68 $96.64 Afternoon North East Other Male Low 1 $27.24 $27.24 Morning West Other Female 3 $46.18 $44.27 Afternoon West Other Male Low 5 $107.44 $91.64 Afternoon South Elec Mart Female Medium 6 $96.53 $93.68 Afternoon West Elec Mart Female Medium 4 $77.44 $77.28 Morning South Other Male Low 1 $15.19 $15.19 Afternoon South Other Male Medium 1 $45.52 $45.52 Morning West Other Male High 4 $157.05 $146.28 Afternoon West Other Male Medium 2 $51.95 $30.40 Evening West ElecMart Female High 9 $429.98 $381.33 Afternoon South Other Female Low 1 $33.37 $33.37 Evening West Other Male Medium 3 $71.84 $34.13 Morning NorthEast Elec Mart Female Medium 5 $139.51 $133.11 Afternoon South Other Male Medium 3 $78.46 $58.53 Evening MidWest Other Male High 3 $125.13 $103.31 Afternoon MidWest Other Male Medium 1 $14.76 $14.76 Afternoon South Elec Mart Female High 2 $83.38 $71.02 Morning West Other Female High 3 $104.91 $47.79 Afternoon NorthEast Other Male Medium 4 $101.37 $88.21 Afternoon NorthEast Other Female Low 2 $53.16 $36.78 Evening Other Female Low 2 $40.63 $25.82 Morning West Other Female High 7 $286.41 $119.78 Afternoon South Other Female High $59.39 $40.89 Evening NorthEast Other Male High $185.45 $83.38 Morning NorthEast Other Female Low $35.08 $32.95 Morning MidWest ElecMart Male 2 591.62 $90.91 Morning NorthEast Other Female Medium 8 $155.50 Evening West $114.31 Other Male Low Evening West $20.89 $13.16 Other Male High 6 $186.29 Evening $69.18 West Other Female Low Evening $42.22 West $42.22 Other Mate 542 19 West NNN High Low Text Shape Media Cor Problem 5 Other NNNNNN 125% Insert Table Chart View Zoom Problem 3 Problem 4 + Problem 1 Problem 2 Female Afternoon NorthEast Other Low 3/16/15 Fri Other Evening West Female Low 3/16/15 Fri Other Morning West Female High 3/17/15 Sat 3/17/15 Sat Afternoon South Female High 3/17/15 Sat Evening North East Other Male High 3/18/15 Sun Morning NorthEast Other Female Low 3/18/15 Sun Morning MidWest ElecMart Male High 3/18/15 Sun Morning NorthEast Other Female Medium 3/18/15 Sun Evening West Other Male Low 3/18/15 Sun Evening West Other Male High 3/18/15 Sun Evening West Other Female Low 3/18/15 Sun Evening West Other Male Low 3/19/15 Mon Afternoon MidWest Other Female Low 3/20/15 Tue Morning South Other Female High 3/20/15 Tue Morning NorthEast Other Female Medium 3/20/15 Tue Afternoon South Other Female Low 3/20/15 Tue Afternoon West Other Female Medium 3/20/15 Tue Afternoon South Other Female Low 3/21/15 Wed Morning West Other Female Low 3/21/15 Wed Afternoon South Other Female High 3/21/15 Wed Evening West Other Male Medium 3/22/15 THU Morning West Other Female Low 3/23/15 Fri Morning West Other Female Medium 3/23/15 Fri Afternoon West ElecMart Female 3/24/15 Sat Morning NorthEast Other Female Medium 3/24/15 Sat Afternoon South Other Female Low 3/24/15 Sat Afternoon West ElecMart Male Medium 3/24/15 Sat Evening NorthEast Other Male Low 3/25/15 Sun Morning NorthEast Other Female Low 3/25/15 Sun Morning NorthEast Other Male 3/25/15 Sun Morning MidWest Other Male Medium 3/25/15 Sun Morning NorthEast Other Female Low 3/25/15 Sun Afternoon NorthEast Other Female Medium 3/25/15 Sun Afternoon Mid West Other Male Low 3/25/15 Sun Afternoon South Other Female Low 3/25/15 Sun Afternoon MidWest ElecMart Male Medium 3/25/15 Sun Evening NorthEast Other 3/25/15 Sun Male Low Evening South Other Female Low 3/26/15 Mon Afternoon South ElecMart Female Low 3/26/15 Mon Evening Other 3/27/15 Tue Female LOW Afternoon South Other Female 3/27/15 Tue Alternoon Mid West ElecMart Male High 3/27/15 Tue Medium Evening West Other Male 3/27/15 Tue High Evening NorthEast Other 3/28/15 Wed Male Low Morning NorthEast Other Male Medium $53.16 $36.78 $40.63 $25.82 7 $286.41 $119.78 $59.39 $40.89 4 $185.45 $83.38 $35.08 $32.95 $91.62 $90.91 8 $155.50 $114.31 4 $20.89 $13.16 6 $186.29 $69.18 1 $42.22 $42.22 2 $42.19 $30.55 1 $47.86 $47.86 3 $139.76 $59.51 6 $186.42 $116.36 -1 $54.08 $54.08 3 $84.98 $79.81 2 $27.13 $25.99 2 $54.70 $45.89 5 $229.54 $201.73 4 $124.21 $84.30 2 $26.39 $15.59 4 $106.97 $93.90 8 $377.18 $320.31 1 $24.31 $24.31 1 $34.47 $34.47 3 $106.19 $91.00 $55.30 $43.78 $82.98 $53.39 4 $101.79 $29.05 3 $99.28 $80.58 3 $100.09 $38.16 3 $88.91 $85.34 2 $62.58 $39.57 1 $28.87 $28.87 4 $141.29 $114.81 4 $66.54 $44.84 2 $69.03 $63.21 2 $65.51 $37.24 2 $35.59 $21.23 7 $320.18 $308.28 5 $128.57 $111.98 6 $248.42 $102.31 2 $50.04 $32.51 4 $145.48 $62.58 High NN Low West a. Build a pivot table to find the the Sum of Total Cost of orders placed by customers from the "MidWest" in the morning. b. Build a pivot table to find the average Total Cost for Monday Evening. c. Build a pivot table to count how many orders were placed from the "South