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 X}! : 1 if method M is successful (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. acetonefree, remover strips vs. soaking, etc.). We will refer to the method ONE approach as \"M1" 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. To determine the joint distributions for each person, you can use the Excel \"IF" function. In cell D2, type \"=IF(AND(B2=0,C2=0),1,0)\". Similarly, type the following functions in each of their respective cells: 0 Type \"=IF(AND(B2=1,C2=0),1,0)" in cell E2 0 Type \"=IF(AND(B2=0,C2=1),1,0)" in cell F2 0 Type \"=IF(AND(B2=1,Cz=1),1,0)" in cell (:2 Using the ll box (the small box at the bottom of each cell), drag each formula dOwn to row 101 (that is, person 100). Now, in cell B102, type \"=AVERAGE(B2:B101)\" to get Ml. By clicking the ll box at the bottom of cell B102 and dragging across to cell G102, we have the following concepts: 0 The marginal probability ml 2 Plr'(XiMl = 1) in cell 3102 o The marginal probability m2 = lei(X312 = 1) in cell C102 0 The joint probability PT(XiMl = 0 0 X342 = 0) in cell D102 0 The joint probability luv-(XiMl = 1 0 X342 = 0) in cell E102 . The joint probability lei-(X311 = 0 0 X342 = 1) in cell F102 0 The joint probability PT(XMI : 1 0 X342 = 1) in cell G102 Using the above values, complete the joint distribution table below. (8 pts) XM2 0 1 Pr(X,Ml) X3\" 0 1 Pr(X,-""2) 11. What is the mean and variance of the di'erence, X?\" X?\" (or pm] plug)? (8 pts) 12. Construct a 95% condence interval for the difference, le 30342. (6 pts) 13. Suppose we wanted to test the null hypothesis, Ho : pm = mg at the 5% level. Another way to write the null hypothesis is Ho : pm m2 = 0. In plain English, briey 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) Subject MI M2 (0, 0) (1, 0) (0, 1) (1, 1) 1 0 0 -o - - - . . - . . . - 0 - - 0 - 0 0- - . - . . - .- o- - co.- o-o o- - . . . . . - - - 0 0 - - o o . . - . - .- - o - - - . . . . . - . - . - . . - . . . .- - 0 -0 0 100 Pr 0.65 0.49Assignment 3 1 Proportions and Differences The Louisiana Department of Education (LDE) is concerned with the scores of the standardized math and science exams among the 627 high schools in the state. The study sampled n : 442 schools and resulted in the variable statistics pad 2 $ = 0.48 and mnth = $ = 0.46, showing the percentage of students that pass the exam in each discipline, respectively. After analysis, the covariance was determined to be CV[sci, math] : 0.05. 1. What is the sample mean and variance of sci math (i.e., pm; pmth)? (8 pts) 2. Initially, it appears that the math exam is harder as science scores are above math by 2% in our sample. What is the probability that the true science score exceeds the math score by more than 5% (that is, Pr(psci_mnth > 0.05) or Pray\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 2 X Input Input Range: SBS1:SC5101) 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)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 (mg and plug). (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. (3 pts)