Related Experiment Video
Updated: Mar 23, 2026

Measurements of CO2 Fluxes at Non-Ideal Eddy Covariance Sites
Published on: June 24, 2019
Using a Spreadsheet to Compute the Maximum Wind Sector 99.5th Percentile X/Q Value in Accordance with
1*U.S. Department of Energy NNSA Production Office (NPO), NPO-10 Jack Case Center, MS 8009, PO Box 2050, Oak Ridge, TN 37831.
Abstract:
The U.S. Department of Energy Standard 3009-2014 requires one of two methods to determine the simple Gaussian relative concentration (X/Q) of pollutant at plume centerline downwind to a receptor for a 2-h exposure duration from a ground-level release (i.e., less than 10 m height) which are (1) the 99.5th percentile X/Q for the directionally-dependent method and (2) the 95th percentile X/Q for the directionally-independent method. This paper describes how to determine the simple Gaussian 99.5th percentile X/Q for the directionally-dependent method using an electronic spreadsheet. Refer to a previous paper to determine the simple Gaussian 95th percentile X/Q for the directionally-independent method using an electronic spreadsheet (Vickers 2015). The method described herein is simple, quick, accurate, and transparent because all of the data, calculations, and results are visible for validation and verification.
More Related Videos
Related Concept Videos
Design Example: Calculating Safe Diameter for Wind-Exposed Disc
Microsoft Excel: Median, Quartile range, and Box Plots
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which...
Standard Deviation of Calculated Results
A broad Gaussian distribution curve has a wider standard deviation, representing a data set with...
Percentile
5-Number Summary
In a box plot, the minimum and maximum data values represent the lower and upper whiskers in the graph, and the median is designated as the center of the box in the chart. The first quartile and third...
Quartile
1; 1; 2; 2; 4; 6; 6.8; 7.2; 8; 8.3; 9; 10; 10; 11.5
The median or second quartile is seven. The lower half of the...

