AutoSave O Off) H PelicanStores (1) - Excel Search himra afzaal File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments Times New Roman 12 - = ag General Conditional Formatting * Insert 2 AY B U v A A $ Format as Table v x Delete Analyze Sensitivity Paste Data A Cell Styles ~ Format Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity J11 X V A B C D E G H J K L M N O P Q R Type of Method of Marital Customer Customer Items Net Sales Payment Gender Status Age Regular 1 39.50 Discover Male Married 32 2 Promotional 1 102.40 Proprietary Card Female Married 36 Regular 22.50 Proprietary Card Female Married 32 AW Promotiona 100.40 Proprietary Card Female Married 28 Regular 54.00 MasterCard Female Married 34 6 Regular 14.50 MasterCard Female Married 44 7 Promotional 78.00 Proprietary Card Female Married 30 N - NP 9 8 Regular 22.50 Visa Female Married 40 10 9 Promotional 56.52 Proprietary Card Female Married 46 11 10 Regular 44.50 Proprietary Card Female Married 36 12 11 Regular 29.50 Proprietary Card Female Married 48 13 12 Promotiona 31.60 Proprietary Card Female Married 40 14 13 Promotional 160.40 Visa Female Married 40 15 14 Promotional 2 64.50 Visa Female Married 46 16 15 Regular 19.50 Visa Male Single 24 17 16 Promotiona 71.40 Proprietary Card Male Single 36 18 17 Promotional NWWN 94.00 Proprietary Card Female Single 22 19 18 Regular $4.50 Discover Female Married 40 20 19 Promotional 38.50 MasterCard Female Married 32 21 20 Promotional 44.80 Proprietary Card Female Married 56 22 21 Promotional 31.60 Proprietary Card Female Single 28 23 22 Promotional 4 70.82 Proprietary Card Female Married 38 24 23 Promotional 7 266.00 American Express Female Married 50 25 24 Regular 74.00 Proprietary Card Female Married 42 26 25 Promotiona 39.50 Visa Male Married 48 27 26 Promotiona 1 30.02 Proprietary Card Female Married 60 28 27 Regular 1 44.50 Proprietary Card Female Married 54 Data + D 110% 6:57 PM Type here to search O W 3/30/2021AutoSave O Off) H PelicanStores (1) - Excel Search himra afzaal File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments Times New Roman 12 - ag General Conditional Formatting * Insert 2 AY B U v A A $ Format as Table x Delete Analyze Paste Sensitivity Data A Cell Styles ~ Format Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity J11 X V A B C D E F G H I J K L M N O P Q R 29 28 Promotiona 42 U 192.80 Proprietary Card Female Single 30 20 Promotiona 71.20 Proprietary Card Female Married 32 31 30 Promotiona 18.00 Proprietary Card Female Married 70 32 31 Promotional IN 63.20 MasterCard Female Married 28 33 32 Regular 75.00 Proprietary Card Female Married 52 34 33 Promotiona 63.20 Proprietary Card Female Married 44 - W 35 34 Regular 40.00 Proprietary Card Female Married 34 36 Promotiona 5 105.50 MasterCard Female Married 56 37 36 Regular 1 29.50 MasterCard Male Single 36 38 37 Regular 2 102.50 Visa Female Single 42 39 38 Promotional 6 117.50 Proprietary Card Female Married 50 40 39 Promotional 5 13.23 Proprietary Card Female Married 44 41 40 Regular 2 $2.50 Proprietary Card Female Married 58 42 41 Promotiona 13 198.80 Proprietary Card Female Married 42 43 42 Promotiona 4 19.50 Visa Female Married 46 44 43 Regular 2 123.50 Proprietary Card Female Married 48 45 44 Promotional 62.40 Proprietary Card Female Married 54 46 45 Promotiona 23.80 Proprietary Card Female Married 38 47 46 Promotional 39.60 Proprietary Card Female Married 60 48 47 Regular 25.00 MasterCard Female Married 46 W H 49 48 Promotional 63.64 Proprietary Card Female Married 30 50 49 Promotional 14.82 Proprietary Card Female Married 32 51 50 Promotional 145.20 MasterCard Female Married 46 52 51 Promotional 6 176.62 Proprietary Card Female Married 38 53 52 Promotiona 5 118.80 Proprietary Card Male Married 68 54 53 Regular 58.00 Discover Female Single 78 55 54 Regular 74.00 Visa Female Single 20 56 55 Regular 2 19.50 MasterCard Female Married 32 57 56 Promotional 3 141.60 Proprietary Card Female Married 38 Data + D 110% Type here to search O Si W 6:57 PM 3/30/2021AutoSave O Off) H PelicanStores (1) - Excel Search himra afzaal File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments 12 - Times New Roman ag General Conditional Formatting * Insert 2 AY B U v A A $ Format as Table v x Delete Analyze Sensitivity Paste Data A Cell Styles ~ Format Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity J11 X V B C D E F G H I J K L M N O P A Q R 58 57 Promotiona 6 123.10 Proprietary Card Female Married 54 59 58 Promotiona 80.40 Proprietary Card Female Married 48 60 50 Promotiona 65.20 MasterCard Female Married 46 61 60 Promotiona 4 113.00 Proprietary Card Female Single 50 62 61 Promotiona 108.80 Proprietary Card Female Married 46 63 62 Promotiona U W H 59.91 Proprietary Card Female Single 30 64 63 Promotional 53.60 Proprietary Card Female Married 54 65 64 Promotiona 31.60 Proprietary Card Female Single 42 66 65 Promotional 49.50 Proprietary Card Female Married 48 67 66 Promotional 39.60 Proprietary Card Female Married 62 68 67 Promotional 2 59.50 Proprietary Card Female Married 34 69 68 Promotiona 5 146.80 Proprietary Card Female Married 28 70 69 Promotional 47.20 Proprietary Card Male Married 46 CO N0 71 70 Promotional 95.05 Proprietary Card Female Married 54 72 71 Promotional 5 155.32 Proprietary Card Female Married 30 73 72 Promotiona 4 58.00 MasterCard Female Married 32 74 73 Regular 69.00 Proprietary Card Female Single 22 75 74 Promotiona 46.50 Proprietary Card Female Married 32 76 75 Promotiona 45.22 Proprietary Card Female Married 74 77 76 Promotional 84.74 Proprietary Card Female Married 62 78 77 Regular 39.00 Proprietary Card Female Married 42 79 78 Promotional 111.14 Proprietary Card Female Married 28 80 79 Promotiona 3 86.80 Proprietary Card Female Married 38 81 80 Regular 2 89.00 Discover Female Married 54 82 81 Promotiona IN 78.00 MasterCard Female Married 68 83 82 Promotional 6 53.20 Proprietary Card Female Single 30 84 83 Promotiona 4 58.50 Visa Female Married 36 85 84 Promotional 3 46.00 Proprietary Card Female Married 44 86 85 Regular 2 37.50 Visa Female Married 44 Data + D 110% 6:58 PM Type here to search O W 3/30/202187 86 Promotiona 20.80 Proprietary Card Female Married 62 88 87 Regular 6 144.00 MasterCard Female Single 48 89 88 Regular 4 107.00 Proprietary Card Female Married 36 90 89 Promotiona 31.60 Proprietary Card Female Single 20 91 90 Promotiona 57.60 Proprietary Card Female Married 42 92 91 Promotional 4 95.20 Proprietary Card Female Married 54 93 92 Promotiona 22.42 Proprietary Card Female Married 54 94 93 Regular 5 159.75 Proprietary Card Female Married 72 95 94 Promotiona 17 229.50 Proprietary Card Female Married 30 96 95 Regular 3 66.00 American Express Female Married 46 97 96 Regular 39.50 MasterCard Female Married 44 98 97 Promotiona 9 253.00 Proprietary Card Female Married 30 99 98 Promotiona 10 287.59 Proprietary Card Female Married 52 100 99 Promotiona 2 47.60 Proprietary Card Female Married 30 101 100 Promotiona 28.44 Proprietary Card Female Married 44Pelican Stores, a division of National Clothing, is a chain of women's apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores. Data collected for a sample of 100 in-store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the DATA file name PelicanStores. Customers who made a purchase using a discount coupon are referred to as promotional customers and customers who made a purchase but did not use a discount coupon are referred to as regular customer. Because the promotional coupons were not sent regular Pelican Stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, Pelican also hopes that the promotional customers will continue to shop at its stores. Description of variables Type of Customer: the type customers are described as promotional or regular Items: the number of items customers purchased Net Sales ($): the total sales in dollars by customers Method of Payment: the type of payment Gender: the gender of the customers Marital Status: the marital status of the customers Age: the age of the customers Part 1. Computation A) Create a crosstabulation for Type of Customer versus the Method of Payment using SPSS. Must use SPSS to receive any credit. B) Create a bar chart/ histogram to summarize the variable Items using Excel. Make sure to format your chart (title and labels) to receive full credit. C) Find the sample mean, standard deviation, minimum, maximum, kurtosis, and skewness of Items purchased using SPSS. Must use SPSS to receive any credit. D) Do a side-by-side box-and-whisker plot for Net Sales, separated by Method of Payment using SPSS. Must use SPSS to receive any credit.E) Construct a 95% confidence interval for the population mean of Net Sales (identify the lower and upper bound in the output) using SPSS. Must use SPSS to receive any credit. Part 2. Interpretation In an effort to understand how successful the promotion was, Pelican Stores management has produced the following statistics about this sample of 100 in store customers that make a purchase during this one-day promotional event. The following are the descriptive statistics for the variables NetSales separated by costumer type (promotional or regular). Descriptives * Type of Customer = Promotional Descriptive Statistics" N Minimum Maximum Mean Sid. Deviation Skewness Kurtosis Statistic Statistic Statistic Statistic Statistic Sid. Error Statistic Stil Error Net Sales 70 13.23000900 287.5900000 84.29000090 61.46229694 1.520 287 2.136 566 Valid N Distavis=] 70 a. Type of Customer = Promotional Type of Customer = Regular Descriptive Statistics" N Minimum Maximum Mean Sid. Deviation Skewness Kurtosis Statist statistic Statistic Statistic Statistic Statistic Std. Error Statistic Std. Error Net Sales 30 23.50080900 159.7500000 61.99165667 35.06794411 1.351 427 1.402 833 Valid N Distwise] a. Type of Customer = Regular Describe the mean, standard deviation, skewness and kurtosis for regular and promotional customers (using the information right above). Make sure to explain each statistic for each type of customer to receive full credit. Write three paragraphs: the first two paragraphs should be interpreting the Net Sales for each type of customer. The third should be comparing their Net Sales. The following is a crosstabulation of the number of items and the net sales in a single purchase for promotional customers.Promotional Customers Net Sales in a single purchase # of Items Purchased 10-35 35-60 60-85 85-110 110-135 135-160 160-185 185-210 210-235 235-260 260-285 285-310 Total 14 13 19 13 70 II. Using the crosstabulation right above, describe the relationship between the number of items and the net sales earned. Please make sure to write enough to fully described the relationship (give examples to show the relationship). The following is a side-by-side box plot of Items by type of customer. Boxplot of Net Sales by Type of Customer 326.00 300.00 275 0 250.00 226.00 200.00 175.00 Net Sales ($ 150 00 125.00 100 .00 75.00 50.00 25.00 Promotional Regular Type of Customer III. Describe and compare the distribution of Net Sales by the type of customers. Use what we know about the different quartiles (Q1, Q2, & Q3) to make comparisons and describe the distribution in terms of the context of the problem. Make sure to write full sentences.To estimate the net sale in future promotions, 95% confidence intervals for the population means were constructed. See output below. Descriptives Type of Customer Statistic 514 Error Net Sales Promotio Mean 84.2900 7.34615 95% Confidence Interval Lower Bound 60.6346 for Mean Upper Bound 90.945 5% Trimmed Mean 78.1454 Madian 63.4200 Variance 3777.614 Sid Deviation 61.46230 Minimum 13.23 Maximum 287.5 Range 274.35 Interquartile Range 85.66 Skewness 1.520 287 Kuriosis 2.135 .565 Regular Mean 61.9017 6.40250 95% Confidence Interval Lower Bound 48.8971 for Mean Upper Bound 75.0863 5% Trimmed Mean 590463 Median 51.0000 Variance 1729.761 SM Deviation 15.06794 Minimum 22.50 Maximum 159.75 Range 137.25 Interquartile Range 34.BB Skewness 1.351 437 Kurlosis 1.402 .833 IV. Explain and compare the confidence interval for NetSales for Promotional and Regular customers. Make sure to clearly describe the confidence intervals in the context of the problem. V. Based on the overall results, write a recommendation to the management of Pelican Stores regarding future promotional events such as this one. Must write at least a full paragraph and use the previews results from both part of the test to support your recommendation