Purchase Solution

Applied Quantitative Medthods and Forecasting Using Extrapolation By Moving Averages and Smoothing

Not what you're looking for?

Ask Custom Question

Using the Northern College Health Services data presented on page 113 of your textbook, present a forecast of clinic visits for week XX using Extrapolation by Moving Averages and also using Extrapolation by Exponential Smoothing. Which of these approaches will provide the best forecast in your view, and why?

The data on pg. 113 is from the textbook Essentials of Applied Quantitative Methods for Health Service Managers by James B. Lewis, Robert J. McGrath, Lee F. Seidel

I have no idea where to even begin with this problem!!! Please help!!

Purchase this Solution

Solution Summary

Applied quantitative methods and forecasting are examined.

Solution Preview

I have provided you with an example of how to do these two techniques using the 2008 values. Note in your photo that the last two months of 2008 are blank. I have forecasted these two months using both the exponential smoothing and moving average methods. Note I use Excel 2010. This is really easy to do if you just know how to use the Data Analysis Toolpak in Excel. In my solution, I provide you with instructions on how to load it into your Excel. It's a free pre-loaded tool. Just needs to be activated. Note: I have just given ...

Purchase this Solution


Free BrainMass Quizzes
Fibromyalgia

This quiz provides a brief overview of Fibromyalgia. Research is currently evolving regarding this diagnosis.

Tumor Markers

This quiz help you memorize common tumor markers used to detect and diagnose some types of cancer.

Crohn's Disease

How much do you know about this condition?

Labor and Delivery

Do you know about the stages of delivery? Find out with this quiz!

Celiac Disease

This quiz will provide a brief introduction to Celiac Disease. Questions will focus on definitions and symptoms.