Question 1 0/20 Video Submit Advertising Age annually compiles a list of the 100 companies that spend the most on advert

Post by **answerhappygod** » Sun Oct 03, 2021 11:06 am

: Question 1 0 20 Video Submit Advertising Age Annually Compiles A List Of The 100 Companies That Spend The Most On Advert 1 (196.71 KiB) Viewed 47 times

: Question 1 0 20 Video Submit Advertising Age Annually Compiles A List Of The 100 Companies That Spend The Most On Advert 2 (184.17 KiB) Viewed 47 times

: Question 1 0 20 Video Submit Advertising Age Annually Compiles A List Of The 100 Companies That Spend The Most On Advert 3 (207.88 KiB) Viewed 47 times

Question 1 0/20 Video Submit Advertising Age annually compiles a list of the 100 companies that spend the most on advertising. Consumer-goods company Procter Gamble has often topped the list, spending billions of dollars annually. The data on annual advertising expenditures for a sample of 20 companies in the automotive sector and 20 companies in the department store sector are contained in the Excel Online file below. Con a spreadsheet to answer the following questions. X Open spreadsheet 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 decima place, if necessary Automotive Department Store Range $ $ Back

WOIK Chapter Pal DCxcel Question 1 0120 a. What is the mean advertising spent for each sector? Round your answers to 2 decimal places, it necessary. Submit 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 $ 5 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 v on average, has a v standard deviation, and range than Department Store. Back Nex

e Home Insert Draw Page Layout Formulas Data uveview B.A.- 60 00 Arial 19、 10 Σ 47 KAMI Number 1 0 н D E Automotive Department Store Formula B Department Store 447 471 478 572 582 Parta Mean (to 2 decimals) #N/A #N/A Part b Standard Deviation (to 2 decimals) #N/A #N/A 596 598 621 634 Partc Maximum #N/A #N/A А Automotive 574 1506 1570 1639 1716 1726 1783 1797 1806 2007 2014 2031 2051 2163 2205 2238 2380 2526 2543 2901 674 Minimum #N/A #N/A Range (to 1 decimal) #N/A #N/A Part d First Quartile (to 2 decimals) 702 721 748 767 785 821 841 851 948 1006 #N/A #N/A Third Quartile (to 2 decimals) #N/A #N/A Interquartile Range (to 2 decimals) #N/A #N/A = Data + ulation Mode: Automatic Workbook Statistics Gine Feedback to Microsoft Type here to search