Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
6th Edition
ISBN: 9781337589383
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 57SE
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).
- a. Construct a side-by-side bar chart with year as the variable on the horizontal axis. Comment on any trend in the display.
- 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.
- c. Is the display in part (a) or part (b) more insightful? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Google has changed its strategy with regard to how much and over which media it invests in advertising. The following table shows Google's marketing budget in millions of dollars for 2008 and 2011 (The Wall Street Journal, March 27, 2012).
2008
2011
Internet
$26.0
$123.3
Newspaper, etc.
$4.0
$20.7
Television
$0.0
$69.3
Convert the above table to percentage allocation for each year. Round your answers to one decimal place, if necessary. If your answer is zero, enter "0"
2008 2011
Internet ( ) % ( )%
Newspaper ( ) % ( )%
Television ( ) % ( )%
Total ( )% ( )%
In 2011 home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011).Click on the datafile logo to reference the data.
Enter negative values as negative numbers.
a. Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) = + Rent ($)
Complete the following:
Draw a scatter plot of the data below.
b. Draw a trend line. Write its equation
Estimate the number of Youtube subscribers in 2030.
5.
a.
C.
Year
2005
2010
2015
2020
Subscribers in Millions
17.7
39.9
54.9
63.0
Chapter 2 Solutions
Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
Ch. 2.1 - Methods
1. The response to a question has three...Ch. 2.1 - 2. A partial relative frequency distribution is...Ch. 2.1 - A questionnaire provides 58 Yes, 42 No, and 20...Ch. 2.1 -
For the 2010–2011 viewing season, the top five...Ch. 2.1 -
In alphabetical order, the six most common last...Ch. 2.1 - Top Rated Television Show Networks. Nielsen Media...Ch. 2.1 - Airline Customer Satisfaction Survey. Many...Ch. 2.1 - Prob. 8ECh. 2.1 - Prob. 9ECh. 2.1 -
VirtualTourist provides ratings for hotels...
Ch. 2.2 - 11. Consider the following data.
Develop a...Ch. 2.2 - 12. Consider the following frequency...Ch. 2.2 - Construct a histogram for the data in exercise...Ch. 2.2 - Prob. 14ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Applications
17. A doctor’s office staff studied...Ch. 2.2 - NBA Total Player Ratings. CBSSports.com developed...Ch. 2.2 - Prob. 19ECh. 2.2 - CEO Time in Meetings. The London School of...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Top U.S. Franchises. Entrepreneur magazine ranks...Ch. 2.2 - Prob. 24ECh. 2.2 - Best Paying College Degrees. Each year America.EDU...Ch. 2.2 - Prob. 26ECh. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - Daytona 500 Automobile Makes Average Speeds. The...Ch. 2.3 - Daytona 500 Average Speeds of Winners. The...Ch. 2.3 - 31. Recently, management at Oak Tree Golf Course...Ch. 2.3 - Household Income Levels. The following...Ch. 2.3 - 33. Each year Forbes ranks the world’s most...Ch. 2.3 - Prob. 34ECh. 2.3 -
The U.S. Department of Energy's Fuel Economy...Ch. 2.4 - The following 20 observations are for two...Ch. 2.4 - Prob. 37ECh. 2.4 - The following crosstabulation summarizes the data...Ch. 2.4 - Driving Speed and Fuel Efficiency. A study on...Ch. 2.4 - The DATAfile Snow contains average annual snowfall...Ch. 2.4 - Hypertension and Heart Disease. People often wait...Ch. 2.4 -
Smartphones are mobile phones with Internet,...Ch. 2.4 - Store Managers Time Study. The Northwest regional...Ch. 2 - SAT Scores. The SAT is a standardized test used by...Ch. 2 - Median Household Incomes. The file MedianHousehold...Ch. 2 - State Populations. Data showing the population by...Ch. 2 - Startup Company Funds. According to the Wall...Ch. 2 - Complaints Reported to BBB. Consumer complaints...Ch. 2 - Stock Price Volatility. The term “beta” refers to...Ch. 2 - Education Level and Household Income. The U.S....Ch. 2 - Prob. 51SECh. 2 - Best Places to Work. Fortune magazine publishes an...Ch. 2 - Prob. 53SECh. 2 - Prob. 54SECh. 2 - Prob. 55SECh. 2 - Prob. 56SECh. 2 -
Google has changed its strategy with regard to...Ch. 2 -
A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 -
Motion Picture Industry
The motion picture...Ch. 2 - Cincinnati, Ohio, also known as the Queen City,...Ch. 2 - Jon Weideman, first shift foreman for Cut-Rate...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Assume figures were presented for the past 5 years on merchandise sold at Chicago department and discount stores ($ million). Sales in 2018 were $3,214; in 2017, $3,474; in 2016, $3,148;, in 2015, $3,212; and in 2014, $3,276. Using 2014 as the base year, complete a trend analysis. (Round your answers to the nearest whole percent.) 2018 2017 2016 2015 2014 $ 3,474 % $ 3,214 $ 3,148 $ 3,212 3,276 Sales Sales (in percent) % % % %arrow_forwardThe market share distribution among manufacturers for 2011 automobile sales in the U.S. would best be portrayed in which of the following? runs plot line graph pie chart gantt chartarrow_forwardDuPont Automotive releases a Color Popularity Report which provides the percentages of car colors in North America. The most recent report is shown in the following table.arrow_forward
- Calculate (y)' 22y + 23° 11y 89°arrow_forwardMake frequency tables for the following data sets. Include columns for relative and cumulative frequency. Also, make a bar graph for the frequency. A website that reviews recent movies lists 5 five-star films (the highest rating), 15 four-star films, 15 three-star films, 10 two-star films, and 5 one-star films.arrow_forwardAssume this is a partial list of financial highlights from a Best Buy annual report: 2018 2017 (dollars in millions) $ 35,475 1,313 Net sales $ 40,580 Earnings before taxes Net earnings 2, 291 1,378 921 Complete a horizontal and vertical analysis from the above information. (Enter your answers in millions. Round the "percent" answers to the nearest hundredth percent.) Horizontal analysis Vertical analysis 2018 2017 Increase Percent 2018 2017 Net sales $ 40,580 $ 35,475 $ 5,105 % Earnings before taxes 2,291 1,313 978 % % Net earnings 1,378 921 457 % %arrow_forward
- Please show steps in Excel. The 32 teams in the National Football League (NFL) are worth, on average, $1.17 billion, 5% more than last year. The datafile NFLTEAMVALUE shows the annual revenue ($millions) and the estimated team value ($ millions) for the 32 NFL teams (Forbes website, February 28, 2014). a.Develop a scatter diagram with Revenue on the horizontal axis and Value on the vertical axis. Does there appear that there is any relationship between the two variables? b. What is the sample correlation coefficient? What can you say about the strength of the relationship between Revenue and Value? Team Revenue ($ millions) Current Value ($ millions) Arizona Cardinals 253 961 Atlanta Falcons 252 933 Baltimore Ravens 292 1,227 Buffalo Bills 256 870 Carolina Panthers 271 1,057 Chicago Bears 298 1,252 Cincinnati Bengals 250 924 Cleveland Browns 264 1,005 Dallas Cowboys 539 2,300 Denver Broncos 283 1,161 Detroit Lions 248 900 Green Bay Packers 282 1,183 Houston…arrow_forwardThe table that follows shows the weekend gross ticket sales for the top20 movies for the weekend of June 25, 2010: Please see the attachment for details: a. Draw a stem and leaf plot for the data. Describe the shape of the distribution. Are there any outliers?b. Construct a dotplot for the data. Which of the two graphs is more informative? Explain.arrow_forwardName 1.8- Percentiles and cumulative relative frequency Exit Ticket 1. According to a 2019 article at Insider.com, the state of Pennsylvania was at the 82nd percentile for Pre-K to 12th grade education and was at the 0th percentile for higher education. Explain what these values mean. 2. The graph displays the cumulative relative frequency of the cost of in-state public college education for each of the 50 states. a b. Cumulative relative frequency (%) 120 100 80 60 40 20 0 0 2000 4000 6000 8000 10000 12000 14000 In-State Public College Tuition (S) AP Stats 16000 Estimate Q₁, Q₁, and the IQR of the distribution of phone in-state public tuition. About what percent of states have in-state public college tuition less than or equal to $8000? More than $8000?arrow_forward
- Make a stem-and-leaf plot for the following stock prices:25 64 32 99 74 27 66 72 83 54 59 67 72 66 54 52 33 75 43 39arrow_forwardthe following table provides the average price of regular grade gasoline for 4 years. Use 2015 as the reference value, complete the table by calculating the price index for each year. Show all your calculationarrow_forwardFit a straight line trend by the method of least.square from the following data. Ak. calculate the trend values. Estimate the sales for 2012. Year 2005 2006 2007 2008 2009 2010 Sales(in 000) 12 13 14 15 22 26arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY