Using a Spreadsheet to Compute the Maximum Wind Sector 99.5th Percentile X/Q Value in Accordance with

Linda Vickers1

  • 1*U.S. Department of Energy NNSA Production Office (NPO), NPO-10 Jack Case Center, MS 8009, PO Box 2050, Oak Ridge, TN 37831.

Health Physics
|March 30, 2016
PubMed

Related Concept Videos

Design Example: Calculating Safe Diameter for Wind-Exposed Disc01:17

Design Example: Calculating Safe Diameter for Wind-Exposed Disc

Assessing safety in wind-exposed installations is crucial to preventing potential failures. This example explores the calculation and design adjustments needed to mount a circular disc on a building facade, where wind forces are a primary concern. A 4-meter diameter disc was initially designed as an aesthetic feature facing winds at a velocity of 25 meters per second, with an air density of 1.25 kilograms per cubic meter. Given these conditions, the drag force on the disc was determined using...
377
Microsoft Excel: Median, Quartile range, and Box Plots01:29

Microsoft Excel: Median, Quartile range, and Box Plots

In Microsoft Excel, calculating the median, interquartile range, and creating box plots can help understand the distribution of your data.
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...
4.0K
Standard Deviation of Calculated Results01:14

Standard Deviation of Calculated Results

Standard deviation measures the spread of data around the mean value. Many large data sets follow a Gaussian distribution, also known as a normal distribution. This distribution is bell-shaped curved, with the most frequently observed value (mean or central value) in the middle. The farther away from the central value, the greater the deviation from the central value, and the lower the frequency.
A broad Gaussian distribution curve has a wider standard deviation, representing a data set with...
9.0K
Percentile01:18

Percentile

A percentile indicates the relative standing of a data value when data are sorted into numerical order from smallest to largest. It represents the percentages of data values that are less than or equal to the pth percentile. For example, 15% of data values are less than or equal to the 15th percentile.
9.6K
5-Number Summary01:04

5-Number Summary

In a dataset, the 5-number summary includes the minimum data value, the data value of the first quartile, the median data value or data value of the second quartile, the data value of the third quartile, and the maximum data value. These 5 data values can be visualized as a box and whisker plot.
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...
6.1K
Quartile01:15

Quartile

Quartiles are numbers that separate the data into quarters. Quartiles may or may not be part of the data. To find the quartiles, first, find the median or second quartile. The first quartile, Q1, is the middle value of the lower half of the data, and the third quartile, Q3, is the middle value, or median, of the upper half of the data. To get the idea, consider the same data set:
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...
10.0K