Homework Help is Here – Start Your Trial Now!
Science
Earth Science
In Excel, create the standard atmosphere table in SI units from 0 to 20,000 m using an interval of 50 m. You are creating the standard atmosphere using the equations from the lecture and textbook. Your table will include geometric altitude, geopotential altitude, temperature, pressure, and density. Use a lapse rate of a = -6.5 x 10-3 K/m for the gradient layer from 0 to 11,000 m in geopotential altitude. Make sure your Excel sheet is labeled clearly so the instructor can understand what you did. Include in your Excel file three plots: 1. Temperature vs altitude 2. Pressure vs altitude 3. Density vs altitude Make sure to label each axis and include the units. The title of each plots must include your name.

In Excel, create the standard atmosphere table in SI units from 0 to 20,000 m using an interval of 50 m. You are creating the standard atmosphere using the equations from the lecture and textbook. Your table will include geometric altitude, geopotential altitude, temperature, pressure, and density. Use a lapse rate of a = -6.5 x 10-3 K/m for the gradient layer from 0 to 11,000 m in geopotential altitude. Make sure your Excel sheet is labeled clearly so the instructor can understand what you did. Include in your Excel file three plots: 1. Temperature vs altitude 2. Pressure vs altitude 3. Density vs altitude Make sure to label each axis and include the units. The title of each plots must include your name.

Applications and Investigations in Earth Science (9th Edition)
Applications and Investigations in Earth Science (9th Edition)
9th Edition
ISBN:9780134746241
Author:Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Chapter1: The Study Of Minerals
Section: Chapter Questions
Problem 1LR
See similar textbooks
icon
Related questions
Question
In Excel, create the standard atmosphere table in SI units from 0 to 20,000 m using an interval of 50 m. You are creating the standard atmosphere using the equations from the lecture and textbook. Your table will include geometric altitude, geopotential altitude, temperature, pressure, and density. Use a lapse rate of a = -6.5 x 10-3 K/m for the gradient layer from 0 to 11,000 m in geopotential altitude. Make sure your Excel sheet is labeled clearly so the instructor can understand what you did. Include in your Excel file three plots: 1. Temperature vs altitude 2. Pressure vs altitude 3. Density vs altitude Make sure to label each axis and include the units. The title of each plots must include your name.
Transcribed Image Text:In Excel, create the standard atmosphere table in SI units from 0 to 20,000 m using an interval of 50 m. You are creating the standard atmosphere using the equations from the lecture and textbook. Your table will include geometric altitude, geopotential altitude, temperature, pressure, and density. Use a lapse rate of a = -6.5 x 10-3 K/m for the gradient layer from 0 to 11,000 m in geopotential altitude. Make sure your Excel sheet is labeled clearly so the instructor can understand what you did. Include in your Excel file three plots: 1. Temperature vs altitude 2. Pressure vs altitude 3. Density vs altitude Make sure to label each axis and include the units. The title of each plots must include your name.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Applications and Investigations in Earth Science …
Applications and Investigations in Earth Science …
Earth Science
ISBN:
9780134746241
Author:
Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:
PEARSON
Exercises for Weather & Climate (9th Edition)
Exercises for Weather & Climate (9th Edition)
Earth Science
ISBN:
9780134041360
Author:
Greg Carbone
Publisher:
PEARSON
Environmental Science
Environmental Science
Earth Science
ISBN:
9781260153125
Author:
William P Cunningham Prof., Mary Ann Cunningham Professor
Publisher:
McGraw-Hill Education
Earth Science (15th Edition)
Earth Science (15th Edition)
Earth Science
ISBN:
9780134543536
Author:
Edward J. Tarbuck, Frederick K. Lutgens, Dennis G. Tasa
Publisher:
PEARSON
Environmental Science (MindTap Course List)
Environmental Science (MindTap Course List)
Earth Science
ISBN:
9781337569613
Author:
G. Tyler Miller, Scott Spoolman
Publisher:
Cengage Learning
Physical Geology
Physical Geology
Earth Science
ISBN:
9781259916823
Author:
Plummer, Charles C., CARLSON, Diane H., Hammersley, Lisa
Publisher:
Mcgraw-hill Education,
SEE MORE TEXTBOOKS