Course Hero Logo
SE, Ex 56SE, Ex 58
This textbook is available atAmazon.com Logo
Modern Business Statistics with Microsoft Excel 5th Edition

Modern Business Statistics with Microsoft Excel (5th Edition)

Book Edition5th Edition
Author(s)Anderson, Sweeney
ISBN9781285433301
PublisherCengage Learning
SubjectBusiness
Section 2.1: Summarizing Data for a Categorical Variable
Exercises
Section 2.2: Summarizing Data for a Quantitative Variable
Exercises
Section 2.3: Summarizing Data for Two Variables Using Tables
Exercises
Section 2.4: Summarizing Data for Two Variables Using Graphical Displays
Exercises
End of Chapter
Supplementary Exercises
Chapter 2, End of Chapter, Supplementary Exercises, Exercise 57
Page 102

Google has changed its strategy with regard to how much it invests in advertising, and which media it uses to do so. The following table shows Google's marketing budget in millions of dollars for 2008 and 2011 ( The Wall Street Journal, March 27, 2012). 

 20082011
Internet26.0123.3
Newspaper, etc.4.020.7
Television0.069.3


a. Construct a side-by-side bar chart with year as the variable on the horizontal axis. Comment on any trend in the display.
 

Google has changed its strategy with regard to how much it invests in advertising, and which media it uses to do so. The following table shows Google's marketing budget in millions of dollars for 2008 and 2011 ( The Wall Street Journal, March 27, 2012). 

 20082011
Internet26.0123.3
Newspaper, etc.4.020.7
Television0.069.3


b. Convert the above table to percentage allocation for each year. Construct a stacked bar chart with year as the variable on the horizontal axis.
 

Google has changed its strategy with regard to how much it invests in advertising, and which media it uses to do so. The following table shows Google's marketing budget in millions of dollars for 2008 and 2011 ( The Wall Street Journal, March 27, 2012). 

 20082011
Internet26.0123.3
Newspaper, etc.4.020.7
Television0.069.3


c. Is the display in part (a) or part (b) more insightful? Explain.
 

cdhtutor profile picture

Solution by subject matter expert

cdhtutor

Explanation

m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lec

Answer

m risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacini
We have step-by-step solutions for your textbook!
View a sample solution from this chapter
Page 102

Related Exercises

Advertisers contract with Internet service providers and search engines to place ads on...
Modern Business Statistics with Microsoft Excel
Google has changed its strategy with regard to how much and over which media it invests...
Statistics for Business & Economics, Revised
Internet Advertising. Advertisers contract with Internet service providers and search...
Statistics for Business & Economics, Revised
The Pew Internet & American Life project conducted a survey that included several...
Statistics for Business & Economics
Methods Consider the following data on two categorical variables. The first variable, x ,...
Essentials of Modern Business Statistics with Microsoft Office Excel
What are some objects of involvement for consumers?
Consumer Behavior
An Internet pharmacy advertises that it will deliver the over-the-counter products that...
Statistics for Management and Economics + XLSTAT Bind-in
Consider the following data on two categorical variables. The first variable, x , can...
Modern Business Statistics with Microsoft Excel