For the following data, verify that the 5 year weighted moving average with weights 1, 2, 2, 2, 1 respectively is equivalent to 4 year centred moving average: Year 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 Sales (K) 5 3 7 6 4 8 9 10 8 9 9

For the following data, verify that the 5 year weighted moving average with weights 1, 2, 2, 2, 1 respectively is equivalent to 4 year centred moving average: Year 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 Sales (K) 5 3 7 6 4 8 9 10 8 9 9

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

Related questions

Q: Consider the following data: Monthly Profit of a Gym: Month & Profit: Jan-12: 5800 Feb-12: 5553…

A: Given the data on the monthly profit of a Gym. The table below shows the required calculation-

Q: Three yearly moving averages for the given data are

A: Since the period of moving averages is m = 3, then we take the average of three observations at a…

Q: Populate the table American Net Barrel Oil ($) Year Income ($ ху y (x) million) (y) 2005 56 -850…

A: ( Please note that ∑x2=28015 ) The data for American's net income and price of oil is listed…

Q: Example 2: Construct a 4-yearly centered moving average from the following dat. 1992 Year 1991 1993…

Q: A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are…

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

Q: Calculate co-efficient of concurrent deviation from the data given below: No. of employees : 250 300…

Q: The following table represents the trend eliminated values computed by us multiplicative model. Find…

Q: Calculate 5-yearly weighted moving averages for the following data, using the weights 1.1, 3, 2, 1,…

A: IN THE ABOVE GIVEN PROBLEM WE HAVE TO CALCULATE THE 5 YEAR WEIGHTED MOVING AVERAGES

Q: Calculate 5-yearly weighted moving averages for the following data, using the weights 1.1, 3, 2, 1.…

A: introduction From the give problem we have to Calculate 5-yearly weighted moving averages for the…

Q: Y 68 70 68 63 69 63 57 68 64 61 69 82 77 79 80 65 65 64 74 76 80 69 72 67 58 66 59 70 73 57 64 63 67…

A: Five figure summary is nothing but it is a rough look of dataset which includes, lowest value,…

Q: 4. The following data gives the number of battery sales by one of the leading automobile company…

A: Moving Average: It is the statistics that is used to analyze data points by calculating the averages…

Q: using below, forecast sales for the fifth week using a 3-week weighte average. (round to nearest…

A: We are asked to find the forecast sale

Q: An analyst must decide between two different forecasting techniques for weekly sales of roller…

A: The data shows the weekly sales of roller blades.

Q: 1.1. Draw a scatter diagram for the data above. 1.2. Calculate the correlation of coefficient (r).…

A: We are provided with a data and we have to determine: 1.1 Draw a scatter diagram for the data above.…

Q: * For the following table: () Fit a straight line trend by the method of least squares. (ii)…

Q: Here are data on the monthly price of apples for a certain year. a) Find a 2-point moving average of…

A: The given time series data of the price for the corresponding month is as…

Q: Example 18.12 Fit a straight line trend by the method of least square to the following data : Year…

A: Given, Production( in tonnes) for 6 years from 1991 to 1996

Q: Calculate the correlation coefficient for the outputs and average cost data. What can you conclude?…

A: The software procedure to calculate the correlation coefficient using EXCEL software. Go to Data…

Q: Considering the actual demand values below for LCD TVs sold by a retailer per month, what is the…

A: The following information has been provided: Month Demand 1 42 2 40 3 43 4 40 5 41…

Q: From the following data relating to average prices of a commodity find ( Link relatives (ii) Price…

Q: The following data contain the quantity (millions pounds) of U.S. domestic fish caught annually over…

A: forecasting

Q: Calculate the coefficient of correlation using the method of concurrent deviation between supply and…

Q: Try to fit any two moving averages models to the following data and discuss its performance. YEAR…

A: Moving average: It is a technique to get an overall idea of the trends in a data set; it is an…

Q: A company has the following monthly sales for the past year. Plot the data points on a line graph…

A: Given data,

Q: Fit a straight line trend by the method of least squares to the following data and calculate trend…

Q: Calculate the coefficient of concurrent deviations for the following data

A: Let X denote the Supply and Y denote the Demand. We have to calculate the coefficient of concurrent…

Q: Monday Tuesday Wednesday Thursday Friday Week 1 55 40 33 20 70 Week 2 60 48 50 36 63…

A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…

Q: 1.Use the least square method to develop a linear trend equation for the data from illustration 1.…

Q: method to answer the following questions. Year Quarter Sales 1 160 180 3 190 4 170 2 200 210 3 260 4…

Q: Month February March April May June July Production (units) 400 600 500 600 700 600 O a. 560 and 600…

A: The following is the data provided: Period Data February 400 March 600 April 500 May 600…

Question

(b)
For the following data, verify that the 5 year weighted moving average with weights 1, 2,
2, 2, 1 respectively is equivalent to 4 year centred moving average:
Year 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004
Sales (K) 5 3 7 6 4 8 9 10 8 9 9

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

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.
Given the following data, calculate the three-month moving average forecasts formonths 4, 5, 6, and 7
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.
a. Compute a three-period moving average for these stock prices (in R, order = 3). What are the first two moving average values? (Round your answer to two decimal points) First: $ Second: $
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
Compute 3-yearly moving averages of the following data assuming the length Of business cycle as 3 year period and plot the trend va year Annual sales in $ '000 1990 40 1991 42 1590 46 1993 44 1994 49 1995 46 1996 42 1997 44 1998 50