Help:Quartilupper.exc format

From semantic-mediawiki.org
Quartilupper.exc format
Calculates the upper quartile in queried numerical data
Further Information
Provided by: Extension "Semantic Result Formats"
Added: 3.2.0
Removed: still supported
Requirements: none
Format name: quartilupper.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 quartilupper.exc, part of extension "Semantic Result Formats"Provides additional formats for semantic queries, can be used to display the upper quartile (75th 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 quartilupper. 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 second quartile (Q3 = 75th percentile)
Max maximum value (largest observation)

Parameters

This result format does not provide format specific parameters.

Example[edit]

Syntax
{{#ask:
 [[Category:City]]
 |?Population
 |format=quartileupper.exc
}}
Result
 PopulationThe number of inhabitants of some geographical place.
2166320938 5cfc9ec72a z.jpg
220px-Cherry Blossoms and Washington Monument.jpg
3363305632 c136da22e7 z.jpg
3430830083 00768b46a9 z.jpg
4005745212 1e91b077cf z.jpg
40564870 7c39a94ac4 z.jpg
5072461976 666f3c8817 o.jpg
5208218415 e2361c0c43 z.jpg
5684653514 4bf9d1c137 b.jpg
59104081 3307425c2c z.jpg
6140285934 02e81b845f z.jpg
Amsterdam783,364
Amsterdam - Waag.jpg
Belvue.jpg
Berlin3,520,061
Calsbad-late-night.jpg
Cologne1,080,394
Frankfurt679,664
Fresno
Greenwich
Karlsruhe294,761
Karlsruher Pyramide.JPG
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,888,776
Warsaw1,720,398
Würzburg126,635

(verify)

See also[edit]

PageFormatDescriptionProvided byAdded inEnabled
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
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


Note[edit]