Can you please answer the following questions and put them in Excel.

Consider again the study described in the problem below:

Peak expiratory flow (PEF) is a measure of a patients ability to expel air from the lungs. Patients with asthma or other respiratory conditions often have restricted PEF. The mean PEF for children free of asthma is 306. An investigator wants to test whether children with chronic bronchitis have restricted PEF. A sample of 40 children with chronic bronchitis is studied and their mean PEF is 279 with a standard deviation of 71. Is there statistical evidence of a lower mean PEF in children with chronic bronchitis? Run the appropriate test at .05.

A different investigator conducts a second study to investigate whether there is a difference in mean PEF in children with chronic bronchitis as compared to those without. Data on PEF are collected and summarized below. Based on the data, is there statistical evidence of a lower mean PEF in children with chronic bronchitis as compared to those without? Run the appropriate test at .05.

Group	Number of Children	Mean PEF	Std Dev PEF
Chronic Bronchitis	25	281	68
No Chronic Bronchitis	25	319	74