Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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
Part c: What percentage of an adult size brain does a child have at age 10?
Part d: Determine whether the value from the model is larger or smaller than the value in the table.
Cryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021.
It includes the following variables:
Date
Day – Day of the year, used to assess trend over time
Volume (US $) – Daily trading volume
Opening Price (US $) – Opening price for daily trading
Price Change (US $) – Daily change in price from opening to close
1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)
No need to answer everything! Just plot the actual visitors and the forecasts. Compare the accuracy of the forecasts in the 1985 to 1990 period with those subsequent to that period.
Chapter 17 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (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 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 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 - Annual retail store revenue for Apple from 2007 to...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
- Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forwardIn sports, we expect top athletes to get better over time. We expect future athletes to run faster, jump higher, throw farther. One thing has remained constant, however, the percent of free throws made by basketball players has stayed almost exactly the same for 50 years (Branch, 2009). For college basketball players, the percent is about 69%, while for players in the NBA (National Basketball Association) it is about 75%. (The percent in each group is also very similar between male and female basketball players.) In each case below, find the mean and standard deviation of the distribution of sample proportions of free throws made if we take random samples of the given size. a. Samples of 100 free throw shots in college basketball. b. Samples of 1000 free throw shots in college basketball. c. Samples of 100 free throw shots in NBA basketball. d. Samples of 1000 free throw shots in NBA basketball. e. What effect does increasing sample size have on the standard deviation of the…arrow_forwardcanton Supplies, inc., is a service firm that employs approximately 100 individuals.Managers of canton Supplies are concerned about meeting monthly cash obligations andwant to develop a forecast of monthly cash requirements. Because of a recent changein operating policy, only the past seven months of data that follow are considered to berelevant.Month 1 2 3 4 5 6 7Cash Required ($1000s) 205 212 218 224 230 240 246a. construct a time series plot. What type of pattern exists in the data?b. Using Minitab or excel, develop a linear trend equation to forecast cash requirementsfor each of the next two months.arrow_forward
- The university wants to know if Annual Income and Lifetime Savings are linearly related. Investigate and state your answer with evidence. Does your answer seem logical or not? Write your thoughts on this.arrow_forwardII.arrow_forwardWorld Military Expenditure The following chart shows total military and arms trade expenditure from 1992-2010 (t = t $ (billion) 1200 1150 2 4 = = World military expenditure 1050 1050 1100 6 f(t) -4t² - 56t 1,300 - 1200 f(t) f(t) = 4t² - 56t+ 1,300 4t² 56t 1,300 1350 (a) If you want to model the expenditure figures with a function of the form f(t) = at² + bt + c, would you expect the coefficient a to be positive or negative? Why? HINT [See "Features of a Parabola" in this section.] We would expect the coefficient to be negative because the curve is concave down. We would expect the coefficient to be positive because the curve is concave down. We would expect the coefficient to be positive because the curve is concave up. We would expect the coefficient to be negative because the curve is concave up. 1450 8 10 12 14 16 18 20 Year since 1990 (b) Which of the following models best approximates the data given? (Try to answer this without actually computing values.) f(t) = −4t² - 56t+ 1,300…arrow_forward
- Suppose that you are a researcher and wish to construct a linear mathematical (statistical) model that relates the number of years and the corresponding exports (million U.S,$) of a country. The constructed model may use to forecasts the future values. You have obtained the relevant data for a decade during 1990 to 1999 and you have listed the data in Table 5. Table 5. Shows the list of the amount that have earned on exports 6| 7| 8 Year No. 1| 2 | 3 | 4 10 Exports 4954 6131 | 6904| 6813 6803 8137| 8707 8320 8628 7779 (a) Construct a suitable graph that explains the relationship between the number of years and the corresponding exports. By inspection of the graph comment on the relationships between the number of vears and the corresponding exports. (b) Construct a mathematical (Statistical) model by using least square method between number of years and the corresponding sales. Also interpret the slope of the linear model to support your comment. (c) Forecast the value of sales by…arrow_forward11-8. The linear trend of sales of a company is Rs. 6,50,000 in 1995 and it rises by Rs. 16,500 per year. pected sales in 1998. in 19999998.arrow_forwardThe accompanying table gives the stock market indices for a certain company on the stock market. Use simple linear regression to forecast the data. What would be the forecasts for the next three days? Click the icon to view the stock market indices for the company on the stock market. Select the graph that shows the correct trendline forecast for the given data. O Click here to view the graph d. O Click here to view the graph b. • Click here to view the graph a. O Click here to view the graph c What would be the forecast for the next three days? (Round to two decimal places as needed.) Index Date 10/2/2010 10/3/2010 10/4/2010 B F G A H Date Index 9/3/2010 10448.19 9/7/2010 10340.44 9/8/2010 10386.08 9/9/2010 10414.94 9/10/2010 10461.14 9/13/2010 10545.98 9/14/2010 10527.68 9/15/2010 10574.14 0 9/16/2010 10596.74 1 9/17/2010 10606.46 2 9/20/2010 10752.05 3 9/21/2010 10759.95 4 9/22/2010 10738.52 5 9/23/2010 10661.03 16 9/24/2010 10859.59 17 9/27/2010 10810.12 18 9/28/2010 10856.59 19…arrow_forward
- An electronic appliance manufacturer wants to know if there is a relationship between percentage change in deposable personal income which is reported quarterly by the government, and the percentage change in appliances sold by the manufacturer following same years of quarterly data. Brenda Chee and Clarence Paulus lead an analyst team has obtained data for the past 10 quarters. (Hint: Provides your answers in two decimal points) Quarter Percent change in income Percent Change in appliance sold Quarter Percent change in income Percent change in appliance sold 1 -2.3 -2.5 6 -1.0 1.0 2 -1.5 -1.0 7 0.7 1.4 3 2.8 7.4 8 5.2 3.4 4 0.5 2.6 9 -2.5 -0.5 5 4.6 8.5 10 1.7 1.8 (a) What forecasting model should be used for this data. Why?(5(b) Develop the forecasting model that you have proposed in (a).(c) Compute the relationship for these data. In your opinion, is the relationship between independentvariable…arrow_forwardA bank records the number of mortgage applications and its own prevailing interest rate (at the first of the month) for each of 16 consecutive months. Find the best-fitting line for the interest rate (x) and the number of applications (y).arrow_forward4. The US real unemployment rates over a 12-year period are listed. Use a time series chart to display the data. Describe any patterns. Year 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Rate 9.3% 8.4% 8.4% 9.2% 14.2% 16.7% 16.2% 15.2% 14.5% 12.7% 11.3% 9.9%arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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