Question

In: Statistics and Probability

Chic Sales is a high-end consignment store with several locations in the metro area. The company noticed a decrease in sales over the last fiscal year.

WHICH STORE SHOULD BE CLOSED AND WHY?

Simple Regression Models Case Study: Mystery Shoppers

Chic Sales is a high-end consignment store with several locations in the metro area. The company noticed a decrease in sales over the last fiscal year. Research indicated customer satisfaction had decreased and the owner, Pat Turner, decided to create a mystery shopper program.

The mystery shopper program lasted over a 6-month period, employing several loyal and new customers assigned to each location. Surveys were on a 100-point scale and involved categories such as “Staff Attitude,” “Store Cleanliness,” “Product Availability,” and “Display(s) Appeal.”

After the mystery shopper period concludes, Mrs. Turner sends you the following e-mail:

From: Pat Turner
Sent: Thursday, July 7, 2016 8:57 a.m.
Subject: Mystery Data Shopper Stats and Store Performance?

Good morning! Welcome back from vacation J I hope you had a wonderful Fourth of July.

The last mystery shopper surveys came in and I have the final numbers. I am interested in whether there is a way to predict the final average based on the initial survey score. Also, is there a statistically significant relationship between how stores initially performed and what the overall average is?

The initial survey score and the final average data for all seven store locations is in the table below:

Store

1

2

3

4

5

6

7

Initial Survey Score

83

97

84

72

85

64

93

Final Average

78

98

92

75

88

70

93

Also, how good is the relationship between Initial Survey Score and the Final Average? Could I use an Initial Survey Score to predict a Final Average? In fact, could I predict a Final Average if I have an Initial Survey Score of 90?

If you could have this to me before the weekend, that would be great.

Thanks so much!

Pat Turner, Owner

Chic Sales Consignment, LLC

Solutions

Expert Solution

We are interested in whether there is a way to predict the final average based on the initial survey score. Also, is there a statistically significant relationship between how stores initially performed and what the overall average is?

Also, how good is the relationship between Initial Survey Score and the Final Average?

Could I use an Initial Survey Score to predict a Final Average? In fact, could I predict a Final Average if I have an Initial Survey Score of 90?

To predict the final average based on the initial survey score we use Regression analysis.

The regression output of the initial and final average is

The regression equation is

This relationship has p-value 0.0025<<0.05. So we conclude that there is a statistically significant relationship between the two variables.

We can predict the final average by using the regression equation. To predict a Final Average if Initial Survey Score of 90


Related Solutions

For the company AMAZON Did its total assets increase or decrease over last year? By what...
For the company AMAZON Did its total assets increase or decrease over last year? By what percentage? (Hint: Percentage change is calculated as [current year - last year] / last year. Show supporting computations.) Did its net income increase or decrease over last year? By what percentage? Which of the following had the largest percentage increase from last year to the current year? (See the formula in 6. above. Show all supporting computations.) a. Net sales b. Cost of sales...
Fuzzy Button Clothing Company reported sales of $720,000 at the end of last year; but this...
Fuzzy Button Clothing Company reported sales of $720,000 at the end of last year; but this year, sales are expected to grow by 9%. Fuzzy Button expects to maintain its current profit margin of 21% and dividend payout ratio of 15%. The firm’s total assets equaled $500,000 and were operated at full capacity. Fuzzy Button’s balance sheet shows the following current liabilities: accounts payable of $75,000, notes payable of $25,000, and accrued liabilities of $70,000. Based on the AFN (Additional...
Arundel Company uses percentage of sales to estimate uncollectibles.  At the end of the fiscal year, December...
Arundel Company uses percentage of sales to estimate uncollectibles.  At the end of the fiscal year, December 31, 2018, Accounts Receivable has a balance of $78,000 and had a total of $875,000 in credit sales. Arundel assumes that 1.5% of sales will eventually be uncollectible. before adjustment, the Allowance for Uncollectible Accounts had a credit balance of 4,500. What dollar amount should be credited to Allowance for Uncollectible Accounts at year end?
Arundel Company uses percentage of sales to estimate uncollectibles.  At the end of the fiscal year, December...
Arundel Company uses percentage of sales to estimate uncollectibles.  At the end of the fiscal year, December 31, 2018, Accounts Receivable has a balance of $78,000 and had a total of $810,000 in credit sales. Arundel assumes that 2.0% of sales will eventually be uncollectible. before adjustment, the Allowance for Uncollectible Accounts had a credit balance of 6,000. What dollar amount should be credited to Allowance for Uncollectible Accounts at year end?
Last year a company had sales of $800,000, operating costs of 70%, and year-end assets of...
Last year a company had sales of $800,000, operating costs of 70%, and year-end assets of $1,500,000. The debt-to-total-assets ratio was 20%, the interest rate on the debt was 10.00%, and the tax rate was 21%. The new CFO wants to see how the ROE would have been affected if the firm had used a 30% debt ratio. Assume that sales and total assets would not be affected, and that the interest rate and tax rate would both remain constant....
A manufacturing company producing medical devices reported $108,000,000 in sales over the last year. At the...
A manufacturing company producing medical devices reported $108,000,000 in sales over the last year. At the end of the same year, the company had $42,000,000 worth of inventory of ready-to-ship devices. a. Assuming that units in inventory are valued (based on COGS) at $2,000 per unit and are sold for $4,000 per unit, what are the annual inventory turns? The company uses a 20 percent per year cost of inventory. That is, for the hypothetical case that one unit of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT