The wind chill index is a calculation that describes the combined effect of the wind and cold temperatures on exposed skin. For example if the temperature is 20 degrees and the wind is blowing at 20 miles per hour, the wind chill index is –10 degrees. The official NOAA formula to calculate wind chill is:
Wind chill = 35.74 + 0.6215T – 35.75(V0.16)+0.4275T(V0.16)
- University of Wisconsin Eau-Claire: Excel References Relative and Absolute.
- YouTube Video: Mixed References in Excel
Wind Chill chart
- To the right of the Temp cell change the number from 15 to 40. Aside from the obvious that the wind chill is warmer, what overall pattern do you observe?
- Keep testing different temperatures and determine the approximate temperature that brings the windchill lines closest together.
- What is your general observation of the lines at this temperature?