Help:Quartillower.exc format

Quartillower.exc format
Calculates the lower quartile in queried numerical data
Further Information
Provided by:	Extension "Semantic Result Formats"
Added:	3.2.0
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:	Florian Breitenlacher
Categories:	math
Table of 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) 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. To include it, use quartillower. It corresponds to the Excel function QUARTILE.EXC

Together with other result formats, SMW is able to provide the five-number summary (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.
Amsterdam	783,364
Berlin	3,520,061
Cologne	1,080,394
Frankfurt	679,664
Fresno
Greenwich
Karlsruhe	294,761
London	7,825,200
Munich	1,353,186
New York City	8,175,000
Paris	2,234,105
Porto	237.584
Rome	2,761,477
San Diego	1,307,402
San Francisco
Stuttgart	606,588
Sydney	4,575,532
Texas/Austin
Texas/Dallas
Texas/San Antonio
Tokyo	8,967,665
Vienna	1,897 1,888,776
Warsaw	1,720,398
Würzburg	126,635

^(verify)

See also

Page	Format	Description	Provided by	Added in	Enabled
Average format	average	Displays the average of all queried numerical data	Semantic Result Formats	1.4.2	true
Count format	count	Returns just the number of results, instead of the results themselves.	Semantic MediaWiki	0.7	true
Interquartilemean format	interquartilemean	Calculates the interquartile mean in queried numerical data	Semantic Result Formats	3.2.0	true
Interquartilerange.exc format	interquartilerange.exc	Calculates the interquartile range in queried numerical data	Semantic Result Formats	3.2.0	true
Interquartilerange format	interquartilerange	Calculates the interquartile range in queried numerical data	Semantic Result Formats	3.2.0	true
Max format	max	Displays the maximum of all queried numerical data	Semantic Result Formats	1.4.2	true
Median format	median	Displays the median of all queried numerical data	Semantic Result Formats	1.6.0	true
Min format	min	Displays the minimum of all queried numerical data	Semantic Result Formats	1.4.2	true
Mode format	mode	Displays the value appearing most often in queried numerical data	Semantic Result Formats	3.2.0	true
Product format	product	Displays the product of all queried numerical data	Semantic Result Formats	1.6.0	true
Quartillower format	quartillower	Calculates the lower quartile in queried numerical data	Semantic Result Formats	3.2.0	true
Quartillower.exc format	quartillower.exc	Calculates the lower quartile in queried numerical data	Semantic Result Formats	3.2.0	true
Quartilupper format	quartilupper	Calculates the upper quartile in queried numerical data	Semantic Result Formats	3.2.0	true
Quartilupper.exc format	quartilupper.exc	Calculates the upper quartile in queried numerical data	Semantic Result Formats	3.2.0	true
Range format	range	Calculates the range in queried numerical data	Semantic Result Formats	3.2.0	true
Samplestandarddeviation format	samplestandarddeviation	Calculates the samplestandarddeviation in queried numerical data	Semantic Result Formats	3.2.0	true
Standarddeviation format	standarddeviation	Calculates the standarddeviation in queried numerical data	Semantic Result Formats	3.2.0	true
Sum format	sum	Displays the sum of all queried numerical data	Semantic Result Formats	1.4.2	true
Variance format	variance	Displays the variance in queried numerical data	Semantic Result Formats	3.2.0	true
Samplevariance format	samplevariance	Displays the sample variance in queried numerical data	Semantic Result Formats	3.2.0	true