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));
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.