Search for question
Question

Atmosphere equations: Develop an EXCEL spreadsheet that contains comparative calculations of the atmospheric pressure at the specific altitudes listed in the Table P.1 below. Use all four equations we went

over in class, namely (a) the isothermal, (b) the constant density, (c) the isentropic, and (d) the standard atmosphere equations. The pressures (in psia) given in the table below are actual measured values. Plot the actual measured values (as points) and the results from all four equations (each plotted as a separate line) on a single graph in EXCEL,versus the elevation (pressure plotted on y-axis and elevation plotted on a logarithmic scale x-axis). Then write a one-sentence description of the accuracy of each equation as compared to the actual data.

Fig: 1

Fig: 2