A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR1 = 0.9, SR2 = 0.95, SR3 = 1.05,and SR4 = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows:%3DPeriod, t:245789.Demand:151720232529343639Click here for the Excel Data FileCompute the MAD and tracking signal for each period. (Negative values should be indicated by a minus sign. Round yourintermediate calculations and final answers to 3 decimal places.)Period, tDemandMADTracking signal115217320423525297343639

Given information: The data represents the values of demand for the periods 1 to 9.

Answered: A manager uses a trend equation plus…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Suppose you ran a quadratic trend forecasting model on some time series data for 18 months. The Excel Data Analysis regression output provided the following: Intercept: 45.140 Slope 1: -1.940 Slope 2: 0.195 What is the forecast value for time period 21? 4.4 90.395 43.395 8.495
Use the border crossings data below and a = = 0.3 and ẞ = 0.2. Truck Crossings Month February 113,691 March 139,204 April 121,498 May 127,511 June 131,500 July 105,245 August 126,606 Copy Data Step 2 of 2: Calculate the adjusted exponential smoothing forecast for September 2011. Assume the forecast component for February 2011 to be the actual truck crossing value minus the initial trend. Let the initial trend be 10,000 trucks. Round your answer to two decimal places.
For the data set, perform exponential smoothing with alpha = 0.1 to determine the forecast for week 20. week Sales (1000s of gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 13 31 14 34 15 31 16 33 17 28 18 32 19 30
Suppose trips/wk=3.1 –0.15(dist) is a linear model that predicts the number of supermarket trips a family makes per week when they live a certain distance (in miles) from a supermarket. It was established by sampling people who live within 10 miles of a supermarket. Which of the following is the correct interpretation of the slope? a. For each additional trip that the family makes, they live 0.15 miles away from the store b. For each additional mile away from the store the family lives, they make 0.15 more visits per week c. For each additional mile away from the store the family lives, they make 0.15 fewer visits per week d. For each additional trip they make to the store, they live an additional 3.1 miles away. e. For each additional mile away they live, they make 3.1 more trips to the stor.
The population of a town was recorded every twenty years from 1900 to 2000. The results are shown in the line graph. Assuming that the trend in the population growth continues, which of the following is most likely to be the population of the town in the year 2020?
This shows log GDP per capita for the UK. Which of the following statements are correct? Select one or more: a. The graph shows that in 1950 UK GDP per capita was about £8.75. b. The trend growth rate over the period was 0.9889% per annum. c. When actual output is below trend output the economy is in recession. d. The trend growth rate over the period was 2.14 % per annum.
Use the gas prices data set below to calculate a 3-month Weighted Moving Average (WMA) forecast for the average gas prices and predict the average retail gasoline price for February 2015. Use the weights of 0.6, 0.3, and 0.1 for the 3-month WMA, where the first weight is used for the most recent month and the last weight is used for the least recent month. Round your answer to two decimal places, if necessary. Month-Year Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Average Gas Price $3.766 $3.688 $3.565 $3.484 $3.255 $2.997 $2.632 $2.208 Copy Data
Below is data collected over 6 specific years. The data collected is the Consumer Price Index (CPI) and the cost of a slice of tuna. We would like to build a model using the CPI to predict the cost of a slice of pizza in a given year. Year 1960 1973 1986 1995 2002 2003 CPI (x) 30.2 48.3 112.3 162.2 191.9 197.8 Cost of a slice of tuna(y) 0.15 0.35 1.00 1.25 1.75 2.00 Plot the data. Are we justified in creating a Linear Regression model to predict the price of a pizza slice using the CPI? Why or why not? Calculate the descriptive statistics. Calculate the sums of squares Calculate the slope, intercept, and correlation. What is this correlation value telling us? Assemble the prediction equation, and interpret the slope within the context of the problem. State the hypotheses for the hypothesis test for regression.
Fill in the blanks in the following table. Round your answers to 2 decimal places.
Anita Limited has shared their annual sales revenue over the last 6 financial years from 2015 to 2020. Year Sales ($ 000) 2015 4500 2016 5100 2017 4900 2018 5400 2019 5670 2020 6000 You are required to; a) Using linear trend equation forecast the sales revenue of Anita Limited for 2021. Note: See the formula sheet on the next page. P.S.: I can't attach the formula sheet in this because it has variuos symbols, such as Sigma, log, x value etc. I uploaded the formula sheet and the question as well in the chat box. Please let me know if you need any more information.
the 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.
Using the regression to model annual income, a variable for years of education has a slope = 2000. This means that the model predicts each additional year of education will yield an extra 2,000 for the average person's salary, regardless of how many total years of education a person has. A. True B. False

SEE MORE QUESTIONS

Recommended textbooks for you

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

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

SEE MORE TEXTBOOKS

A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR, = 0.9, SR2 = 0.95, SR3 = 1.05, and SR, = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows: