Using EXCEL develop a spread sheet to make a table of the entire classes' predicted values (from the equations above) for FVC, FEV1, RV, and FEV1/FVC as a percentage. 2. Apply the actual values of the same metrics (e.g., actual FVC = VC) from the spirometry tests. The spirometer may not provide predicted RV. There will be other values provided by the spirometer printout. Focus on FVC and FEV1. 3. Calculate the percent difference from the predicted and measured for each volume or capacity. In your opinion, did the equations correctly estimate the real data? Why? 4. Compare your actual FEV1/FVC against the norms. How did you compare? How did the class compare? Does anyone in the class suffer from a respiratory deficiency? 5. Take the means of females and compare them to males. Is there a difference