Copy of Ex_2.1_and_14.1_template-1.xlsmRead this assignment

Copy of Ex_2.1_and_14.1_template-1.xlsmRead this assignment well before you place your bid. Its due in 8 hours from now. I NEED PERFECT workExercises: 2.1 and 14.1The following exercises are required and cover topics in this week’s required reading. Reviewthe instructions carefully before completing and submitting theexercises. For the exercises this week and in following weeks, pleaseuse the Excel templates provided. For several of the exercises you willuse automated templates (that is, Excel templates that automaticallyperform 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 AveragesTemplate’), which includes an automated Excel table, for yourcalculations, or do these manually. Use Sheet 2 to record your answersto a, b, c, and this additional question (2.1d): ‘In 1–2 sentences,explain which of the three results you have the most confidence inprojecting 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 useSheet 4 to record your answers. For an explanation of the automatedtable for Exercise 14.1, refer to Quantitative Methods, p. 379.Excel template for Exercise 2.1 and 14.1Note on using the Excel templates:Save the template to your desktop before using. Make sure macros areenabled so that you can use the automated Excel template. Any existingnumbers in green cells in the automated table are for examples,and show where you should enter the data. You must delete or overwritethese numbers to do your calculations. The yellow cells are protected toprevent users from accidentally deleting or overwriting the formulas.There is no need to unprotect the template.