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: 3.29 The quarterly revenues of a small medical supply company for the last several years (27…

A: Note: As per the guidelines, we are solving first three subparts for you. Please repost the complete…

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: dentify the best-fit equation to the data trend. Try several possibilities-linear, parabolic, or…

A: x y Y=log10y x2 x.Y 0 67.38 1.828531007 0 0 4 74.67 1.873146151 16 7.492584605 8 82.74…

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: A convenience store recently started to carry a new brand of soft drink. Management is interested in…

A: Given 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: Given below is the monthly trend equation: Y = 130 + 1.8X [Origin : 1/7/2002/ X unit = one month and…

Q: A mutual find achieved the following rates of growth over an 11-month period: 3 , 2 , 7, 8 , 2 , 4 ,…

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: we observe that the forward rate to be 1% below the spot rate what is the expected rate of change in…

A: Here Given Regression relation between forward premium as the independent variable and the rate 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 following is a monthly trend equation : Y = 40 + 4X %3D Note: [origin Jan. 2012, X-unit = one…

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

Q: DIRECTION: Compute for period 8 using Simple exponential smoothing if a = 0.20 Use quantitative…

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: Which trend model would you choose if the variable you are seeking to forecast were increasing at a…

A: Option D is the answer. Answer : Y= a+bX Explanation : Since the growth percentage is constant. We…

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…

Q: Given: (0, 3.0), (2, 20.6), (4, 72.8), (6, 236.5), (8, 714.0), (10, 2209.7) Use the regression…

A: Given

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

differntiate question 3,4 and 5
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
Cell Phones Using the CTIA Wireless Survey for1985–2009, the number of U.S. cell phone subscribers (in millions) can be modeled byy = 0.632x2 - 2.651x + 1.209where x is the number of years after 1985.a. Graphically find when the number of U.S.subscribers was 301,617,000.b. When does the model estimate that the number ofU.S. subscribers would reach 359,515,000?c. What does the answer to (b) tell about this model?
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?
lakhs) of a certain commodity for the year On the basis of quarterly sales (in 2008-12, the following calculations were made : Trend: Y = 20 + 0.5 t with origin at 1st quarter of 2008. where 1 = time unit = one quarter and y = quarterly sales ( Seasonal variations: Quarter I II III IV Seasonal Index 80 90 120 110 Estimate the quarterly sale for the year 1979 using multiplicative model.
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…