Question

In: Statistics and Probability

Automotive Department Store Automotive Department Store Formula 582 456 Part a 1513 465 Mean (to 2...

 
Automotive Department Store Automotive Department Store Formula
582 456 Part a
1513 465 Mean (to 2 decimals) #N/A #N/A
1574 476
1636 562 Part b
1712 583 Standard Deviation (to 2 decimals) #N/A #N/A
1724 596
1789 599 Part c
1792 624 Maximum #N/A #N/A
1804 627
2005 664 Minimum #N/A #N/A
2013 702
2032 712 Range (to 1 decimal) #N/A #N/A
2061 746
2171 764 Part d
2206 779 First Quartile (to 2 decimals) #N/A #N/A
2251 830
2365 839 Third Quartile (to 2 decimals) #N/A #N/A
2517 851
2538 946 Interquartile Range (to 2 decimals) #N/A #N/A
2904 1006

a. What is the mean advertising spent for each sector? Round your answers to 2 decimal places, if necessary.

Automotive Department Store
Mean $ $

b. What is the standard deviation for each sector? Round your answers to 2 decimal places.

Automotive Department Store
Standard deviation $ $

c. What is the range of advertising spent for each sector? Round your answers to 1 decimal place, if necessary.

Automotive Department Store
Range $ $

d. What is the interquartile range for each sector. Round your answers to 2 decimal places.

Automotive Department Store
IQR $ $

e. Based on this sample and your answers to parts (a) to (d), comment on any differences in the advertising spending in the automotive companies versus the department store companies.

Automotive spends _____lessmore on average, has a _________smallerlarger standard deviation, and _________largersmaller range than Department Store.

Solutions

Expert Solution

Solution:

Install analysis toolpak .Go to

Data>data analysis>descriptive statsistic

You will get

You will get

Automotive Department Store
Mean 1959.45 Mean 691.35
Standard Error 108.3499563 Standard Error 34.6169471
Median 2009 Median 683
Mode #N/A Mode #N/A
Standard Deviation 484.5557352 Standard Deviation 154.8116938
Sample Variance 234794.2605 Sample Variance 23966.66053
Kurtosis 2.654402229 Kurtosis -0.514249885
Skewness -0.775097092 Skewness 0.292301591
Range 2322 Range 550
Minimum 582 Minimum 456
Maximum 2904 Maximum 1006
Sum 39189 Sum 13827
Count 20 Count 20

From answers:

Automotive Department Store
Mean $1,959.45 $691.35

Solution-b:

Automotive Department Store
Standard deviation $484.56 $154.81

Solution-c:

Automotive Department Store
Range $2,322.00 $550.00

Solution-D

Automotive Department Store
IQR $496.25 $199.00
Formula
=AVERAGE(A2:A21) =AVERAGE(B2:B21)
=ROUND(STDEV.S((A2:A21)) =ROUND(STDEV.S((B2:B21))
=MAX(A2:A21) =MAX(B2:B21)
=MIN(A2:A21) =MIN(B2:B21)
=MAX-MIN ='MAX-MIN
'=QUARTILE.INC(A2:A21;1) '=QUARTILE.INC(B2:B21;1)
=QUARTILE.INC(A2:A21;3) '=QUARTILE.INC(B2:B21;3)
=Q3-Q1 Q3-Q1

Related Solutions

The manager of a department store believes that the mean annual income of the store's credit...
The manager of a department store believes that the mean annual income of the store's credit card customers is at least $21,000. For a sample of 90 customers the mean and standard deviation of income were found to be $20700 and $1450 respectively. (1) Use the tables in the textbook to determine the critical value for the test statistic at the 5% level of significance. State your answer correct to three decimal places. (2) Determine the calculated test statistic correct...
Indiciate whether each of the following management activities in a department store is part of planning,...
Indiciate whether each of the following management activities in a department store is part of planning, performing, evaluating, or communicating
Problem 9-8 (Part Level Submission) The records for the Clothing Department of Headland’s Discount Store are...
Problem 9-8 (Part Level Submission) The records for the Clothing Department of Headland’s Discount Store are summarized below for the month of January. Inventory, January 1: at retail $24,800; at cost $17,100 Purchases in January: at retail $135,400; at cost $86,710 Freight-in: $9,200 Purchase returns: at retail $3,000; at cost $2,200 Transfers in from suburban branch: at retail $13,200; at cost $7,000 Net markups: $8,100 Net markdowns: $4,100 Inventory losses due to normal breakage, etc.: at retail $300 Sales revenue...
A major department store chain is interested in estimating the mean amount its credit card customers...
A major department store chain is interested in estimating the mean amount its credit card customers spent on their first visit to the chain’s new store in the mall. Fifteen credit card accounts were randomly sampled and analyzed with the following results: X = $50.50 and S = 20. Assuming that the amount spent follows a normal distribution, construct a 95% confidence interval for the mean amount its credit card customers spent on their first visit to the chain’s new...
Problem 5-4A (Part Level Submission) Wolford Department Store is located in midtown Metropolis. During the past...
Problem 5-4A (Part Level Submission) Wolford Department Store is located in midtown Metropolis. During the past several years, net income has been declining because suburban shopping centers have been attracting business away from city areas. At the end of the company’s fiscal year on November 30, 2017, these accounts appeared in its adjusted trial balance. Accounts Payable $ 34,840 Accounts Receivable 22,360 Accumulated Depreciation—Equipment 88,400 Cash 10,400 Common Stock 45,500 Cost of Goods Sold 798,590 Freight-Out 8,060 Equipment 204,100 Depreciation...
Problem 5-4A (Part Level Submission) Wolford Department Store is located in midtown Metropolis. During the past...
Problem 5-4A (Part Level Submission) Wolford Department Store is located in midtown Metropolis. During the past several years, net income has been declining because suburban shopping centers have been attracting business away from city areas. At the end of the company’s fiscal year on November 30, 2017, these accounts appeared in its adjusted trial balance. Accounts Payable $ 38,056 Accounts Receivable 24,424 Accumulated Depreciation—Equipment 96,560 Cash 11,360 Common Stock 49,700 Cost of Goods Sold 872,306 Freight-Out 8,804 Equipment 222,940 Depreciation...
- Case Study 2: The Remote Health Information Management Department – Part 2 Read the objectives,...
- Case Study 2: The Remote Health Information Management Department – Part 2 Read the objectives, scenario and assumptions for Case Study 2: The Remote Health Information Management Department in Appendix E. Complete the deliverables (# 3 and #4) as instructed below: Using the functions you stated could be worked remotely (coding, ROI coordinators, data quality analysts and HIM managers and supervisors). Take each function you stated and develop a procedure and policy on how to evaluate the quality and...
Part 2 Chapter 3 page 127, Problem 1: Network Access Control Problem Description Ajax Automotive services...
Part 2 Chapter 3 page 127, Problem 1: Network Access Control Problem Description Ajax Automotive services retail automotive centers the east coast by supplying them with quality car and truck parts such as brake pads, oil filters, water pumps, etc. The company’s 123 sales representatives work exclusively in the field visiting client company locations and submitting sales orders from laptop computers via an internet connection to the corporate offices in Delaware. All of Ajax’s sales orders are received in this...
Problem 2 The D-Mart department store has sampled 225 sales records on July 14. The average...
Problem 2 The D-Mart department store has sampled 225 sales records on July 14. The average sale was Yen4200, with an observed sample standard deviation of Yen3000 per customer. (a) (10 points) Construct a 90% confidence interval for the mean sale value. (b) (10 points) How many sales records would need to be sampled for the 90% confidence interval to be within Yen100 of the sample mean?
DO ONLY PART D 2. A copy of a press release from Florida’s Department of Agriculture...
DO ONLY PART D 2. A copy of a press release from Florida’s Department of Agriculture is shown at the back of this problem set. The press release indicates that the prices of many commodities like sheets of plywood, batteries, and bottled water increase during or after a hurricane. The media sometimes refer to this increase in prices as “price gouging” and there is often condemnation of these price increases. The press release from Florida calls such price increases “immoral”...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT