Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Damping factor exponential smoothing excel

03/12/2021 Client: muhammad11 Deadline: 2 Day

FORECASTING - TIME SERIES ANALYSIS IN EXCEL

(Chapter 16 in Excel)

EXERCISE #1: OBTAIN FORECASTED VALUES USING THE MOVING AVERAGE METHOD

Option 1: With Data Analysis Toolpak: Data ( Data Analysis ( Moving Average

image1.png

In the dialog box: Enter the data range in “INPUT RANGE” and under “INTERVAL” enter the number for your choice of an MA order (e.g., for an MA(5), the number 5 was entered above).

Then under “OUTPUT RANGE”, highlight the cells in which you want to place the output but start with one cell after the first one with the real values. For example, from above, cell F3 was selected as the output range and the output will be as follows:

image2.png

Option 2: Enter AVERAGE formulas in each cell

For example, to get the MA(5) forecasted value of $21.702 as shown in cell F7 the formula appears below:

image3.png

EXERCISE #2: OBTAIN FORECASTED VALUES USING THE EXPONENTIAL SMOOTHING METHOD

Option 1: With Data Analysis Toolpak: Data ( Data Analysis ( Exponential Smoothing

In the dialog box: Enter the data range in “INPUT RANGE” and under “DAMPING FACTOR” enter the number for your choice of a weight (W) or smoothing coefficient between 0 and 1.

Excel uses this particular formula where W is the weight:

forecasted Yt = (1- W) Yt – 1 + W forecasted Yt - 1

Then under “OUTPUT RANGE”, highlight the cells in which you want to place the output but place it at the same row as the first observation with the real values. For example, as shown below, the output range was selected to be in cell F2.

image4.png

The output will be:

image5.png

Option 2: Enter the formulas in each cell

For example, with a smoothing factor of 0.50 in which the exponential smoothing equation is

forecasted Yt = (1- W) Yt – 1 + W forecasted Yt - 1

to get the exp. smoothing forecasted value of $22.87 in cell F4 the formula appears below:

image6.png

EXERCISE #3: OBTAIN FORECASTED VALUES USING THE REGRESSION ANALYSIS METHOD

First, define your regression model; any model you wish but explain it using the equation form. For example, we can forecast using a First Degree Autoregressive Model with this equation:

Yt = a + b Yt -1

Note that in Excel you would need to create an extra column for the data at time Yt - 1 as shown below:

image7.png

Option 1: With Data Analysis Toolpak: Data ( Data Analysis ( Regression

In the dialog box: enter under “Input Y Range” the t data. Under “Input X Range”, enter the t-1 data. And, mark “Line Fit Plots” to get all the forecasted Yt

image8.png

The output will be as shown below. Notice that by selecting “Line Fit Plots“, the regression output includes the values of each forecasted Yt under the column titled “Predicted Sara Lee at t” in the “Residual Output” section shown in the last section of the output.

From the regression output, using this data as an example, we can see that the intercept is equal to 3.611107174 and the slope is equal to 0.813321907. Thus, our regression equation is:

Yt = 3.611107174 + 0.813321907 Yt-1

Note: because the 95% confidence interval of the slope does not include 0, we can say that Yt is affected by its past values.

image9.png

Option 2: Enter the formulas in each cell

To calculate the intercept and the slope, enter these formulas separately in a cell:

=INTERCEPT(data range of Yt, data range of Yt-1)

=SLOPE(data range of Yt, data range of Yt-1)

Below, you can see the formula for the intercept in cell I3

image10.png

Below, you can see the formula for the slope in cell I4

image11.png

Finally, to compute the forecasted values create one new column and use the regression equation with the values of the intercept and slope. For our sample data, this formula is

Yt = 3.611107174 + 0.813321907 Yt-1

and the Excel column will be as shown below:

image12.png

EXERCISE #4: COMPARE THE FORECASTED VALUES FROM ALL THREE METHODS AND CHOOSE THE BEST ONE

In this case, we needed to calculate the forecast error under each method for each observation and use MAD = average absolute forecast error. Hence, the first part in Excel is to get the absolute value of each of the forecast errors under each method as follows (see formula in cell C7):

image13.png

Then, we calculate the average of these forecast errors under each method to get the MAD as follows (see formula in cell C56):

image14.png

As we can see the MAD is lower under the regression method, which is not surprising since we have an upward time trend in the data because these are stock prices that have been moving up over the years. In the case of an upward time trend it is better to use a regression model.

These are the forecasted values

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Helping Engineer
Professor Smith
Professional Coursework Help
Best Coursework Help
Engineering Mentor
Math Guru
Writer Writer Name Offer Chat
Helping Engineer

ONLINE

Helping Engineer

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$33 Chat With Writer
Professor Smith

ONLINE

Professor Smith

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$49 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$37 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$17 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$22 Chat With Writer
Math Guru

ONLINE

Math Guru

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$34 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Athens vs sparta women's rights - Chapter 22 descent with modification a darwinian view of life - Gypsum house construction cost - Each student will compare and contrast the global branding strategies and local market implementation (in one country of the student’s choice) for ONE of the following pairs of brands: - Scholarly writing - HN 522 Unit 9 Discussion - Products to sums formula - Eric the tutor nas - In a cost volume profit chart the - Introduction to java 11th edition pdf - Osha 300 logs excel - Acres dry cleaners glanville - Common name of potassium permanganate - Auditing it infrastructures for compliance - Media and globalization ppt - What term is used to describe an oscillator that “runs down” and eventually stops? - BUS HW - Ed sikov film studies an introduction pdf free - My exam timetable usyd - Research Paper - The method section of an apa style research report ____ - Jo koy mexican falling off cliff - Ati teamwork and collaboration case study - Extended answers questions - Case study analysis organizational behavior - Basis point value calculation caiib - Specific problem in research - Statistics canada population pyramid - Discussion - What is an eportfolio - Www ruf rice edu bioslabs tools report reportform html - Jb hi fi warranty - Carer payment form over 16 - Interdependence between marketing and finance - 2nd law of motion experiment - Benjamin button questions - Swot analysis for parks and recreation - Discussion - Branches of humanities and examples - Last chance company offers legal consulting - Open source data loss prevention solution mydlp - Business Finance Discussion - Fear in year of wonders essay - Specific excess power equation - Module 5 assignment 2: professional development plan - My Theory of Classroom Management - Discussion - Counseling theory review powerpoint presentation - Paper 1 - Convergence and the Reshaping of Mass Communication - Uniforms prevent bullying - Hard drawn wire mesh - Australian hardware performance management policy - Domonique bertolucci the daily promise pdf - Edges on a cube - 27962 palm villa dr menifee 92584 - Biology unit 1 study guide - Everybody loves raymond aunt serena - Hamilton north primary school - Paradise lost study questions - Information technology - Singapore business excellence framework - Comunity Nurse DQ 8 - Which market targeting strategy is virgin america following - When making a routine request you should begin with - How many protons and neutrons does aluminum have - International professional practices framework - Igcse history paper 4 candidate response - Building shared services at rr communications case study - Trader joe's near ucla - Bell rock loop track - How does udp verify datagram integrity - What is an example of a concluding sentence - Translating Verbal Expressions - The lb crate is supported by cables - Ecosystem in a bottle experiment - John hopkins hospital mission and vision statement - Hawkhurst drive rock ferry - +91-8306951337 get your love back by vashikaran IN Maheshtala - The seven pillars of wisdom bible study - Medway messenger sunday league - Bunsen burner flame height - Acropolis institute of technology & research - HUMANITY - Need help with discussion question - Writing that works 13th edition pdf - Woodcock johnson iv scoring manual - The barrio by robert ramirez pdf - Wind power - After the success of the company's first two months - The project scope document is valuable for establishing - Robert e lee's boyhood home - Slii is used by many corporations to train leaders - How to copy and paste in powder toy - BA 2010 - Week 14 - Looking at movies dvd - Johnson and johnson public relations crisis management - Nursing care plan for obsessive compulsive disorder - Animal farm multiple choice questions and answers