Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357191484
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2.3, Problem 33E
Each year Forbes ranks the world’s most valuable brands. A portion of the data for 82 of the brands in the 2013 Forbes list is shown in Table 2.12 (Forbes website, February, 2014). The data set includes the following variables:
Brand: The name of the brand.
Industry: The type of industry associated with the brand, labeled Automotive & Luxury, Consumer Packaged Goods, Financial Services, Other, Technology.
Brand Value ($ billions): A measure of the brand’s value in billions of dollars developed by Forbes based on a variety of financial information about the brand. 1-Yr Value Change (%): The percentage change in the value of the brand over the previous year.
Brand Revenue ($ billions): The total revenue in billions of dollars for the brand.
- a. Prepare a crosstabulation of the data on Industry (rows) and Brand Value ($ billions). Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for Brand Value ($ billions).
- b. Prepare a frequency distribution for the data on Industry.
- c. Prepare a frequency distribution for the data on Brand Value ($ billions).
Table 2.12 DATA FOR 82 OF THE MOST VALUABLE BRANDS
- d. How has the crosstabulation helped in preparing the frequency distributions in parts (b) and (c)?
- e. What conclusions can you draw about the type of industry and the brand value?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
a small pond contains eight catfish and six bluegill. If seven fish are caught at random, what is the probability that exactly five catfish have been caught?
23 The line graph in the following figure shows
Revenue ($ millions)
one company's revenues over time. Explain
why this graph is misleading and what you
can do to fix the problem.
700
60-
50-
40
30
Line Graph of Revenue
20-
101
1950
1970
1975 1980 1985
Year
1990
2000
d of the
20
respectively.
Interpret the shape, center and spread of the
following box plot.
14
13
12
11
10
6
T
89
7
9
5.
治
Chapter 2 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition 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
- F Make a box plot from the five-number summary: 100, 105, 120, 135, 140. harrow_forward14 Is the standard deviation affected by skewed data? If so, how? foldarrow_forwardFrequency 15 Suppose that your friend believes his gambling partner plays with a loaded die (not fair). He shows you a graph of the outcomes of the games played with this die (see the following figure). Based on this graph, do you agree with this person? Why or why not? 65 Single Die Outcomes: Graph 1 60 55 50 45 40 1 2 3 4 Outcome 55 6arrow_forward
- lie y H 16 The first month's telephone bills for new customers of a certain phone company are shown in the following figure. The histogram showing the bills is misleading, however. Explain why, and suggest a solution. Frequency 140 120 100 80 60 40 20 0 0 20 40 60 80 Telephone Bill ($) 100 120arrow_forward25 ptical rule applies because t Does the empirical rule apply to the data set shown in the following figure? Explain. 2 6 5 Frequency 3 сл 2 1 0 2 4 6 8 00arrow_forward24 Line graphs typically connect the dots that represent the data values over time. If the time increments between the dots are large, explain why the line graph can be somewhat misleading.arrow_forward
- 17 Make a box plot from the five-number summary: 3, 4, 7, 16, 17. 992) waarrow_forward12 10 - 8 6 4 29 0 Interpret the shape, center and spread of the following box plot. brill smo slob.nl bagharrow_forwardSuppose that a driver's test has a mean score of 7 (out of 10 points) and standard deviation 0.5. a. Explain why you can reasonably assume that the data set of the test scores is mound-shaped. b. For the drivers taking this particular test, where should 68 percent of them score? c. Where should 95 percent of them score? d. Where should 99.7 percent of them score? Sarrow_forward
- 13 Can the mean of a data set be higher than most of the values in the set? If so, how? Can the median of a set be higher than most of the values? If so, how? srit to estaarrow_forwardA random variable X takes values 0 and 1 with probabilities q and p, respectively, with q+p=1. find the moment generating function of X and show that all the moments about the origin equal p. (Note- Please include as much detailed solution/steps in the solution to understand, Thank you!)arrow_forward1 (Expected Shortfall) Suppose the price of an asset Pt follows a normal random walk, i.e., Pt = Po+r₁ + ... + rt with r₁, r2,... being IID N(μ, o²). Po+r1+. ⚫ Suppose the VaR of rt is VaRq(rt) at level q, find the VaR of the price in T days, i.e., VaRq(Pt – Pt–T). - • If ESq(rt) = A, find ES₁(Pt – Pt–T).arrow_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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY