4. The following data gives the number of battery sales by one of the leading automobile company over the period of last six months. Actual Battery Sales Month January February March April Мay June 20 21 15 14 13 16 a. Forecast the sales for the month of July using a 3-week moving average method. b. Forecast the sales for the month of July using a 3-week weighted moving average, with weights of 5, 3 and 2. Using 5 for the most recent month. c. Compute the forecast for the month of July using exponential smoothing with a = 0.5. (Assume the forecast for January was 22 batteries) d. Compute the errors of the of the forecast based on calculation in c.

4. The following data gives the number of battery sales by one of the leading automobile company over the period of last six months. Actual Battery Sales Month January February March April Мay June 20 21 15 14 13 16 a. Forecast the sales for the month of July using a 3-week moving average method. b. Forecast the sales for the month of July using a 3-week weighted moving average, with weights of 5, 3 and 2. Using 5 for the most recent month. c. Compute the forecast for the month of July using exponential smoothing with a = 0.5. (Assume the forecast for January was 22 batteries) d. Compute the errors of the of the forecast based on calculation in c.

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: Use the scatterplot of Vehicle Registrations below to answer the questions Vehicle Registrations in…

A: Given plot is number of vehicle Registration in millions Vs Year and there a black color straight…

Q: The following ACF plots were produced for raw data of monthly sales of two different variables, A…

Q: During the past ten weeks, sales of cases of Comfort brand headache medicine have been as follows:…

A: The moving average is a type of forecast technique. Which is used to forecast the values of upcoming…

Q: If the correlation coefficient between number of years of experience of an employee and the monthly…

A: The correlation coefficient between number of years of experience of an employee and the monthly…

Q: The following data are the last three years of quarterly sales ($ thousands) for AmeriWeld. They are…

A: Given that -

Q: Create a 2-D line chart of Cash Sales for months 1-18. Add a trend line with a forward forecast of 3…

A: Given Information: Consider the given data: Months Cash Sales 1 2145600 2 2175200 3 2255200…

Q: 1) Raj collected the following data on the quarterly room occupancy (in hundreds) for a resort hotel…

A: Given the data of quarterly room occupancy for a resort hotel in Lowa as Year quarter Occupancy…

Q: The data that follow show this information for the leading liquid sports drinks. (a) What is…

A: Since you have posted a question with multiple subparts, we have answered first 3 subparts only as…

Q: For n = 188 students, the correlation between y = fastest speed ever driven and x = number randomly…

A: The objective of the question is to interpret the correlation coefficient (r) between two variables,…

Q: The three-period moving average for the third quarter of 2012 (rounded off to two decimals) is:…

A: The sales for first quarter in 2012 is 110, second quarter is 131, and third quarter is 133.

