I have a set of data and I am looking for some help with several ways I have to break the data down;
Using =IF(), transform *** into a 1 if *** is F and a 0 if *** is M. Call this Sex1. *** is broken down in cells c2-c21
Using nested =IF(), transform age to another variable that combines age into ten-year age groups, beginning with the youngest age among the patients listed. Assign 1 to the youngest group. Call this Age1. Age is broken down in cells b3-b21 and the youngest age is 21
Using nested =IF(), transform age to another variable that combines age into ten-year age groups, beginning at birth. Assign 1 to the youngest age group. Call this Age2. age is broken down in cells b3-b21
Using nested =IF(), transform the variable Insurance into a new variable called Insurance1—that is, 1 if the insurance type is Medicaid, 2 if the insurance type is BCBS, 3 if the insurance type is private, and 4 for self-pay. Insurance is broken down in cells h2-h21
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. Prior is broken down in cells i2-i21
thanks for the help!
Bookmarks