Automotive Department Store 572 448 1512 466 1578 476 1650 564 1716 590 1720 594 1787 598 1798 622 1818 633 2011 665 2016 704 2025 723 2061 742 2173 760 2214 779 2242 824 2354 845 2524 851 2540 951 2897 1008 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. Construct a spreadsheet to answer the following questions. ☑ Open spreadsheet a. What is the mean advertising spent for each sector? Round your answers to 2 decimal places, if necessary. Mean $ Automotive Department Store $ b. What is the standard deviation for each sector? Round your answers to 2 decimal places. Standard deviation $ Automotive Department Store $ c. What is the range of advertising spent for each sector? Round your answers to 1 decimal place, if necessary. Automotive Department Store Range $

Q: what is the definition of image

A: An image (from Latin: imago) is an artifact that depicts visual perception, such as a photograph or…

Q: A. Two golfing venues offer bays that customers con reserve to play various golf ing games. The…

A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…

Q: REWRITE

A: given that , increasing rate of area of a square be = 48  cm2/ secthen we have to find change rate…

Q: Don't use chat gpt It

A:

Q: What is y? O A. 42 O B. 85 C. 88 D. 95

A:

Q: What is y?

A: Given that for a triangle the two interior angles are 82° and 54° arenon-adjacent to an exterior…

Q: I am confused on this

A: The solution is shown in step-2

Q: What is the right answer? I have to show work.

A: The probability PAB is the conditional probability of happening of event A provided event B already…

Q: I can't complete

A: Since you have posted multiple sub-parts of question , we will solve first three  sub-parts for you.…

Q: Can you write it properly? It is not understandable.

A:

Q: Please use literature and provide the pros and cons

A: The "Bp test" is not a standard statistical test or acronym commonly used in statistical analysis.…

Q: Can you please do psychology major?

A: Topic: Relationship between hours of sleep and stress levels in college students

Q: Describe how to differentiate implicitly.  Give an example along with your explanation.

A: Implicit differentiation is a special case where we use well known chain rules to find the…

Q: Need to show workings

A: Apologies for the inconvenience.   ∫abfxdx is given by the shaded region below: This region is…

Q: can you provide a counter example

A:

Q: How many True Positives, True Negatives, False Positives, and False Negatives are in this model ?…

A: True Positive :  When the model predicts positive value as positive i.e., it correctly predicts the…

Q: Evaluate -up-

A:

Q: Show how to do part 3 please!

A: It is a linear regression problem with a best fit line. The main of that method is there are some…

Q: Don't use chat gpt It

A: Given Matrix: A=⎣⎢⎢⎢⎡​−1000​0−100​0082​00−24​⎦⎥⎥⎥⎤​ Steps:Find the characteristic polynomial.Compute…

Q: how do I post the second part?

A: Solution