Given the data, please make sure to identify the type of each variable before you start analyzing the data. (For example, determine whether gender is a categorical or quantitative variable.) At a minimum, your project is expected to include the following and further analysis that helps the management. L. Select one categorical variable (such as gender). Then, construct a frequency distribution for the selected variable by each type of customer (regular/promotional), graph, and compare the characteristics. What can you conclude? To analyze the totally number of items purchased, construct an ungrouped frequency distribution, histogram, and find the summary statistics (including the quartiles) by each type of customer (regular/promotion). 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. What can you conclude? To analyze customer age, construct a frequency distribution, histogram, 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. What can you conclude? 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? Hint: A COMPARATIVE (SIDE-BY-SIDE) box-and-whisker plot is constructed by placing single boxplots adjacent to one another on a single scale. Create a scatterplot between customer age and net sales by each type of customer (regular/promotion). Use the horizontal axis for the customer age to graph. Construct a correlation matrix to find the correlation coefficient between customer age and net sales by each type of customer and INTERPRET the value. Find the linear regression line that models the data by each type of customer. Round the rate of changes (slopes) to two decimal places and INTERPRET them in terms of the relation between the change in age and the change in net sales. What can you conclude? Hint: Rate of Change = Vertical Change / Horizontal Change = Change in y / Change in x Include additional further statistical analysis that shows originality and creativity to help the management. (Discuss in your group and develop more creative/advance analysis that should help the management. Constructing one more bar graph or pie chart is NOT sufficient for this analysis.) Type of Marital Method of Customer Customer Gender Payment Age Net Sales dentify the type of ATTN: The provided data are not exactly the same each session/semester. That 1 Regular Male Discover 54.50 is, students during the previous session/semester analyzed a little different data. Promotions Proprietary Card 122.40 Qualitative or Quantitative? 3 Regular 4 Promotional Proprietary Card 120.40 5 Regular MasterCard 69.00 59.50 6 Regular MasterCard Shop 98.00 7 Promotional Proprietary Card 8 Regular Visa 37.50 on a regular basis 9 Promotional 10 Regular Proprietary Card Proprietary Car Regular Promotional don't shop at the store 11 Regular 12 Pr Proprietary Card customer on a hegulan basis . customer 13 Promotional But came to Shop 14 Promotional because they received Regular To Promotiona 17 Promotional Proprietary Card Gender a discount coupon . 18 Regular Discover Marital Status Type of data ? Payment Methods 20 Promotional . Customer's 21 Promotional 22 Promot Age demographics 23 Pron 24 Re Items 25 Pr 26 Pr How much spent . How many items purchased 28 Prom How much 29 Promotional 30 Pr was spent 31 Pr 32 Re 33 Promotion 34 Regular 36 Re 37 Re omotion 41 Pr 42 Pr -ANOWNN - GOD- WINN- NAONMON - UNWNN - -NEO-WHOHAD- AMANWAONNWANANN - ACONON - N -G 83 Pr 84 Pr 85 Re 86 Pr 87 Reg 88 Re 9 Promotion 90 Pr 91 Pr 92 Pr 93 Reg 94 Promotion 95 Re 97 Pr notional 98 Promotional 99 Pr 00 PromotionalType of Method of Customer Customer Gender Payment Age tems Net Sales There are 8 variables. ATTN: The provided data are not exactly the same each session/semester. That Male 54.50 Married dentify the type of each variable. Proprietary Card is, students during the previous session/semester analyzed a little differe 37.50 Married Qualitative or Quantitative? MasterCard 69.00 Married MasterCard 59.50 Married Visa 37.50 Married Proprietary Card 59.50 Shop Proprietary Card 64 50 on a regular basis Married Discover Regular Proprietary Care Promotional don't shop at the store Married customer customer on a hegalan basis . Married Proprietary Car y Card Married Proprietary But came to Shop because they received Single MasterCard Gender a discount coupon Single Visa 117.50 Marital Status Proprietary Card Payment methods Mastercard 138 50 Type of data ? . Customer's Discover Age demographics Items MasterCard How much spent Proprietary Card How many items purchase Proprietary Card Married Discover How much was spent MasterCard Proprietary Card Proprietary Ca MasterCard Proprietary C Propriete Proprietary Card prietary Card Proprietary Card Propriet merican Ex Married