re are two deliverables for this homework.
1. An Excel file with the calculation of Confidence Interval of the difference of proportions.
2. A Microsoft Word file contains the write-up of the analysis and answers to the questions.
The Confidence Interval (C.I.) Calculation
· To help you do the C.I., you have been provided with an Excel file “Chapter 8_Procedures_v2”. Use this template to complete the analysis. This template contains various C.I. calculations. You will be using the sheet “CI for Diff of two Prop” for your homework. It is the “brown” colored tab sheet. The embedded formulas on this sheet are based on the CI formula from page 480 of your textbook. In order to preserve the embedded formulas, you are only allowed to input numbers into the “green” cells. I encourage you to explore how the embedded formulas were implemented.
· This Excel file accounts for 20 points of your homework grade.
· The write-up should include the C.I. analysis and answers to the questions.
· The write-up must be in Microsoft Word.
· The write-up accounts for 10 points of your homework grade.