Q: Below are given the annual production (in '000 Rs.) of a fertiliser factory : 1998 100 1997 Year :…

Q: 1. Give below is the data on production of a company (in lakhs). Year: 1983 1984 1985 1986 1987 1988…

Q: Consider the following demand levels for electricity (in Megawatts) for Rundu from 1988 to 1991.…

A: Given is a timeseries data for demand levels for electricity (in Megawatts) for Rundu from 1988 to…

Q: The scatter plot shows the sizes and annual rents of some office spaces in the downtown area of a…

A: The scatterplot for the sizes and annual rents of some office spaces in the downtown area of a city…

Q: 1. Perform a Trend and Seasonal analysis with the following data. Include the trend formula and the…

A: The provided data table:A trend and seasonal analysis must be performed the forecast sales for the…

Q: Find the trend line equation and obtain the trend values for the followin data using the method of…

Q: 51. Below are given the annual production figures (in thousand tonnes) of a fertiliser factory: Year…

Q: Represent the following data by means of a histogram. Weekly Wages ( 00 ) : 10-15 15-20 20-25 25-30…

A: Let weekly wages on Y axis and number of workers on X axis.

Q: justration 8.1. Represent the following data by line charts: TABLE 8.2. PROGRESS OF ELECTRICITY…

Q: The materials handling manager of a manufacturing company is trying to forecast the cost of…

A: Given data is Age Yearly Maintenance 5.5 1319 5.5 1749 5.5 1733 5.0 1195 5.0 1423…

Q: Please use trend regression to foreca

A: Given information, Week Passenger kilomers 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8…

Q: For each of the following data sets, construct a scatter plot, draw a line of best fit, use two…

A: Given, the following datasets in the form of a table : We need to construct a scatter…

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: mex PLC has gathered following information on the sales of face mask from April 2020 to eptember…

A: Let months following April be denoted by 1, 2, 3 and so on. And

Q: Calculate trend values by the method of least square from the data given below and estimate the…

Q: The following data are the number of U.S. motorcycle thefts for 1992 through 1995. Given these data…

A: The metrics are calculated by using R-language: R-code:

Q: You are given the following quarterly sales information for ASTRA Company over the last 3 years.…

A: 1. Centered moving average To compute the central moving average, take the average to two…

Question

11:-0 I
O MAD
4. The following data gives the
number of battery sales by
one of the leading
automobile company over
the period of last six months.
Month
Actual Battery
Sales
January
February
March
April
May
June
20
21
15
14
13
16
a. Forecast the sales for the
month of July using a
3-week moving average
method.
b. Forecast the sales for the
month of July using a
3-week weighted moving
average, with weights of
5, 3 and 2. Using 5 for
the most recent month.
c. Compute the forecast for
the month of July using
exponential smoothing
with a = 0.5. (Assume the
forecast for January was
22 batteries)
d. Compute the errors of
the of the forecast based
on calculation in c.

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

Step 2

Step 3

Step 4

Step 5

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Time Series Analyses, Forecasting Methods, and Indices$

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

Consider the following image of the data. Is the linear trend line a reasonable fit to the data points? Is it linear? +H R²=0.9467 No. The dashed line is well outside many of the error bars. No. The R^2 value is less than 1. Yes. The R^2 value is approximately 1. Yes. The data points have error bars and the line goes through them.
The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data was collected: Age (years) 5.5 where Y = Yearly maintenance cost in dollars and X = Age in years. 5.5 5.5 5.0 5.0 5.0 6.0 6.0 6.5 Yearly Maintenance Cost (S) 1,319 1,749 1,733 1,195 1,423 1,381 1,590 2,222 1,687 Age (years) 5.0 1.5 1.5 Y = 7.0 7.0 2.0 2.0 2.0 Yearly Maintenance Cost ($) 1,894 863 882 a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter your responses rounded to three decimal places and include a minus sign if necessary.) 1,464 2,073 1,678 1,166 1,249
What are the advantages of multiplicative model .
The correlation coefficient between the yearly returns of two mutual funds is 0.20. What does that mean about the strength and direction of the linear relationship between the returns of the two funds?
Provide an appropriate graph for the given data
Monday Tuesday Wednesday Thursday Friday Week 1 55 40 33 20 70 Week 2 60 48 50 36 63 Week 3 58 44 38 50 72 Week 4 80 40 40 30 64 Instructions: The table above, which shows income (in thousands of dollars) from sales of a particular product over a four week period. Determine the seasonal variation each of the week Hence calculate the average seasonal variation for each day of the week Plot the graph of the original data and then add the trend line obtained using the moving averages Comment briefly on the trend observed on the graph and calculate the sales figure that is likely to be achieved for the next Monday using the trend line
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
Provide an appropriate chart for the following data
A small detergent company in Karachi is confident that their sales are growing significantly week by week. Treating sales for the previous eight weeks as a typical example of this increasing trend, they recorded them in PKR 1000's and examined the results. Week 1 2 3 4 5 6 Sales (in PKR) 2.59 2.55 2.63 2.68 2.74 2.83 2.86 2.99 a) Plot a scatter diagram between week and sales. b) Find the equation of regression line. c) Find the expected sales for 12 week d) Find the correlation coefficient between the two variables.
distinguish between the unit of analysis and the aggregates?
Q. 4.