1. Using the data given in Figure 3.2 (or the data in Chpt 3-1.xls), indicate whether each of the variables in the figure is categorical or numerical, and if numerical, whether continuous or discrete, and give your reason(s) for saying so. Using the data given in Figure 3.2, do the following: Using=1IF (), transform Sexinto a 1 if Sexis F and a 0 if Sex is M. Call this Sex1. Show the results in an Excel spreadsheet. What type of variable is the resulting variable, and why? Using nested =1IF (),transform Age to another variable that combines Age into 10-year age groups, beginning with the youngest age among the patients listed. Assign 1 to the youngest group. Call this Age1. Show the results in an Excel spreadsheet. What type of variable is the resulting variable, and why? Using nested =IF (),transform Age to another variable that combines Age into 10-year age groups, beginning at birth. Assign 1 to the youngest age group. Call this Age2. Show the results in an Excel spreadsheet. What type of variable is the resulting variable, and why? Using nested =IF (), transform the variable Insurance into a new variable called Insurance1that is, 1 if the insurance type is Medicaid, 2 if the insurance type is Blue Cross Blue Shield, 3 if the insurance type is private, and 4 for self-pay. Show the results in an Excel spreadsheet. What type of variable is the resulting variable, and why? Using nested =IF (), transform the variable Prior into a variable called Prior1, where no prior visits is coded None, 1 to 2 prior visits is coded Low, 3 to 4 prior visits is coded Medium, and 5 or 6 prior visits is coded High. Show the results in an Excel spreadsheet. What type of variable is the resulting variable, and why? ID Age Sex Opinion 1 Opinion 2 Chrges Visit Time Insurance Prior 33 F 3 $58 40 Self Pay 5 2 21 F 3 $59 44 Medicaid 1 3 56 F 3 $78 51 Medicaid 5 4 53 M 4 $24 36 BCBS 2 5 51 F 4 $46 55 Private 5 6 22 F $30 21 BCBS 2 7 62 F $114 33 BCBS 0 8 39 F $51 43 BCBS 4 9 60 F $100 34 Private 4 10 61 F $45 59 Private 6 11 65 M $55 24 Private 2 12 60 F . W N A W W N N W AUNAU $36 53 Medicaid 6 13 61 M $62 31 Self Pay 4 14 28 F $100 25 Self Pay 3 15 54 F $111 48 Self Pay 3 16 64 F $59 44 Medicaid 3 17 44 F $45 57 BCBS 4 18 25 F $58 43 Private 1 19 25 M 1 $95 45 Private 3 20 32 F 3 $92 33 Private 4