2 Comparing Proportions A cosmetics manufacturer has hired a team of McNeese MBA students to statistically test the success of two types of nail polish removal methods on n = 100 people. Each subject (person) has the exact type of nail polish on each testable nger. For each subject 1', dene ill"M = 1 if method M is succeniful [that is, reducing the target amount of polish on the applied nail within a given timeframe) and zero otherwise. As this research is for statistical clarity more than method content, for brevity we say this can be nail polish remover of any type (acetonebased vs. acetone-vireo, remover strips vs. soaking, etc}. We will refer to the method ONE approach as \"MI" and the method TWO approach as \"M2\" for comparability. We can apply M1 to any right-hand nger, and M2 to the corresponding nger on the left hand, simultaneously. 4. Open the Excel le Data File.xlsx. 'Ib determine the joint distributions for each person, you can use the Excel \"IF" function. In cell D2, type \"=IF(AND(B2=0,CZ=0),1,0)\". Similarly, type the following functions in each of their respective cells: a Type \"=IF{AND(B2=1,CZ=0),1,0)" in cell E2 II Type \"=IF(AND(B2=0,C2=1),1,0}" in cell F2 0 Type \"=IF{AND(B2=1,02=1),1,0}" in cell G2 Usinji,r the ll box (the small box at the bottom of each cell), drag each formula down to row 101 (that is, person 100). New, in cell B102, type \"=AVERAGE(B2:B101)\" to get pm. By choking the ll box at the bottom of cell 3102 and dragging across to cell G102, we have the following concepts: 0 The marginal probability 33m = Pr(X,'\"'" m 1) in cell 3102 I The marginal probability 131.12 = Pr(X,Mg = 1] in cell C102 e The joint probability Pr(X,i\"1 = 0 n Kim = 0) in cell D102 e The joint probability Pal-(X91 = 1 n X?\" = 0} in cell E102 e The joint probability Para?\" = u n X3\"! = 1) in cell F102 0 The joint probability Pr(X" = 1 n X?\" = 1) in cell G102 Using the above values, complete the joint distribution table below. (El pts) X?\" o 1 Pr[X,-Ml) X3" 0 Pr(X}\"3} 5. Now, calculate the variance of methods ONE and TWO (remember, they are both 0-1 vari- ables, so you simply need to use the variance of a Bernoulli distribution for each). (8 pts) 6. Determine the condence intervals for each method (ml and pm). (8 pts) 7. Do the condence intervals from question 6 overlap? Assuming this is an accurate statistical technique, what does it tell you about the methods? (6 pts) 8. Based on historical data, management has determined the company's original method (\"M0\") is 59% effective (successful) in removing nail polish. Test the null hypothesis that method ONE is just as effective as the original method at the 5% level. (8 pts) 9. Determine the sample covariance between methods ONE and TWO. (6 pts) 10. Follow the the procedure below. . Step 1 (adding in the Analysis ToolPak): FILE (top left of screen)-Options->Add- Ins->Manage: Excel Add-ins-Go-Analysis ToolPak (check the box) . Step 2 (getting the Data Analysis kit): DATA (tab at the top of screen)-Data Analysis->Covariance-OK . Step 3 (cacluating the covariance): Follow the image below. Covariance ? x Input Input Range: SBS1:SC51011 OK Cancel Grouped By: Columns Rows Help Labels in First Row Output options Output Range: New Worksheet Ply: New Workbook Complete the variance/covariance table below. M1 M2 M1 M2 What did you find? How does your answers from questions 5 and 9 fit in the table? (6 pts)11. What is the mean and variance of the difference, XMI - XM2 (or PMI - PM2)? (8 pts) 12. Construct a 95% confidence interval for the difference, PMI - PM2. (6 pts) 13. Suppose we wanted to test the null hypothesis, Ho : PMI = PM2 at the 5% level. Another way to write the null hypothesis is Ho : PMI - PM2 = 0. In plain English, briefly explain: What does this null hypothesis say? (8 pts) 14. After testing the null at the 5% level, what does that tell us about the two methods? Have we determined that one is more effective than the other? (6 pts)Assignment 3 1 Proportions and Differences The Louisiana. Department of Education (LEE) is concerned with the scores of the standardized math and science exams among the 627 high schools in the state. The study sampled at = 442 schools and resulted in the variable statistics em = % = 0.43 and em\