# Help:Quartillower.exc format

Quartillower.exc format
Calculates the lower quartile in queried numerical data
Further Information
Provided by: Extension "Semantic Result Formats"
Removed: still supported
Requirements: none
Format name: quartillower.exc
Enabled? Indicates whether the result format is enabled by default upon installation of the respective extension. yes
Authors:
Categories: math

## Contents

The result format quartillower.exc, part of extension "Semantic Result Formats"Provides additional formats for semantic queries, can be used to display the lower quartile (25th percentile) [1] of all numerical values in the result. If there are an odd number of data points in the original ordered data set, it excludes the median.[2] To include it, use quartillower. It corresponds to the Excel function QUARTILE.EXC [3]

Together with other result formats, SMW is able to provide the five-number summary [4] (five most important sample percentiles):

 Min minimum value (smallest observation) Lower Quartile first quartile (Q1 = 25th percentile) Median middle value (Q2 = 50th percentile) Upper Quartile third quartile (Q3 = 75th percentile) Max maximum value (largest observation)

## Parameters

This result format does not provide format specific parameters.

## Example

Syntax
```{{#ask:
[[Category:City]]
|?Population
|format=quartilelower.exc
}}
```
Result
PopulationThe number of inhabitants of some geographical place.
Amsterdam783,364
Berlin3,520,061
Cologne1,080,394
Frankfurt679,664
Fresno
Greenwich
Karlsruhe294,761
London7,825,200
Munich1,353,186
New York City8,175,000
Paris2,234,105
Porto237.584
Rome2,761,477
San Diego1,307,402
San Francisco
Stuttgart606,588
Sydney4,575,532
Texas/Austin
Texas/Dallas
Texas/San Antonio
Tokyo8,967,665
Vienna1,897
1,888,776
Warsaw1,720,398
Würzburg126,635

(verify)

Average formataverageDisplays the average of all queried numerical dataSemantic Result Formats1.4.2true
Count formatcountReturns just the number of results, instead of the results themselves.Semantic MediaWiki0.7true
Interquartilemean formatinterquartilemeanCalculates the interquartile mean in queried numerical dataSemantic Result Formats3.2.0true
Interquartilerange.exc formatinterquartilerange.excCalculates the interquartile range in queried numerical dataSemantic Result Formats3.2.0true
Interquartilerange formatinterquartilerangeCalculates the interquartile range in queried numerical dataSemantic Result Formats3.2.0true
Max formatmaxDisplays the maximum of all queried numerical dataSemantic Result Formats1.4.2true
Median formatmedianDisplays the median of all queried numerical dataSemantic Result Formats1.6.0true
Min formatminDisplays the minimum of all queried numerical dataSemantic Result Formats1.4.2true
Mode formatmodeDisplays the value appearing most often in queried numerical dataSemantic Result Formats3.2.0true
Product formatproductDisplays the product of all queried numerical dataSemantic Result Formats1.6.0true
Quartillower formatquartillowerCalculates the lower quartile in queried numerical dataSemantic Result Formats3.2.0true
Quartillower.exc formatquartillower.excCalculates the lower quartile in queried numerical dataSemantic Result Formats3.2.0true
Quartilupper formatquartilupperCalculates the upper quartile in queried numerical dataSemantic Result Formats3.2.0true
Quartilupper.exc formatquartilupper.excCalculates the upper quartile in queried numerical dataSemantic Result Formats3.2.0true
Range formatrangeCalculates the range in queried numerical dataSemantic Result Formats3.2.0true
Samplestandarddeviation formatsamplestandarddeviationCalculates the samplestandarddeviation in queried numerical dataSemantic Result Formats3.2.0true
Standarddeviation formatstandarddeviationCalculates the standarddeviation in queried numerical dataSemantic Result Formats3.2.0true
Sum formatsumDisplays the sum of all queried numerical dataSemantic Result Formats1.4.2true
Variance formatvarianceDisplays the variance in queried numerical dataSemantic Result Formats3.2.0true
Samplevariance formatsamplevarianceDisplays the sample variance in queried numerical dataSemantic Result Formats3.2.0true