Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

8. *When a person stands in the wind, the air feels colder than when the air is

ID: 3028127 • Letter: 8

Question

8. *When a person stands in the wind, the air feels colder than when the air is still. The apparent temperature iscalled the windchill (Twe) and is computed from the formula shown in Figure 2.29 where Ta is the air temperature. The values shown for parameters athrough dare for degrees Celsius computations. Ta is the air temperature and the wind velocity. For Fahrenheit computations, use 35.74, 0.6215, -35.75, and 0.4275 for the parameters and express V in mph. The cells B4:B7 have been named by the letters to the right. What formula can be used in E5 such that it can be filled down and across to make the table? Be careful with the name for the cell B6. Can you easily modify your worksheet for Fahrenheit work?

Explanation / Answer

Formula which can be used is :

windchill = (35.74 + 0.6215 * temp - 35.75 * Math.pow(wind,0.16) + 0.4275 * temp * Math.pow(wind,0.16));

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote