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
As the leader of the sales team, you would like to increase the revenue brought by your team. You discovered a program for sales personnel that supposedly improve interpersonal skills and thus help settle deals with customers more often. You decide to send8 of your sales people for the training, and compare the amount they brought in sales in the month before they went and in the month after they received the training. The data are:
Xbefore: 400, 300, 1200, 2100, 700, 450, 650, 3400
Xafter: 1000, 400, 1000, 2500, 1200, 600, 800, 3000
A. Identify the appropriate statistical measure to use.
B. Conduct the test. Make a decision about the null hypothesis, interpret your results and calculate effect size if applicable. At ?=.05, can you report to upper management that the training worked? Or was it a waste of money?
C. Calculate 95% confidence intervals for the estimate of the difference.
Please answer number 3 from a-c. Neglect the number 2 questions. Thanks.
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 ($)
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
- If you graph a revenue and cost function, explain how to determine in what regions there is profit.arrow_forwardIf you are performing a break-even analysis for a business and their cost and revenue equations are dependent, explain what this means for the company's profit margins.arrow_forwardDoes Table 2 represent a linear function? If so, finda linear equation that models the data.arrow_forward
- Wetlands offer a diversity of benefits. They provide a habitat for wildlife, spawning grounds for U.S. commercial fish, and renewable timber resources. In the last 200 years, the United States has lost more than half its wetlands. Environmental Almanac gives the percentage of wetlands lost in each state in the last 200 years. For the 30 of the lower 48 states, the percentage loss of wetlands per state is as follows. Make a stem-and-leaf display of these data. (Use the tens digit as the stem and the ones digit as the leaf. Enter NONE in any unused answer blanks.)arrow_forwardIntergarated products Need to estimate its pc sales for the nextnext year. the most recent six years of revenue data for the companys line of xt personal computers and those of the industry, is found in the table below; Year XT PC Sales (000,000) All Industry PC Sales Revenue 1 2.4 4.6 2 5.9 8.6 3 15.5 10.7 4 27.8 14.8 5 35.9 18.5 6 38.1 19.4 a) Assuming that the sales data above are representative of sales expected next year , use time series regression analysis to forecast next years sales b) determine the correlation correlation for he ime forecast and interpret is meaning c) find the coefficient of determination for the time series forecast and intpret it s meaning d) perform a regression analysis between the annual sales revenues of XT Personal computers and all personal computers if the estimate of next years industry PC sales revenues is $21.9 billion? e) which independent variable should intergrated products coporation IPC choose for its forcasting of sales…arrow_forwardWhat percentage of data would you predict would be between 25 and 50 and what percentage would you predict would be more than 50 miles? Use the Week 4 spreadsheet again to find the percentage of the data set we expect to have values between 25 and 50 as well as for more than 50. Now determine the percentage of data points in the dataset that fall within each of these ranges, using same strategy as above for counting data points in the data set. How do each of these compare with your prediction and why is there a difference? Predicted percentage between 25 and 50: ________________________ Actual percentage: Predicted percentage more than 50 miles: Actual percentage: ___________________________________________ Comparison ____________________________________________________ Why? __________________________________________________________ Drive: 44 20 88 6 71 42 76 63 61 63 84 28 55 33 88 80 86 83 5 85 25 25 54 54 81 73 29 76 78…arrow_forward
- Data: 3.5, 3.2, 3.1, 3.5, 3.6, 3.2, 3.4, 2.9, 4.1, 2.6, 3.3, 3.5, 3.9, 3.8, 3.7, 3.4, 3.6, 3.5, 3.5, 3.7, 3.6, 3.8, 3.2, 3.4, 4.2, 3.6, 3.1, 2.9, 2.5, 3.5, 3.1, 3.2, 3.7, 3.8, 3.4, 3.6, 3.5, 3.2, 3.6, 3.8 Sketch a histogram with ranges of 0.1, from minimum (2.5) to maximum (4.2) values. Then sketch a histogram with ranges of 0.3. You can include the relative frequency scales on the same sketches.arrow_forwardSouthwest Airlines had 81.1 million domestic boardings in a recent year, followed by Delta Airlines with 79.4 million, American Airlines with 72.6 million, United Airlines with 56.3 million, Northwest Airlines with 43.3 million, US Airways with 37.8 million, and Continental Airlines with 31.5 million, according to T-100 Domestic Market. Construct a pie chart to depict this information. List down the variable of the above data. Describe whether each variable are qualitative or quantitative data? Explain your answer. Describe the level of measurement for the variables. Explain your answer.arrow_forwardThe bar graph below shows the percentage of people having different views on college education. In 2000, 24% of adults viewed a college education as essential for success. For the period 2000 through 2010, the percentage viewing a college education as essential for success increased on average by approximately 2.5 each year. If this trend continues, by which year will 64% of all adults view a college education as essential for success? 64% of adults will view a college education as essential for success by the year Changing Attitudes Towards College 60- A college 50 educato is available for qualified students. is essential for SUccess. 으 404 30- 10-24% 49% 35% 31% 0- 2000 2010 2000 2010 Help Me Solve This Textbook Get More Help - Clear All Skill Builder Check Answer 9:55 PM 73°F 9/13/2021 P Type here to search backspace 24 4. 7. 6. E R K pause Percentagearrow_forward
- Total revenue for a soda in January 2011 was $4,342,262, and total revenue in January 2013 was $4,429,964. See the data below. The soda company is requesting your help as manager to understand how price increases are affecting the quantity of sodas sold. Create a table with the descriptive statistics of the number of sodas sold in the two years, as well as an explanation of the descriptive statistics: What are some of the key aspects of the descriptive statistics that help you tell a story about the 2 years in sodas sold. Run a regression where you explain how price changes are affecting the quantity of sodas sold. Include an explanation of the coefficients as well as an explanation of the t-statistics, the intercept, the R-Squared, and the F-Statistic. Explain managerial recommendations to the soda company on how can you increase the revenue.arrow_forwardThe Toyota Camry is one of the best-selling cars in North America. The cost of a previously owned Camry depends on many factors, including the model year, mileage, and condition. To investigate the relationship between the car's mileage and the sales price for Camrys, the following data show the mileage and sale price for 19 sales (PriceHub web site, February 24, 2012). DATA file Miles (1,000s) Price ($1,000s) 22 16.2 29 16.0 36 13.8 47 11.5 63 12.5 77 12.9 73 11.2 87 13.0 92 11.8 101 10.8 110 8.3 28 12.5 59 11.1 68 15.0 68 12.2 91 13.0 42 15.6 65 12.7 110 8.3arrow_forwardSuppose a basketball player has made 70% of their foul shots this season. Use a simulation to estimate the average number of points they will score from foul shots (you earn one point per made foul shot). Run 20 trials. Describe how you will run your simulation. Be specific Fill in the table Trials Components Points 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 4.State your conclusionarrow_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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
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