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.