Start digging out the car. Depending on your personal strength, the amount of snow piled up on a car, and the temperature, this task can take anywhere from 5 minutes to an hour. It will be much faster if you can get a helper or two on the job.
Select the input range and the bin range. The input range is the range of cells that contain data. If your input data is a set of ten numbers, and you have copied it into the A column (from A1 to A10), then enter your data range as A1:A10. The bin range is the range of cells that contain your bin numbers.
The range of data values for which you want to calculate the specified quartile. quart. An integer between 0 and 4, representing the required quartile. If the requested quartile falls between two of the values in the supplied array, Excel interpolates between these values to calculate the quartile value. The 4th quartile is the same as the 100th percentile (and is equal to the maximum value in the range).