ANSWER ALL THE FOUR QUESTIONS 25 MARKS EACH 1. 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 Items Customer 1 Net Sales (GH) 100 1 Age 32 36 2 1 105 3 1 230 32 4 5 300 Customer Regular Promotional Regular Promotional Regular Regular Promotional Promotional Promotional 28 34 5 2 150 6 20 450 44 7 2 78 8 3 120 30 22 56 9 6 345 10 Promotional 1 200 28 11 4 300 38 50 10 250 12 13 2 74 42 14 Promotional Promotional Regular Promotional Promotional Regular Promotional 2 400 48 15 Marital Gender Status Male Married Female Single Female Married Male Married Female Single Female Married Male Married Female Single Female Married Female Single Female Married Female Married Female Married Male Married Female Married Female Married Female Single Female Married Female Married Male Married Female Married Female Single Female Married Male Married Female Single Female Single Male Married Female Married Female Married Male Single 1 310 Method of Payment Vodacash MTN mobile money Airtel money MTN mobile money Vodacash Vodacash MTN mobile money MTN mobile money Airtel money MTN mobile money MTN mobile money Airtel money MTN mobile money Airtel money MTN mobile money Vodacash MTN mobile money MTN mobile money Airtel money MTN mobile money MTN mobile money Airtel money MTN mobile money MTN mobile money Vodacash Vodacash Vodacash Vodacash Airtel money Airtel money 60 16 1 85 54 17 3 90 32 18 1 82 70 19 2 63 28 20 15 350 52 3 160 44 1 54 21 22 23 24 62 340 2 60 Promotional Promotional Regular Promotional Promotional Promotional Promotional Regular Regular Promotional Regular Promotional 5 120 68 25 1 58 78 | | 26 2 74 20 27 5 255 28 28 2 90 54 29 2 80 68 30 Promotional 6 50 80 2 Page Managerial Report 1: 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) The type of Skewness for the Net Sales distribution c) The type of Kurtosis for the Net Sales distribution d) The Relationship between the Age of customers and Net Sales. Explain your model e) The Relationship between Number of items purchased and Net Sales. Explain your model