Use the file created in Exercise 2 of Section 3.3 of Chapter 3 (or use Chpt 5-3.xls), and do the following: Two Possible Outcomes a. Generate a contingency table with Sex as the column variable and...

Use the file created in Exercise 2 of Section 3.3 of Chapter
3 (or use Chpt 5-3.xls), and do the following:

Two Possible Outcomes

a. Generate
a contingency table with
Sex
as the column variable and Insurance as the row variable, and calculate
the
marginal probabilities of each variable.

P(A)= A/N

b. Calculate

joint probabilities
“and” for the two variables and show them in a
separate table. Confirm that the joint probabilities “and” sum to 1.

P(A and B)

c. Calculate

joint probabilities
“or” for the two variables, and show them in a
separate table. Confirm that the joint probabilities “or” sum to rows + columns
− 1.

d.
Calculate
conditional probabilities
of having a particular type of insurance, given
Sex, and determine if the two variables are independent.

Sheet1 Insurance BCBS Medicaid Private Self Pay Grand Total Sheet2 Sex InsuranceFMGrand Total BCBS Medicaid Private Self Pay Grand Total Chpt 3-4 IDAgeSexOpinion 1aOpinion 2aChargesVisit TimeDate of BirthInsuranceOpinion 1Opinion 2Date of visitArrival timeDeparture timePrior visitsProcedure1Procedure2Procedure3Procedure4 132F53$58.000:402/4/68Self PayAll of the timeUndecided1/26/0112:14 PM12:54 PM5$58.00 220F23$59.000:446/16/80MedicaidSome of the timeUndecided6/11/019:51 AM10:35 AM1$39.00$20.00 355F13$78.000:5111/23/45MedicaidNeverUndecided11/9/012:04 PM2:55 PM5$78.00 452M24$24.000:3610/21/48BCBSSome of the timeAgree10/8/014:38 PM5:14 PM2$22.00$2.00 550F54$46.000:559/21/50PrivateAll of the timeAgree9/8/014:31 PM5:26 PM5$27.00$19.00 621F15$30.000:217/3/80BCBSNeverStrongly Agree6/28/025:08 PM5:29 PM2$30.00 761F41$114.000:332/8/39BCBSMost of the timeStronglyDisagree1/23/019:07 AM9:40 AM0$66.00$28.00$20.00 838F12$51.000:433/26/62BCBSNeverDisagree3/16/0112:27 PM1:10 PM4$36.00$15.00 959F55$100.000:3411/2/41PrivateAll of the timeStrongly Agree10/18/014:20 PM4:54 PM4$59.00$31.00$10.00 1060F34$45.000:596/13/41PrivateAbout as often as notAgree5/29/0210:10 AM11:09 AM6$30.00$15.00 1164M13$55.000:241/30/37PrivateNeverUndecided1/14/0211:04 AM11:28 AM2$55.00 1259F12$36.000:533/2/42MedicaidNeverDisagree2/15/029:23 AM10:16 AM6$36.00 1360M32$62.000:316/3/40Self PayAbout as often as notDisagree5/19/019:16 AM9:47 AM4$24.00$20.00$18.00 1427F43$100.000:2511/4/73Self PayMost of the timeUndecided10/28/0110:23 AM10:48 AM3$72.00$28.00 1553F43$111.000:4812/25/47Self PayMost of the timeUndecided12/11/0110:52 AM11:40 AM3$68.00$43.00 1663F24$59.000:448/30/37MedicaidSome of the timeAgree8/14/019:08 AM9:52 AM3$41.00$18.00 1743F32$45.000:576/13/57BCBSAbout as often as notDisagree6/2/0111:25 AM12:22 PM4$21.00$14.00$10.00 1824F23$58.000:434/17/77PrivateSome of the timeUndecided4/11/0211:54 AM12:37 PM1$51.00$7.00 1934M11$95.000:455/27/66PrivateNeverStronglyDisagree5/18/011:42 PM2:27 PM3$36.00$39.00$15.00$5.00 2031F53$92.000:3312/20/68PrivateAll of the timeUndecided12/12/0012:02 PM12:35 PM4$46.00$30.00$16.00 2147M23$96.000:5911/15/53Self PaySome of the timeUndecided11/3/0112:09 PM1:08 PM2$70.00$26.00 2230M42$91.000:4111/14/70Self PayMost of the timeDisagree11/6/0112:01 PM12:42 PM4$43.00$28.00$20.00 2347F54$84.000:271/5/53PrivateAll of the timeAgree12/24/004:44 PM5:11 PM4$43.00$41.00 2435M35$79.000:281/31/65MedicaidAbout as often as notStrongly Agree1/22/0112:57 PM1:25 PM5$41.00$38.00 2530F42$64.000:287/1/71MedicaidMost of the timeDisagree6/23/0212:37 PM1:05 PM6$55.00$9.00 2630F32$69.000:4112/13/70MedicaidAbout as often as notDisagree12/5/0111:34 AM12:15 PM5$69.00 2763M13$92.000:432/2/37PrivateNeverUndecided1/17/015:17 PM6:00 PM5$61.00$31.00 2862M35$118.000:227/19/38Self PayAbout as often as notStrongly Agree7/3/013:51 PM4:13 PM4$78.00$40.00 2929F53$76.000:3311/14/71PrivateAll of the timeUndecided11/6/015:25 PM5:58 PM3$34.00$22.00$13.00$7.00 3019M31$74.000:407/2/81Self PayAbout as often as notStronglyDisagree6/27/0111:10 AM11:50 AM3$36.00$28.00$10.00 3151M23$75.000:3011/25/49PrivateSome of the timeUndecided11/12/015:05 PM5:35 PM2$75.00 3252M55$101.000:404/22/48BCBSAll of the timeStrongly Agree4/9/019:27 AM10:07 AM0$43.00$33.00$25.00 3344F33$108.000:442/5/56BCBSAbout as often as notUndecided1/24/012:59 PM3:43 PM4$42.00$26.00$20.00$20.00 3428M31$73.000:592/26/73MedicaidAbout as often as notStronglyDisagree2/19/023:56 PM4:55 PM2$34.00$39.00 3536M34$103.000:2112/28/63MedicaidAbout as often as notAgree12/18/005:15 PM5:36 PM3$65.00$20.00$18.00 3628F14$65.000:395/2/72MedicaidNeverAgree4/25/0112:57 PM1:36 PM1$50.00$15.00 3759F32$95.000:583/6/42BCBSAbout as often as notDisagree2/19/0211:33 AM12:31 PM1$33.00$32.00$22.00$8.00 3826F12$62.000:4512/5/74MedicaidNeverDisagree11/28/013:22 PM4:07 PM6$62.00 3958F55$51.000:441/25/42MedicaidAll of the timeStrongly Agree1/10/0111:59 AM12:43 PM1$51.00 4051F51$70.000:278/27/49Self PayAll of the timeStronglyDisagree8/14/013:35 PM4:02 PM2$31.00$29.00$10.00 4149M34$82.000:308/10/51BCBSAbout as often as notAgree7/28/019:37 AM10:07 AM4$48.00$34.00 4246M53$65.000:421/21/55MedicaidAll of the timeUndecided1/9/0210:41 AM11:23 AM5$65.00 4329F43$95.000:5611/15/71MedicaidMost of the timeUndecided11/7/019:32 AM10:28 AM5$64.00$31.00 4451F44$57.000:486/23/50Self PayMost of the timeAgree6/10/0212:02 PM12:50 PM5$44.00$13.00 4549F51$92.000:574/19/51BCBSAll of the timeStronglyDisagree4/6/011:08 PM2:05 PM1$52.00$20.00$20.00 4641M13$102.000:2811/27/59BCBSNeverUndecided11/16/011:20 PM1:48 PM5$37.00$35.00$17.00$13.00 4752F43$55.000:3812/19/48BCBSMost of the timeUndecided12/6/0112:10 PM12:48 PM1$49.00$6.00 4861F35$66.000:463/6/39BCBSAbout as often as notStrongly Agree2/18/015:22 PM6:08 PM3$47.00$19.00 4958F33$85.000:507/24/43PrivateAbout as often as notUndecided7/9/029:20 AM10:10 AM4$59.00$26.00 5020F35$91.000:271/21/80PrivateAbout as often as notStrongly Agree1/15/0110:57 AM11:24 AM1$72.00$19.00 Sex FMGrand Total