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

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

orchestra answered 1 year ago

Next > < Previous

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”...

Subjects