How can I use average and gusting speeds to graphically display the wind deviation as a function of time?
With time included in the problem, we have added another degree of freedom. A 3-dimensional graph serves well in this case. Time will be on one axis, wind on another, and the probability will be plotted on the vertical (z-axis). After collecting three of more reports of wind and gusting speeds and noting the time, we can add to figure 2s spreadsheet these data in rows 4 and 5 and replicate the NORMDIST function in cells D4 to P5. Your spreadsheet software should then allow you to select all of the probability data points plus the wind speeds and the time axis data. Then it is a matter of working with the graphing keys to produce three-dimensional line graphs or surface maps. Be creative when exploring the graph functions. Try selecting the corners of the graph box and rotating the graph to look down the time axis or the wind speed axis as shown.
