MIDTERM EXAM Pelican Stores, a division of National Clothing, is a chain of women's apparel stores operating
Question:
MIDTERM EXAM Pelican 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. Please record all your answers in the answer sheet Word document. You must format all your tables and graphs. Make sure to write full sentences when answering the questions and write your answer in the context of the problem.
E) Construct a 95% confidence interval for the average number of items customer purchase at the store (identify the lower and upper bound in the output). 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). I. Interpret the descriptive statistics 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. 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 support your conclusion). The following is a side-by-side box plot of Items by 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 average net sale in future promotions, 95% confidence intervals for the population means were constructed for both promotional and regular customers. See output below. 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.