Exercises: 2.1 and 14.1
The following exercises are required and cover topics in this week's required reading. Review
the instructions carefully before completing and submitting the
exercises. For the exercises this week and in following weeks, please
use the Excel templates provided. For several of the exercises you will
use automated templates (that is, Excel templates that automatically
perform calculations) to arrive at your answers.
1) Complete Exercise 2.1 on page 45 in Quantitative Methods in Health Care Management.
In the Excel document below, you may use Sheet 1 ("Moving Averages
Template"), which includes an automated Excel table, for your
calculations, or do these manually. Use Sheet 2 to record your answers
to a, b, c, and this additional question (2.1d): "In 1–2 sentences,
explain which of the three results you have the most confidence in
projecting accurately and why that is."
2) Complete Exercise 14.1 on page 386 in Quantitative Methods in Health Care Management.
In the Excel document below, use Sheet 3 ("Single Channel Template"),
which includes an automated Excel table, for your calculations, and use
Sheet 4 to record your answers. For an explanation of the automated
table for Exercise 14.1, refer to Quantitative Methods, p. 379.
Note on using the Excel templates:
Save the template to your desktop before using. Make sure macros are
enabled so that you can use the automated Excel template. Any existing
numbers in green cells in the automated table are for examples,
and show where you should enter the data. You must delete or overwrite
these numbers to do your calculations. The yellow cells are protected to
prevent users from accidentally deleting or overwriting the formulas.
There is no need to unprotect the template.