At sea level, average atmospheric pressure is about 14.7 pounds per square inch

Question

At sea level, average atmospheric pressure is about 14.7 pounds per
square inch (psi). At altitude, pressure decreases. As the pressure
decreases, there are fewer air molecules in a given volume. Therefore,
baseballs fly farther at Coors Field in Denver (elevation = 5280 feet) than
at sea level, and it is very difficult to breathe on Mt. Everest (elevation =
29,035 feet). Create a spreadsheet that allows a user to input an elevation
between

0 and 50,000 feet and estimates the atmospheric pressure based on
Table P2.19. Use linear interpolation to estimate values between the
data points shown in the table. If a value of less than a or greater than
50,000 feet is entered, then "Out of Range" should be displayed in the
spreadsheet.

Table P2.19 Air Pressure as a Function of Altitude


Altitude, feet
o
1,000
2,000
3,000
4,000
5,000
10,000
20,000
30,000
40,000
50,000

Air Pressure, psi

14.70
14.16
13.66
13.17
12.69
12.23
10.10
6.76
4.37
2.73
1.69

I am looking my answer in excel spreed sheet. thanks

Explanation / Answer

paste it in excel for perfect view Requested altitude 50000 Altitude, feet Air pressure, psi Calculated air pressure % of sea level 0 14.7 1,000 14.16 2,000 13.66 3,000 13.17 4,000 12.69 5,000 12.23 10,000 10.1 20,000 6.76 30,000 4.37 40,000 2.73 50,000 1.69 1.69 11%

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.