Question: please answer and explain on how to enter eith microsoft excel 1. Using the data given in Figure 3.2 (or the data in Chpt 3-1.xls),

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 EXERCISES FOR SECTION 3.1 discrete, and give your reason(s) for saying so. lain the data aivan in Figure 22 de the folla.. clinic. There is an ID for each of the 2 people who are include of statistics. is to make these points clear and show how they are important in Figure 3.2 represents constructed data (made-up data) for an in Gata set, along with nine variables. The variable Age is coded as e A 33 F Nuh B D E G 1 D Age Sex Opinion 1 Opinion 2 Charges Visit Time Insurance Prior 2 1 3 $ 58.00 40 Self Pay 5 3 2 21 F 2 3 5 59.00 44 Medicaid 1 3 56 F 1 3. $ 78.00 51 Medicaid 5 5 4 53 M 2 4 $ 24.00 36 BCBS 6 5 51 F 5 4 $ 46.00 55 Private 5 7 6 22 F 1 5 5 30.00 21 BCBS 2 7 62 F 4 1 $114.00 33 BCBS 0 9 39 F 2 5 51.00 43 BCBS 4 10 9 60 F 5 5 $100.00 34 Private 4 10 61 F 3 4 $ 45.00 59 Private 6 12 11 65 M 1 3 $ 55.00 24 Private 2 13 12 60 F 1 2 $ 36.00 53 Medicaid 6 14 13 51 M 3 2 $ 62.00 31 Self Pay 4 15 14 28 F 4 3 $ 100.00 25 Self Pay 3 16 15 54 F 4 3 $111.00 48 Self Pay 3 17 16 64 F 2 4 $ 59.00 44 Medicaid 3 18 17 44 F 3 2 $ 45.00 57 BCBS 19 18 25 F 3 $ 58,00 43 Private 20 19 35 M 1 $ 95,00 45 Private 21 20 32 F 5 3 $ 92.00 39 Private -mYw=8 re 3.2 Constructed data for an imaginary dinic
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
