Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following data represent the annual revenue (in millions of dollars) for a cloud software company from 2009 to 2020.Complete the table by developing:4-year moving

The following data represent the annual revenue (in millions of dollars) for a cloud software company from 2009 to 2020.Complete the table by developing:4-year moving average forecasts3-year weighted moving average forecasts using weights 4, 3 and 2, with emphasis placed on more recent periodsexponentially smoothed forecasts with ?= 0.6( continue in the attachment)

image text in transcribed
Round all results to 3 decimal places. If a posted result is being reused, ensure that the value being reused is the rounded value and not the original result obtained before rounding. Year 4-year Exponential Revenue 3-year Weighted Moving Average Moving Average Smoothing (a = 0.6) 2009 2010 6.9 2017 2012 2012 2014 6.8 2015 2016 5.6 2017 6.3 2018 2019 2020 7.0 2021 Download CSV 1. What is the MAPE for the 4-year moving average forecasts? I1. What is the MAPE for the 3-year weighted moving average forecasts? Ill. What is the MAPE for the exponentially smoothed (a = 0.6) forecasts? IV. Based on MAPE, which of the methods provides the best forecast accuracy for the data? (Select an answer V

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Analysis For Quantitative Finance

Authors: Daniele Ritelli, Giulia Spaletta

1st Edition

1351245104, 9781351245104

More Books

Students also viewed these Mathematics questions