These data must be combined in order to facilitate their analysis. systolic blood pressure outside of the range of $80-200$ and diastolic blood pressure outside of the range of $60-130$ are extremely rare, so the data must also be reviewed to ensure there are no records with a systolic blood pressure outside 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 field to the final data that indicates whether a subject has severe hypertension.

At the begining create a new field named Smoker? in the file ahasmokers.xlsx$.$ Define the value of this field for each record as $1.$ Then create a new field named Smoker? in the file ahanonsmokers.xlsx$.$ Define the value of this field for each record as $0.$ Combined all records from these two files into a single file. Save the file under then name ahastudy.xlsx$.$ In the new file add a new field named SevereHyp. Define the value of this field for each record to equal Yes if the systolic blood pressure is above $180$ and No otherwise. Save your results as a file under the name ahaalert.xlsx$.$