CLASS EXERCISE 26 July 2021 Case Problem I. Promotional Campaign Purchases. The management of a certain company would like to use the following data to learn about its customer base and to evaluate the first day promotional campaign purchases. Customers who made purchases with discount coupons were labelled as "Promotional Customers", and "Regular Customers" was used for those who did not use coupons. Type of Net Sales Customer Customer Marital Items (GHO) Method of Payment Gender Status Regular Age 100 Vodafone cash Male Married 32 Promotional 105 MTN mobile money Female Single 36 Regular 230 Airtel money Female Married Promotional 300 MTN mobile money Male Married Regular 150 Vodafone cash Female Single Regular 450 Vodafone cash Female Married 44 Promotional 78 MTN mobile money 8 Male Married 30 Promotional 120 MTN mobile money Female Single 9 22 Promotional 345 Airtel money Female Married 10 Promotional 200 MTN mobile money Female Single 28 Promotional 300 MTN mobile money Female Married 38 12 Promotional 250 Airtel money Female Married 50 13 Regular 74 MTN mobile money Female Married 42 14 Promotional 400 Airtel money Male Married 48 IS Promotional 310 MTN mobile money Female Married 60 16 Regular 85 Vodafone cash Female Married 54 17 Promotional 90 MTN mobile money Female Single 32 18 Promotional 82 MTN mobile money Female Married 19 Promotional 63 Airtel money Female Married 20 Regular 350 MTN mobile money Male Married 52 Use descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign, by finding the following; a) Frequency distribution of the Net Sales using the intervals 50-99,100-149, 150-199,... b) Calculate the mean and standard deviation of the Net sales data and use them to show whether this particular data is a normal distribution data or not. c) Compute the Coefficient of Skewness of the Net sales data to show whether this particular data is a normal distribution data or not. d) Use the tools of Regression and correlation to find the relationship between the Net Sales and the Age of customers by using; (i) The Scatter Plot (ii) The Least Square Method (iii) The Coefficient of correlation, Interprete your results