PLEASE PLEASE HELP

In a recent study on risk factors for strokes, the American Heart Association (AHA) coliected data on age, systolic blood pressure, diastolic blood pressure, and risk of stroke; risk is interpreted as the probability (times 100) that a person will have a stroke over the next 10 -year period. Data collected from smokers is provided in the file ahasmokers, and data collected from nonsmokers is provided in the file ahanonsmokers. Click on the datafile logos to reference the data. DATA DATA These data must be combined in order to facilitate their analysis, systolic blood pressure outside of the range of 80200 and diastolic blood pressure outside of the range of 60130 are extremely rare, so the data must also be reviewed to ensure there are no records with a systolic blood pressure eutside of the range 80-200 and no diastolic blood pressure is outside of the range of 60-140. Finally, the AHA wants to alert all patients who have severe hypertension, which is a systolic blood pressure above 180, so the organization wants to add a fold to the final dato that indicates whether a subject has severe hypertension. At the begining create a new field named Smoker? in the file ahasmokers. xisx. Define the value of this field for each record as 1 . Then create a new field named Smoker? in the file ahanonsmokers.xisx. Define the value of this field for each record as 0 , Combined all records from these two files into a single flie. Save the file under then name ahastudy xisx, in the new file add a new field named Severetiyp. Define the value of this field for each record to equal Ves if the systolic blood pressure is above 180 and No otherwise. Save your rewilts as a file under the name ahoalert:xlax. (a) Provide the average nsk for stroke for those subjects whose systolic blood pressure is higher than 206. Round your answer to one decimal place. (b) Provide the average age for those subjects whose diastolic blood pressure is lower than 80. Round your answer to one decimal place