Student Solutions Manual for Basic Business Statistics
13th Edition
ISBN: 9780321926708
Author: David M. Levine; Mark L. Berenson; Timothy C. Krehbiel; Kathryn A. Szabat; David F. Stephan
Publisher: Pearson Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 16, Problem 15PS
The file ComputerSales contains the U.S. total computer and software sales
a. Plot the data.
b. Compute a linear trend forecasting equation and plot the trend line.
c. Compute a quadratic trend forecasting equation and plot the results.
d. Compute an exponential trend forecasting equation and plot the results.
e. Which model is the most appropriate?
f. Using the most appropriate model, forecast U.S. total computer and software sales, in millions, for 2013.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
1. Estimate the retails sales in the U. S. in 2011. billions of dollars =
2. Use the model to predict the year that corresponds to retails sales of $249 billion =
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
What do the Forecast for each year add up to?
Chapter 16 Solutions
Student Solutions Manual for Basic Business Statistics
Ch. 16 - If you are using exponential smoothing for...Ch. 16 - Consider a nine-year moving average used to smooth...Ch. 16 - Prob. 3PSCh. 16 - Prob. 4PSCh. 16 - Prob. 5PSCh. 16 - How have stocks performed in the past? The...Ch. 16 - Prob. 7PSCh. 16 - Prob. 8PSCh. 16 - Prob. 9PSCh. 16 - Prob. 10PS
Ch. 16 - The linear trend forecasting equation for an...Ch. 16 - Prob. 12PSCh. 16 - Prob. 13PSCh. 16 - Prob. 14PSCh. 16 - The file ComputerSales contains the U.S. total...Ch. 16 - Prob. 16PSCh. 16 - The file CarProduction contains the number of...Ch. 16 - The average salary of Major League Baseball player...Ch. 16 - Prob. 19PSCh. 16 - Prob. 20PSCh. 16 - Prob. 21PSCh. 16 - Prob. 22PSCh. 16 - You are given an annual time series with 40...Ch. 16 - Prob. 24PSCh. 16 - Prob. 25PSCh. 16 - Prob. 26PSCh. 16 - Using the data for Problem 16.15 on page 646 that...Ch. 16 - Prob. 28PSCh. 16 - Prob. 29PSCh. 16 - Using the average baseball salary from 2000...Ch. 16 - Prob. 31PSCh. 16 - The following residuals are from a linear trend...Ch. 16 - Prob. 33PSCh. 16 - Prob. 34PSCh. 16 - Prob. 35PSCh. 16 - Prob. 36PSCh. 16 - Prob. 37PSCh. 16 - Using the average baseball salary from 2000...Ch. 16 - Prob. 39PSCh. 16 - Prob. 40PSCh. 16 - In forecasting daily time-series data, how many...Ch. 16 - Prob. 42PSCh. 16 - Prob. 43PSCh. 16 - The data in Toys R Us are quarterly revenues...Ch. 16 - Prob. 45PSCh. 16 - Prob. 46PSCh. 16 - Prob. 47PSCh. 16 - The file Silver-Q contains the price in London for...Ch. 16 - Prob. 49PSCh. 16 - What is a time series?Ch. 16 - What are the different components of a time-series...Ch. 16 - What is the difference between moving average and...Ch. 16 - Prob. 53PSCh. 16 - How does the least-squares linear trend...Ch. 16 - How does autoregressive modelling differ from the...Ch. 16 - What are the different approaches to choosing an...Ch. 16 - What is the major difference between using SYX and...Ch. 16 - How does forecasting for monthly or quarterly data...Ch. 16 - Prob. 60PSCh. 16 - Prob. 61PSCh. 16 - The data in the following table, stored in...Ch. 16 - Teachers' Retirement System of the City of New...Ch. 16 - Prob. 64PS
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
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardUse a graphing calculator to make a scatter plot of the amounts Leah willaccumulate for years 1 through 5.arrow_forward1. Make a scatter plot of the table provided in the image. B. Write a linear/exponential equation that models this table provided in the image. C. Explain what the slope/multiplier means in the context of the problem. E. Use your model to predict when there will be 100 new casesarrow_forward
- Answer the following questions regarding the population of Hamilton County in 2016. a. If you predict the population of Hamilton County in 2016, should you use the average growth rate of 2000-2009 or the average growth rate of 2009-2015? Explain your choice in a complete sentence. b. Predict the population of Hamilton Country in 2016. Show your work. Express your answer in “thousand people” rounded to the nearest whole number.arrow_forwardThe Pennsylvania State University had enrollments of 40,571 students in 2000 and 41,289 students in 2004 at its main campus in University Park, Pennsylvania. Assuming the enrollment growth is linear, predict the enrollments in 2008 and 2010.arrow_forwardPlease 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_forward
- John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)arrow_forwardThe CIA World Factbook† estimates the economic performance of countries. One such figure is the gross domestic product (GDP), which is the annual market value of the goods and services produced in that country.In 2015, the GDP of the United States was about 18.0 trillion dollars. It is predicted to grow by about 2.0% each year. What is the projected value of the GDP in 2050 (to the nearest trillion dollars)?arrow_forwardThe percentage of automobile consumers who are under 50 years of age decreased approximately linearly from 55.955.9​% in 19701970 to 52.652.6​% in 19801980.  a. Predict when the percentage will be 4848​%. b. Predict the percentage in 19851985. a. The percentage will be 4848​% around the yeararrow_forward
- 2.5 2.0 15 1.0 0.5 Incarcerated Americans 1920-2014 Prison Jail 0 1920 1930 1940 1950 1960 1970 1980 1990 2000 2010 Year Juvenile Detention 6. Describe the trend depicted in this ch 7. What impact do you think this trend has had on the public defender system? depicarrow_forwardPlot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component. Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021. On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.arrow_forwardc. Predict sales in 15 years.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY