PART B:Please use STATA for this portion (30 points)

(10 points)A. In a hypothetical study usingthe 2017 BRFSS, where the study purpose is to estimate the effect of feeling in good health on regular physical activity in the non-institutionalized US adult (18+) population, please complete the following analysis tasks. In this study the outcome is physical activity and the exposure is self-reported general health status. You can use the code provided below to create the variables.

Physical activity:

. generate exercise=1 ifEXERANY2==1

(145,436 missing values generated)

. replace exercise=0 ifEXERANY2==2

(107,444 real changes made)

. label defineexerciselbl 0 "No exercise in past 30 days" 1 "some exercise in past 30 days"

. label val exercise exerciselbl

. tab exerciseEXERANY2, missing

. tab exercise EXERANY2, missing

Physical activity: generate exercise=1 if EXERANY2==1 (145, 436 missing values generated] replace exercise=0 if EXERANY2==2 (107, 444 real changes made) label define exerciselbl 0 "No exercise in past 30 days" 1 "some exercise in past 30 days" . label val exercise exerciselbl tab exercise EXERAN12, missing tab exercise EMERANY2, missing EXERCISE IN PAST 20 DAYS 1 2 Total No exercise in past 2 | 114, 783 114, 783 Some exercise in past - 301, 030 0 301, 030 588 462 23, 153 24, 203 Total | 301 , 030 114, 783 588 462 23, 153 | 450, 016General health: generate goodgenhlth=1 if genhlth=4 & genhith