( it is actually an excel problem , but I\'m stuck in the physics parts . can yo

Question

( it is actually an excel problem , but I'm stuck in the physics parts . can you just give the idea of doing each one , and I will do the rest since it is repeating the same equations more than one time ''thank u'' )


A person has decided to attempt to lose weight by trekking from the lowest location on earth, the Dead Sea with an elevation of -418m with respect to sea level, to the highest elevation on earth, Mount Everest with an 8839m elevation with respect to sea level. The trekker wants to know the variation of her total weight while walking upward. She plans to eat and drink just enough so that her body mass will remain the same (m = 50.0 kg) throughout the trip.

Assume the mass of the earth is M = 5.9742×10^24 kg, the mean radius of Earth at sea level is R = 6378.137 km, and the Universal Gravitational Constant is G = 6.67428×10^-11 m3/(kg·s2). Use Excel to calculate the trekker’s weight (in Newtons) as a function of elevation by performing the following tasks. Recall that the gravitational acceleration, g, is calculated by:


g=(MG)/(R^2) (1)

for the elevation, it goes from the lowest to highest elevation with 500m intervals, i.e. your elevations should be -418, 0, 500, 1000, … , 8500, 8839.

1- calculate the local radius of the earth at each elevation, calculate g at each elevation using Equation 1, and calculate the trekker’s weight at each elevation. Be sure to display the appropriate number of decimal places.

2-Calculate the percentage change in the trekker’s weight (compared to the sea level weight) at each elevation, using:

percent change = new value - value at sea level /( value at sea level ) (2)

Note that these values should be displayed as a percentage.


3-What is the absolute change in the trekker's weight at the top of Mt. Everest as compared to the Dead Sea?


4- The elevation of the valley floor in Salt Lake City is 1288 m above sea level, and the highest peak of Mt. Olympus is 2751 m above sea level. Calculate the absolute change in the trekker's weight if she now decides to hike to the top of Mt. Olympus from the valley floor, under the same conditions described above.

Explanation / Answer

find the force of gravity using the equation given at each altitude(R) (g=(MG)/(R^2) ) multiplying this value(g) by the known mass of the person, 50 kg, will give you the weight of the person at each altitude

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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