For problems 1 and 2: Create an Excel spreadsheet to do the following:

1. Generate a Table listing Temperatures and Pressures in the Standard Atmosphere model for altitudes ranging from sea level to 25 km in increment of 0.25 km according to the requirements below:

Use SI units for your calculations. Be careful of units in your equations!

As input data, use only the standard sea level data: at h = 0, T = 288.16 K, p = 1.01325 105 N/m2 . Do not enter any other data from Appendix B into your spreadsheet.

The gradient in the Troposphere is given as Th = 3 6.5 10 K/ m and this gradient layer extends to an altitude of 11 km. The first isothermal layer extends from 11km to 25km and has a temperature of 216.66K.

Format your resulting table appropriately, showing an appropriate number of significant figures, well-labeled section headings, good use of borders and shading to make the table attractive, etc. The full Excel spreadseheet must be submitted via Canvas, but you must also submit a hardcopy printout showing just the resulting well-formatted, attractive table.

2.Plot the variations in Temperature and Pressure as a function of altitude. Complete the following graphs: a) T versus h b) p versus h c) ln (p) versus h (i.e. repeat graph b using semilog axes) Observe the following requirements:

Give each graph an appropriate title. Label all axes, and indicate the units with the axis labels. Make sure the numberings on each of the axes are legible and appropriate. Because each graph will contain only a single line, do not include a legend on the plot.

Customize your plots to improve their appearance and aesthetics. (Note: this will be a graded part of this assignment.)