User:Máté/ratings/studios
Jump to navigation
Jump to search
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT ?item ?avg ((sum((?age-?avg)*(?age-?avg))/(count(?age)-1)) AS ?var) (count(distinct ?film) AS ?films) (count(?age) AS ?ratings) WHERE { [] wdt:P31 wd:Q24716199; wikibase:directClaim ?p . ?film wdt:P31/wdt:P279* wd:Q11424; wdt:P272 ?item; ?p [ wdt:P2899 ?age ] . { SELECT ?item (avg(?age) AS ?avg) WHERE { [] wdt:P31 wd:Q24716199; wikibase:directClaim ?p . ?film wdt:P31/wdt:P279* wd:Q11424; wdt:P272 ?item; ?p [ wdt:P2899 ?age ] . } GROUP BY ?item } } GROUP BY ?item ?avg ORDER BY DESC(?ratings) DESC(?films) ASC(?var) ?item LIMIT 25| Studios | Mean | SD of sample | Films | Ratings |
|---|---|---|---|---|
| Walt Disney Pictures | 3.8 [3.8; 3.9] | 4.71 | 322 | 4,763 |
| Warner Bros. | 8.8 [8.7; 8.9] | 6.10 | 612 | 4,109 |
| Columbia Pictures | 7.6 [7.5; 7.7] | 6.34 | 488 | 3,447 |
| 20th Century Studios | 8.8 [8.7; 9.0] | 6.26 | 571 | 3,205 |
| Universal Pictures | 8.9 [8.8; 9.0] | 6.36 | 543 | 3,155 |
| Paramount Pictures | 9.2 [9.1; 9.3] | 6.00 | 510 | 2,854 |
| Pixar | 2.4 [2.4; 2.5] | 3.52 | 64 | 2,006 |
| DreamWorks Animation | 3.0 [2.9; 3.1] | 3.98 | 56 | 1,869 |
| Metro-Goldwyn-Mayer | 8.3 [8.2; 8.5] | 6.44 | 428 | 1,527 |
| New Line Cinema | 11.1 [10.9; 11.2] | 5.37 | 213 | 1,437 |
| Sony Pictures Animation | 3.2 [3.0; 3.3] | 4.23 | 33 | 1,272 |
| Legendary Pictures | 9.7 [9.6; 9.9] | 5.25 | 63 | 1,219 |
| Village Roadshow Pictures | 9.2 [9.0; 9.3] | 5.79 | 103 | 1,118 |
| Marvel Studios | 9.3 [9.1; 9.4] | 4.89 | 38 | 1,111 |
| RatPac-Dune Entertainment | 9.3 [9.1; 9.5] | 5.97 | 55 | 1,090 |
| StudioCanal | 8.5 [8.3; 8.7] | 6.41 | 202 | 1,065 |
| Walt Disney Animation Studios | 2.6 [2.5; 2.8] | 3.72 | 65 | 981 |
| Lionsgate | 11.6 [11.4; 11.8] | 5.56 | 134 | 926 |
| Illumination | 2.9 [2.8; 3.0] | 4.16 | 14 | 890 |
| Amblin Entertainment | 7.2 [7.0; 7.4] | 5.77 | 85 | 856 |
| Warner Bros. Pictures | 9.5 [9.2; 9.7] | 6.05 | 128 | 812 |
| Touchstone Pictures | 8.0 [7.8; 8.2] | 6.12 | 203 | 793 |
| The Walt Disney Company | 4.0 [3.9; 4.2] | 4.65 | 212 | 787 |
| Relativity Media | 10.0 [9.8; 10.2] | 5.84 | 125 | 786 |
| Summit Entertainment | 10.5 [10.3; 10.7] | 5.37 | 71 | 768 |
End of automatically generated list.