Let's say you are playing the stock market and below period 2020 data was provided. For "stock A" you use a 2 month moving average. For "stock B" you use exponential smoothing with (a = 0.3). What is the Forecast in Stock B for January 2021? Stock A Stock B ... Jan 0.11 Jan 14 Feb 0.20 Feb 11 Mar 0.03 Mar 1.20 Apr May Apr 6 0.50 May Jun 0.03 Jun 12 Jul 0.10 Jul 16 Aug 0.11 Aug Sep Oct 14 Sep 0.56 Oct 0.78 Nov 0.44 Nov 4 Dec 0.10 Dec 4

Find the seasonal variations by the method of 'ratio to trend' for the followin data of sales of a company : II III IV I Year/Qtrs. 2011 80 72 68 60 68 104 100 88 2012 80 116 108 96 2013 108 152 136 124 2014 160 184 172 164 2015

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

Based on above assume you are using the moving average forecasting method based on the last four observations. When making the forecast for the last period, theoldest of the four observations was 1945 and the forecast was 2083. Thetrue value for the last period then turned out to be 1977. Calculate yourforecast for the next period.

The following table gives the millions of metric tons of carbon dioxide emissions in a certain country for selected years from 2010 and projected to 2032. Year CO2 Emissions 2010 2012 2014 2016 2018 2020 338.5 361.5 396.1 422.8 452.1 497.4 Year 2022 2024 2026 2028 2030 2032 CO2 Emissions 559.2 591.9 628.7 664.1 708.1 743.7 (a) Create a linear function that models these data, with x as the number of years past 2010 and y as the millions of metric tons of carbon dioxide emissions. (Round all numerical values to two decimal places.)

The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts for the period indicated and error calculations. 155, 145, 155, 162, 180, 165, 172, 149, 170, 172 Exponential smoothing.  Use an alpha level of .8   What is the forecast for week 10? What is the Mean Absolute Error (MAE)?

The following table shows actual sales and forecasts for the past 4 periods. Calculate the mean absolute percentage error and the tracking signal. Round your answers  to two decimal places. Show your calculations Period Dt Ft et |et| |et|Dt 1 280 326 46 46 0.16 2 220 356 136 136 0.62 3 210 292 82 82 0.39 4 361 341 -20 20 0.06

Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. You are required to; Using linear trend equation forecast the sales of face masks for October 2020.   Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: July 0.2, August 0.3 and September 0.5.   Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,00

A researcher calculates a regression equation to predict an insurance premium based on a person's age. One person in the sample was observed to have a premium of $500 at 20 years old, but the predicted value was $400. VWhat is the value of the residual for this person? Next Page Page 10 of 14

An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is F = 124 + 2.1t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.) Units Sold 11 144 12 146 13 152 142 15 152 16 149 17 152 18 154 19 157 20 164 Click here for the Excel Data File: MAD (Naive) MAD (Linear) MSE (Naive) MSE (Linear) 4 56 N 00 o o