please answer question and explain how to use with microsoft excel

3. Staff members at a prenatal clinic see many women who smoke. Staff have decided to assess the effectiveness of a video on the dangers of smoking during pregnancy. They have decided to divide the women smokers who come to the clinic into two groups. one that receives the normal warnings about the dangers of smoking and one that is asked to view the video. Over the next six months, the clinic expects to see about 40 women who are smokers. Use =RAND() to select a sample of 20 women who will view the film and 20 who will not out of the next 40 women to arrive at the clinic. Use the Bernoulli distribution in the Data Analysis add-in to simulate the flip of a coin 50 times. Generate a random seed using =RAND(). If you consider a value of one to be a head, use the =SUM() function to determine the number of heads and tails flipped. Use the binomial distribution in the Data Analysis add-in to simulate the distribution of men and women among the next 10 arrivals at an emergency room, assuming that, on average 94 CHAPTER 3: DATA ACQUISITION: SAMPLING AND DATA PREPARATION 6 people out of 10 who arrive are men. Generate a random seed using =RAND(). Simulate the arrival of 50 sets of 10 people. Use the =COUNTIF() function to determine how of the 50 sets of 10 people will be all men and how many will be 9 men and 1 woman. 6. Use the discrete distribution in the Data Analysis add-in to simulate the roll of a six-sided die 50 times. Generate a random seed using =RAND(). Use the =COUNTIF) function to determine how many of the 50 rolls will produce a six. many clinic. There is an ID for each of the 20 people who are include Hata set, along with nine variables. The variable Age is coded as e 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 och- NUNU B D G 1 D Age Sex Opinion 1 Opinion 2 Charges Visit Time Insurance Prior 2 1 33 F 3 $ 58.00 40 Self Pay 5 3 2 21 F 2 3 5 59.00 44 Medicaid 1 4 3 56 F 1 3 $ 78.00 51 Medicaid 5 4 53 M 2 4 $ 24.00 36 BCBS 6 5 51 F 5 4 $ 46.00 55 Private 5 7 22 F 1 5 5 30.00 21 BCBS 2 7 62 F 4 1 $114.00 33 BCBS 0 9 8 39 F 1 2 $ 51.00 43 BCBS 4 10 9 60 F 5 5 $100.00 34 Private 4 11 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 61 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 are 3.2 Constructed data for an imaginary dinic 3. Staff members at a prenatal clinic see many women who smoke. Staff have decided to assess the effectiveness of a video on the dangers of smoking during pregnancy. They have decided to divide the women smokers who come to the clinic into two groups. one that receives the normal warnings about the dangers of smoking and one that is asked to view the video. Over the next six months, the clinic expects to see about 40 women who are smokers. Use =RAND() to select a sample of 20 women who will view the film and 20 who will not out of the next 40 women to arrive at the clinic. Use the Bernoulli distribution in the Data Analysis add-in to simulate the flip of a coin 50 times. Generate a random seed using =RAND(). If you consider a value of one to be a head, use the =SUM() function to determine the number of heads and tails flipped. Use the binomial distribution in the Data Analysis add-in to simulate the distribution of men and women among the next 10 arrivals at an emergency room, assuming that, on average 94 CHAPTER 3: DATA ACQUISITION: SAMPLING AND DATA PREPARATION 6 people out of 10 who arrive are men. Generate a random seed using =RAND(). Simulate the arrival of 50 sets of 10 people. Use the =COUNTIF() function to determine how of the 50 sets of 10 people will be all men and how many will be 9 men and 1 woman. 6. Use the discrete distribution in the Data Analysis add-in to simulate the roll of a six-sided die 50 times. Generate a random seed using =RAND(). Use the =COUNTIF) function to determine how many of the 50 rolls will produce a six. many clinic. There is an ID for each of the 20 people who are include Hata set, along with nine variables. The variable Age is coded as e 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 och- NUNU B D G 1 D Age Sex Opinion 1 Opinion 2 Charges Visit Time Insurance Prior 2 1 33 F 3 $ 58.00 40 Self Pay 5 3 2 21 F 2 3 5 59.00 44 Medicaid 1 4 3 56 F 1 3 $ 78.00 51 Medicaid 5 4 53 M 2 4 $ 24.00 36 BCBS 6 5 51 F 5 4 $ 46.00 55 Private 5 7 22 F 1 5 5 30.00 21 BCBS 2 7 62 F 4 1 $114.00 33 BCBS 0 9 8 39 F 1 2 $ 51.00 43 BCBS 4 10 9 60 F 5 5 $100.00 34 Private 4 11 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 61 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 are 3.2 Constructed data for an imaginary dinic