ABC Corporation has sales figures as given below. Forecast sales for 2021 using the following techniques: (a) the trend line method. Mention the equation and the R square value obtained. (b) Three year moving average method. (c) Exponential Smoothening Method with a smoothening constant of 0.8.

ABC Corporation has sales figures as given below. Forecast sales for 2021 using the following techniques: (a) the trend line method. Mention the equation and the R square value obtained. (b) Three year moving average method. (c) Exponential Smoothening Method with a smoothening constant of 0.8.

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: fllustration 12.14. Trend equation for yearly sales (in 1000 Rs) for a commodity with year 1971 as…

Q: Plot 5 points of the function y 0.5 3 on the axes provided using the highlight tool, then connect…

Q: Researchers studied the relationship between glucose concentration, oxygen level, and ATP production…

A: In the question, data is provided. The question's purpose is to construct an appropriately labeled…

Q: An article in the journal Air and Waste (Update on Ozone Trends in California's South Coast Air…

A: The data…

Q: a. Plot the data. b. Use exponential regression to construct an expo- nential model for the income…

Q: Use this data and build a model to forecast annual maintenance expenses based on the weekly

A: Here annual maintenance expenses is dependent variable Y and weekly usage is independent variable X.…

Q: Assume that the current date is February 1, 2021. The linear regression model was applied to a…

A: Coefficient Estimate t Intercept 4.3 2.07 Slope 1.6 2.98

Q: Earthquakes: The scatterplot below was produced to investigate whether, for the period of…

A: Given : The scatterplot was produced to investigate whether, for the period of observation, the data…

Q: Use this data and develop a model of a truck's annual maintenance expenses based on its weekly usage…

Q: 3. One classic application of correlation involves the association between the temperature and the…

A: Given data, X Y X*Y X*X 882 69.7 61475.4 777924 1188 93.3 110840.4 1411344 1104 84.3…

Q: A coffee shop owner wants to estimate demand for the next four quarters for hot chocolate. Sales…

A: The forecasting trend equation is: Ft=187+9.2t.The quarter relatives are Q1=1.06, Q2=1.03, Q3=0.61,…

Q: Use this data and build a model to forecast annual maintenance expenses based on the weekly usage in…

A: Given the data to calculate the SSE.

Q: Using excel. For the Hawkins Company, the monthly percentages of all shipments received on time over…

A: Given: For the Hawkins Company, the monthly percentages of all shipments received on time over the…

Q: Water is being poured into a large cone shape cistern. The volume of water measured and centimeters…

A: Here, we have given that the summary of a regression analysis which consists of the coefficient of…

Q: Use the International Stock Market database from “Excel Databases.xls” on Blackboard. Use Excel to…

A: when i do multiple Regression Analysis for the first time, R-squared value is 01976581…

Q: Consider the following estimated trend models. Use them to make a forecast for t= 22. a. Linear…

A: Given t=22

Q: The table given below shows the Consumer Price Index (CPI) for selected years. Use the regression…

Q: (d) Compare the three-week moving average forecast with the exponential smoothing forecast using a =…

A: Ans : From the above given data This is the data we have been provided. From that data your answers…

Q: a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.…

A: To find the July forecast using a weighted moving average with weights of 0.60, 0.30, and 0.10,…

Q: You estimate a regression equation that estimates individuals’ yearly income as a function of age…

A: The estimated regression equation is,I = 26.3+4.21×Age+7.21×Education+0.23×IQ

Q: (b) Compare a three-month moving average forecast with the exponential smoothing forecast for a -…

A: Given information:- Month Sales 1 80 2 82 3 84 4 83 5 84 6 84 7 85 8 84 9 82…

Q: please answer in text form and in proper format answer with must explanation , calculation for each…

A: this helps

Q: College Enrollment The percentage of female high school graduates who enrolled in college is given…

A: To find the cubic regression model , we need to perform regression analysis using the given data…

Q: Using the regression equation developed in step 2, forecast the monthly food and beverage sales for…

A: Month 1st 2nd 3rd January 242 263 282 February 235 238 255 March 232 247 265 April 178 193…

Q: Below is data collected over 6 specific years. The data collected is the Consumer Price Index (CPI)…

A: Note: Since you have posted a question with multiple subparts, we will solve the first three…

Question

ABC Corporation has sales figures as given below.

Forecast sales for 2021 using the following techniques:

(a) the trend line method. Mention the equation and the R square value obtained.

(b) Three year moving average method.

Year
2012
2013
2014
2015
2016
2017
2018
2019
2020
Sales
55
57
60
64
65
71
70
76
79
(Mn S)

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yes
The fitted regression is Sales = 842 − 37.5 Price. (a-1) If Price = 1, what is the prediction for Sales? (Round your answer to 1 decimal place.) (b) If Price = 20, what is the prediction for Sales?
Plot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component. Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021. On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.
. Fill in the "Years since 1970" column for the data to the right. Make a scatter plot in Excel of the data using Years since 1970 and Total Waste in Millions of Tons (Title your graph and label your axes appropriately). How would you best describe the trend? Add an exponential regression model to the data. Write the equation below. Is it a good fit? Explain how you know. Based on the exponential model, what is the growth rate per year? Explain the meaning of the growth rate in the context of the data. Using the exponential model, make a prediction of how much plastic will be in landfills (and the ocean gyres) by Year Years since 1970 Total Waste in Millions of Tons 1970 0 249 1980 10 798 1985 15 1200 1990 20 1740 1995 25 2440 2000 30 3390 2005 35 4600 2010 40 6060 2015 45 7820 Do you think recycling alone will solve this problem (See Q11 and Q12)? What are some of the challenges in recycling plastic that might hinder the world from recycling all plastic…