The average daily sales (in litres) of milk at a country store are shown in Table 4 for each of the years 1983 to 1985. Table 4 Year Quarter Average daily sales (Y) 47.6 48.9 1983 3 51.5 4 55.3 57.9 1984 2 61.7 3 65.3 4 70.2 76.1 1985 2 84.7 93.2 4 97.2 (a) Find the four- year moving averages. (b) Calculate the seasonal index by making use of the ratio-to-moving average method. Exercise: 1.9.1 2.

The average daily sales (in litres) of milk at a country store are shown in Table 4 for each of the years 1983 to 1985. Table 4 Year Quarter Average daily sales (Y) 47.6 48.9 1983 3 51.5 4 55.3 57.9 1984 2 61.7 3 65.3 4 70.2 76.1 1985 2 84.7 93.2 4 97.2 (a) Find the four- year moving averages. (b) Calculate the seasonal index by making use of the ratio-to-moving average method. Exercise: 1.9.1 2.

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

The following data show the quarterly sales of a major auto manufacturer for the years 1 through 3. Use multiplicative method to answer the following questions. Year Quarter Sales 160 2 180 3 190 4 170 1 200 2 210 3 260 4 230 3 1 210 2 240 290 260 3 4 26. The equation for the trend line of yearly sales is F, = 567 + 150t. What is the prediction for the sales in year 4? 1200 с. 27. What is the seasonal index for quarter 4 in year 1? a. 1.0 28. What is the average seasonal index for quarter 1? 1.0 29. What is the sales forecast for quarter 1 in Year 4? a. 250 30. What is the sales forecast for quarter 3 in Year 4? a. 340 с. 2.
The following is the data of the production of corona vaccine (Pfizer) for last few months. Using the moving average of 5 months determine the trend of production of corona vaccine. Month February March April Мay June July Production (units) 400 600 500 600 700 600 O a. 560 and 600 O b. 450 and 550 O C. 500 and 600 O d. 500 and 560
The histogram below shows the distribution of annual growth rate in travel spending for 52 companies in the United States. Frequency 20+ 15 10 5 2 0+ 2 0 6 3 11 19 4 1 Annual Growth Rate (%) After creating this graph, it was discovered that the values for the companies with the 20 largest reported annual growth rates were miscalculated. In fact, each of these top 20 companies should have a higher value of annual growth rate than was previously reported. Which of the following statements must be true? (A) If you were to make a graph with the corrected values, the graph would be skewed to the left. (B) If you were to make a graph with the corrected values, the graph would be symmetric. (C) If you were to calculate the median with the corrected values, the new median would be greater than the old median. (D) If you were to calculate the interquartile range (IQR) with the corrected values, the new IQR would be the same as the old IQR. (E) If you were to find the value of the third quartile…
Please help with the corrected answers in details: The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 What type of pattern exists in the data? The data appear to follow a trend pattern. The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern.The data appear to follow a seasonal pattern. (b) Use ? = 0.2 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (c) Use a smoothing constant of ? = 0.4 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135…
The quarterly earnings of a large soft drink company have been recorded for the period 2014 - 2017. These data (in millions of rupees) are shown in the accompanying table. Year Quarter Sales Centered moving average 2014 1 52 2 67 3 85 62.03 4 54 63.38 2015 1 57 66.63 2 75 65.16 3 90 67.99 4 61 70.94 2016 1 60 70.55 2 77 73.61 3 94 71.57 4 63 72.84 2017 1 66 73.68 2 82 76.02 3 98 4 67 Find the seasonal index values using the moving averages. The trend line with de-seasonalised series was found as: Y = 62.09 + 1.14t where t is the quarter number ( t=1 for the first quarter 2014). Find the forecasted sales for the four quarters of year 2017.
Technicians use moving-average lines to detect changes in trends by observing the interaction between the price of an asset and its moving average over a specific period. Consider a stock whose price data over the past 10 days are as follows: Day 1 2 3 4 5 6 7 8 9 10 Stock Price ($) 54.50 54.25 55.75 56.50 57.25 56.00 54.75 53.25 52.50 53.00 5-Day Simple Moving Average ($) Trend Assume a simple moving average (SMA) is calculated over a 5-day period. Calculate the SMA for each day, and based on the SMA, identify any potential changes in the trend during the 10-day period.
eat out or in The overall change in the consumer price index is a weighted average of changes in various categories. on november 19, 2011 the boston globe reported the data displayed in figure 5.7. the overall change in the cpi is a weighted average of the change for food and the change for everything else. do you have enough information to find the weights?
Using the index on housing starts in the United States per year from 2006 to 2017 given in the table below, forecast the index for 2018 using a three-year and a five year moving average. Year Actual Sales 2006 116 2007 122 2008 121 2009 121 2010 111 2011 97 2012 113 2013 125 2014 146 2015 142 2016 156 2017 162 2018
Help me fast so that I will give Upvote.
Q. 4.
The following time series shows the sales of supermarket chain over the last six months. Month Sales ($ 000) August 2021 250 Sep 2021 280 Oct 2021 295 Nov 2021 320 Dec 2021 380 Jan 2022 360 Develop a linear trend equation that can be used to forecast sales in Feb 2022. Forecast the sales in Feb 2021 using a three-period weighted moving average designed with the following weights: Nov 2021 weight 0.6, Dec 2021 weight 0.3 and Jan 2022 weight 0.1. Which method (A or B) is the best? Explain why.
Mlustration 12. From the following data compute the 3-yearly and 5-yearly moving averages and: Year : 1 3 4 7 8 9. 10 11 Values : 25 30 34 37 39 40 40 39 37 34 30