Modern Business Statistics with Microsoft Excel (MindTap Course List)
5th Edition
ISBN: 9781285433301
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 17.4, Problem 26E
Giovanni Food Products produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very aggressive marketing strategy they have been able to increase their annual revenue by approximately $10 million over the past 10 years. But increased competition has slowed their growth rate in the past few years. The annual revenue, in millions of dollars, for the previous 10 years is shown.
- a. Construct a time series plot. Comment on the appropriateness of a linear trend.
- b. Develop a
quadratic trend equation that can be used to forecast revenue. - c. Using the trend equation developed in part (b), forecast revenue in year 11.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The median home value in Michigan and New York (adjusted for inflation) are shown below.
Year
Michigan
New York
1950
45400
61500
2000
115600
148700
If we assume that the house values are changing linearly,a) In which state have home values increased at a higher rate? New York, Mich., or equal rates: b) If these trends were to continue, what would be the median home value in Michigan in 2010?$ :c) If we assume the linear trend existed before 1950 and continues after 2000, the two states' median house values will be (or were) equal in what year? (The answer might be absurd)The year :
Use quantitativeforecast methods for the data shown below
Period
Observation
1
24
2
34
3
36
4
37
5
41
6
44
7
45
Plot the original time series and comment on appropriateness of a linear trend.
The median home value in Mississippi and Maryland (adjusted for inflation) are shown below:
If we assume that the house values are changing linearly,a) In which state have home values increased at a higher rate? b) If these trends were to continue, what would be the median home value in Mississippi in 2010?$
Chapter 17 Solutions
Modern Business Statistics with Microsoft Excel (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. With a smoothing constant of α = .2, equation...
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in $...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Prob. 25ECh. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series.
Construct a...Ch. 17.5 - Consider the following time series...Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35.
Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies, Inc., supplies milk to several...Ch. 17 - Prob. 44SECh. 17 - The Garden Avenue Seven sells CDs of its musical...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales
The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
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
- After its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…arrow_forwardThe following table presents monthly interest rates, in percent, for 30 year and- 15 year fixed-rate mortgages, for a recent year. 30 Year 15 year 30 year 15 year 3.92 3.20 3.55 2.85 3.89 3.16 3.60 2.86 3.95 3.20 3.47 2.78 3.91 3.14 3.38 2.69 3.80 3.03 3.35 2.66 3.68 2.95 3.35 2.66 a. Construct a scatter plot of the 15- year rate (y) versus the 30-year rate (x). b. Compute the correlation coefficient between 30-year and 15-year rates.arrow_forwardAccording to a high-profile realtor, houses in the sleepy town of Sun Beach have shown higher appreciation over the past three years than have houses in the bustling town of North Arden. To test the realtor's claim, an economist has found eight recently sold homes in Sun Beach and eight recently sold homes in North Arden that were owned for exactly three years. The following table gives the appreciation (expressed as a percentage increase) for each of the sixteen houses. Appreciation rates in percent Sun Beach 10.2, 9.7, 12, 10.4, 7.9, 10.9, 9.6, 13.3 North Arden 7.5, 12.8, 5.9, 8.5, 8.1, 9.3, 6.3, 13.4 Assume that the two populations of appreciation rates are normally distributed and that the population variances are equal. Can we conclude, at the 0.05 level of significance, that houses in Sun Beach have higher appreciation over the past three years than houses in North Arden? Perform a one-tailed test. The null hypothesis: H0:…arrow_forward
- Find out the next month after april income by using the forecasting method of the moving average methodarrow_forwardthe table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.arrow_forwardA rental car company purchased a new Toyota Camry for $35,000. The company determined this asset should be depreciated for six years using the straight-line depreciation method. At the end of six years, the car will be worth $30,500. Estimate the value of the car at Year 4. Question 4 options: $33,500 $32,000 $32,750 $11,667 $31,2arrow_forward
- Which of the following time series forecasting methods would not be used to forecast seasonal data?arrow_forwardThe Beaver Creek Pottery Company sells bowls and mugs, hand-made by Native American artisans, at a craft store and through a Web site. Making these items requires a special type of clay and a large amount of individual person-hours, so for planning purposes, the company would like to forecast future demand, specifically through its Web site, which has increasingly become the primary source of sales. Following is the company’s Web site demand (in items sold) for the past 36 months: Develop a linear trend forecast model, an exponentially smoothed model (a = 0.20), and a 5-month moving average forecast model and indicate which one you think should be used to forecast Web site demand.arrow_forwardWhen data consist of percentages, ratios, compounded growth rates, or other rates of change, the geometric mean is a useful measure of central tendency. For n data values, the geometric mean, assuming all data values are positive, is as follows. To find the average growth factor over 5 years of an investment in a mutual fund with growth rates of 8.7% the first year, 11.5% the second year, 15.2% the third year, 3% the fourth year, and 7.1% the fifth year, take the geometric mean of 1.087, 1.115, 1.152, 1.03, and 1.071. Find the average growth factor of this investment. (Round your answer to four decimal places.)arrow_forward
- Mac Corp. is considering a project that has the following cash flow data. What is the project’s internal rate of return (IRR)? Year 0 1 2 3 Cash flow -$1,000 $425 $425 $425arrow_forwardThe Fast Track Ski Shoppe sells ski goggles during the four months of the ski season.Average demand follows: a. Calculate the deseasonalized sales and the seasonal index for each of the fourmonths.b. If next year’s demand is forecast at 1200 pairs of goggles, what will be the forecast sales for each month?arrow_forwardDuring periods when the unadjusted federal minimum wage is constant identify the trend .arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License