Naturally, in a hot, preferably dry, summer season, chili peppers are happy garden residents. They flower in mid-summer and continue bearing until frost. With very little help, they produce a boatload of chilies.
In statistics, quartiles are three points that divide the data set into four equal groups. Each group represents the one-fourth of the data set. First quartile (Q 1), also known as lower quartile, splits the lower 25% of data. It is the middle value of lower half. Second quartile (Q 2) which is more commonly known as median splits the data in half (50%). Median divides the data into a lower half and an upper half. Third quartile (Q 3), also known as upper quartile, splits lowest 75% (or highest 25%) of data.
The Microsoft Excel QUARTILE function returns the quartile from a set of values. The QUARTILE function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the QUARTILE function can be entered as part of a formula in a cell of a worksheet.