Answer the following questions using the data from the Excel file Deloitte.xlsx from Problem 16.36. a. Using
Question:
Answer the following questions using the data from the Excel file Deloitte.xlsx from Problem 16.36.
a. Using exponential smoothing with α = 0.6, forecast the percentage of holiday shoppers who intend to spend less in 2018.
b. Calculate the MAD for the forecast in part a.
c. Using exponential smoothing with trend adjustment, α = 0.6 and β = 0.4, forecast the percentage of holiday shoppers who intend to spend less in 2018.
d. Calculate the MAD for the forecast in part c.
e. Which forecast do you have most confidence in?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
a b MAD 32557 465 c d MAD 26237 375 e The forecast using exponential smoothing with trend adjustm...View the full answer
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.
2+ Reviews
10+ Question Solved
Related Book For 
Question Posted:
