Question 2 South Texas Apparels ( 55 points For this question, please round all calculations to 2 decimal places ) South Texas Apparels, 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 South Texas Apparels for one day while the promotion was running are contained in the Microsoft Excel spreadsheet named South Texas Apparels 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 customers Because the promotional coupons were not sent to regular South Texas Apparels customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make Of course, South Texas Apparels hopes that the promotional customers will eventually turn into regular customers Given this background, South Texas Apparels 's management would like to use the sample data to learn about its customer base and to evaluate the promotion involving discount coupons Most of the variables captured in the data are self explanatory, but two of the variables require some clarification Items the total number of items purchased Net Sales the total amount ($) charged to the credit card Calculate the following measures of location (mean, median) and measures of variability (range, standard deviation, interquartile range, and coefficient of variation) for Net Sales of All customers Measures of Location All Customers Mean Median Measures of Variability All Customers Range Standard Deviation Interquartile Range (IQR) Coefficient of Variation Interpret to South Texas Apparels' management the information conveyed by each of the measures of location and measures of variability that you calculated in part (a) Based on your calculations in part (a), is the data on Net Sales for all customers normally distributed , skewed to the right , or skewed to the left Why Based on your response in part (c), which measure of location provides a more representative summary of the data Calculate the following measures of location (mean, median) and measures of variability (range, standard deviation, interquartile range, and coefficient of variation) for Net Sales of Married Customers , Single Customers , Regular Customers , and Promotional Customers Married Customers Single Customers Regular Customers Promotional Customers Measures of Location Mean Median Measures of Variability Range Standard Deviation Interquartile Range (IQR) Coefficient of Variation Based on your calculations in part (e), what category of customers has the highest average spending based on the mean values Would your answer be different if you focused on the highest average spending based on the median values instead Explain Based on your calculations in part (e), what category of customers has the highest variability in spending based on the standard deviation values Would your answer be different if you focused on the highest variability in spending based on the coefficient of variation values instead Explain

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 19, 2024

Question 2. South Texas Apparels ( 55 points. For this question, please round all calculations to 2 decimal places ) South Texas Apparels, a division

Question 2. South Texas Apparels

(55 points. For this question, please round all calculations to 2 decimal places)

South Texas Apparels, 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 South Texas Apparels for one day while the promotion was running are contained in the Microsoft Excel spreadsheet named "South Texas Apparels". 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 customers. Because the promotional coupons were not sent to regular South Texas Apparels customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, South Texas Apparels hopes that the promotional customers will eventually turn into regular customers.

Given this background, South Texas Apparels 's management would like to use the sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

Most of the variables captured in the data are self-explanatory, but two of the variables require some clarification.

Items: the total number of items purchased
Net Sales: the total amount ($) charged to the credit card

Calculate the following measures of location (mean, median) and measures of variability (range, standard deviation, interquartile range, and coefficient of variation) for "Net Sales" of All customers.

Measures of Location	All Customers
Mean
Median

Measures of Variability	All Customers
Range
Standard Deviation
Interquartile Range (IQR)
Coefficient of Variation

Interpret to South Texas Apparels' management the information conveyed by each of the measures of location and measures of variability that you calculated in part (a).

Based on your calculations in part (a), is the data on Net Sales for all customers normally distributed, skewed to the right, or skewed to the left? Why?

Based on your response in part (c), which measure of location provides a more representative summary of the data?

Calculate the following measures of location (mean, median) and measures of variability (range, standard deviation, interquartile range, and coefficient of variation) for "Net Sales" of Married Customers, Single Customers, Regular Customers, and Promotional Customers.

		Married Customers	Single Customers	Regular Customers	Promotional Customers
Measures of Location	Mean
Median

Measures of Variability	Range
Standard Deviation
Interquartile Range (IQR)
Coefficient of Variation

Based on your calculations in part (e), what category of customers has the highest average spending based on the mean values? Would your answer be different if you focused on the highest average spending based on the median values instead? Explain.

Based on your calculations in part (e), what category of customers has the highest variability in spending based on the standard deviation values? Would your answer be different if you focused on the highest variability in spending based on the coefficient of variation values instead? Explain.