Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 3, Problem 20P
The following table shows monthly revenue for six different web development companies.
- a. Use Excel to create sparklines for sales at each company.
- b. Which companies have generally decreasing revenues over the six months? Which company has exhibited the most consistent growth over the six months? Which companies have revenues that are both increasing and decreasing over the six months?
- c. Use Excel to create a heat map for the revenue of the six companies. Do you find the heat map or the sparklines to be better at communicating the trend of revenues over the six months for each company? Why?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The qualified applicant pool for eight management trainee positions consists of ten women and six men. How many different groups of applicants can be selected for the positions
You want to make a salad from whatever vegetable you have in the fridge. You have seven different tomatoes. There are 2 red tomatoes, 4 yellow tomatoes, and one black tomato in the fridge. You have three different bell peppers. There is 1 red pepper, 1 yellow pepper, and 1 green pepper. What is the probability of randomly choosing a vegetable and getting a red tomato, and a green pepper? Round your answer to four decimal places.
uppose automobile insurance companies gave annual premiums for top-rated companies in several states. The figure below shows box plots for the annual premium for urban customers in three states.
Which state offers the lowest premium? Which state offers the highest premium?
Chapter 3 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 3 - A sales manager is trying to determine appropriate...Ch. 3 - The following table shows an example of gross...Ch. 3 - The following table provides monthly revenue...Ch. 3 - In the file MajorSalary, data have been collected...Ch. 3 - Entrepreneur magazine ranks franchises. Among the...Ch. 3 - The file MutualFunds contains a data set with...Ch. 3 - The file TaxData contains information from federal...Ch. 3 - The file FDICBankFailures contains data on...Ch. 3 - The following 20 observations are for two...Ch. 3 - The file Fortune500 contains data for profits and...
Ch. 3 - The International Organization of Motor Vehicle...Ch. 3 - Prob. 12PCh. 3 - Prob. 13PCh. 3 - The total number of term life insurance contracts...Ch. 3 - An automotive company is considering the...Ch. 3 - Consider the following survey results regarding...Ch. 3 - The Northwest regional manager of Logan Outdoor...Ch. 3 - The Ajax Company uses a portfolio approach to...Ch. 3 - Heat maps can be very useful for identifying...Ch. 3 - The following table shows monthly revenue for six...Ch. 3 - Prob. 21PCh. 3 - Aurora Radiological Services is a health care...Ch. 3 - The motion picture industry is an extremely...
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
- Wing Foot is a shoe franchise commonly found in shopping centers across the United States. Wing Foot knows that its stores will not show a profit unless they gross over $940,000 per year. Let A be the event that a new Wing Foot store grosses over $940,000 its first year. Let B be the event that a store grosses over $940,000 its second year. Wing Foot has an administrative policy of closing a new store if it does not show a profit in either of the first two years. Assume that the accounting office at Wing Foot provided the following information: 58% of all Wing Foot stores show a profit the first year; 72% of all Wing Foot store show a profit the second year (this includes stores that did not show a profit the first year); however, 86% of Wing Foot stores that showed a profit the first year also showed a profit the second year. Compute P(B|Ac). Round your answer to the nearest hundredth.arrow_forwardYou draw two cards from a standard deck of 52 cards, but before you draw the second card, you put the first one back and reshuffle the deck. If you get a3on the first card, find the probability of drawing a 3 for the second card.arrow_forwardDo bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the coefficient of variation for each fund. Round your answers to the nearest tenth. x: 14 0 37 21 35 23 24 -14 -14 -17 y: 8 -2 29 17 22 17 17 -2 -3 -8arrow_forward
- What percentage of the general U.S. population have bachelor's degrees? Suppose that the Statistical Abstract of the United States, 120th Edition, gives the following percentage of bachelor’s degrees by state. For convenience, the data are sorted in increasing order. 17 18 18 18 19 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 24 24 24 24 24 25 25 25 25 26 26 26 26 26 26 27 27 27 28 28 28 29 29 31 31 32 32 34 35 38 Illinois has a bachelor's degree percentage rate of about 18%. Into what quartile does this rate fall?arrow_forwardWhat percentage of the general U.S. population have bachelor's degrees? Suppose that the Statistical Abstract of the United States, 120th Edition, gives the following percentage of bachelor’s degrees by state. For convenience, the data are sorted in increasing order. 17 18 18 18 19 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 24 24 24 24 24 25 25 25 25 26 26 26 26 26 26 27 27 27 28 28 28 29 29 31 31 32 32 34 35 38 Illinois has a bachelor's degree percentage rate of about 18%. Into what quartile does this rate fall?arrow_forwardFind the range for the following sample data. x 23 17 11 30 27arrow_forward
- Do bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the sample mean for x and for y. Round your answer to the nearest tenth. x: 11 0 36 22 34 24 25 -11 -11 -22 y: 9 -3 28 14 23 16 14 -3 -4 -9arrow_forwardDo bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the range for variable y. X 12 0 36 21 35 23 24 -12 -12 -21 Y 10 -2 26 15 22 18 15 -2 -3 -10arrow_forwardDo bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the range for variable y. X 12 0 36 21 35 23 24 -12 -12 -21 Y 10 -2 26 15 22 18 15 -2 -3 -10arrow_forward
- Do bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the range for variable x. X 15 0 37 23 33 25 26 -15 -15 -23 Y 6 -1 28 18 24 17 18 -1 -2 -6arrow_forward7.16. If the probability density of X is given by g kx³ for x>0 f(x) = (1+2x)6 0 10-01, elsewhere trolls inf ( 2X density of the random variable Y = where k is an appropriate constant, find the probability 1+2X distribution of Y, and thus determine the value of k. 7 Identify thearrow_forward7.1. If X has an exponential distribution with the parameter 0, use the distribution function technique to find the probability density of the random variable Y = ln X. bilaga in dwreatarrow_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
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY