Matches in SemOpenAlex for { <https://semopenalex.org/work/W943834288> ?p ?o ?g. }
Showing items 1 to 70 of
70
with 100 items per page.
- W943834288 endingPage "593" @default.
- W943834288 startingPage "555" @default.
- W943834288 abstract "This chapter focuses on the use of descriptive statistics in SQL. The simple mean is built into SQL as the AVG() aggregate function, whereas the median is the average of the highest value in the lower half and the lowest value in the upper half. The median is not a common vendor extension in SQL implementations. However, the variance and standard deviation are quite common, as they are much easier to calculate. The standard deviation is a measure of how far away from the average the values in a normally distributed population are situated. It is difficult to calculate it in SQL, as it involves a square root and standard SQL has only the basic four arithmetic operators. The usual trick is then to load the raw data into an appropriate host language, such as FORTRAN, and perform the work there. The variance is defined as the standard deviation squared, so one can avoid taking a square root and keep the calculations in pure SQL. One can calculate the average deviation if he has a version of SQL with an absolute value function, ABS(). A crosstabulation, or crosstabs for short, is a common statistical report that can be performed in IBM's QMF tool, by using the ACROSS summary option, and in many other SQL-based reporting packages. Many spreadsheets can load the results of SQL queries and perform a crosstabs within the spreadsheet." @default.
- W943834288 created "2016-06-24" @default.
- W943834288 creator A5066287408 @default.
- W943834288 date "2011-01-01" @default.
- W943834288 modified "2023-09-26" @default.
- W943834288 title "Descriptive Statistics in SQL" @default.
- W943834288 doi "https://doi.org/10.1016/b978-0-12-382022-8.00031-4" @default.
- W943834288 hasPublicationYear "2011" @default.
- W943834288 type Work @default.
- W943834288 sameAs 943834288 @default.
- W943834288 citedByCount "0" @default.
- W943834288 crossrefType "book-chapter" @default.
- W943834288 hasAuthorship W943834288A5066287408 @default.
- W943834288 hasConcept C105795698 @default.
- W943834288 hasConcept C121955636 @default.
- W943834288 hasConcept C144133560 @default.
- W943834288 hasConcept C171250308 @default.
- W943834288 hasConcept C192562407 @default.
- W943834288 hasConcept C196083921 @default.
- W943834288 hasConcept C199360897 @default.
- W943834288 hasConcept C22679943 @default.
- W943834288 hasConcept C2778241615 @default.
- W943834288 hasConcept C33923547 @default.
- W943834288 hasConcept C41008148 @default.
- W943834288 hasConcept C510870499 @default.
- W943834288 hasConcept C70388272 @default.
- W943834288 hasConcept C77088390 @default.
- W943834288 hasConceptScore W943834288C105795698 @default.
- W943834288 hasConceptScore W943834288C121955636 @default.
- W943834288 hasConceptScore W943834288C144133560 @default.
- W943834288 hasConceptScore W943834288C171250308 @default.
- W943834288 hasConceptScore W943834288C192562407 @default.
- W943834288 hasConceptScore W943834288C196083921 @default.
- W943834288 hasConceptScore W943834288C199360897 @default.
- W943834288 hasConceptScore W943834288C22679943 @default.
- W943834288 hasConceptScore W943834288C2778241615 @default.
- W943834288 hasConceptScore W943834288C33923547 @default.
- W943834288 hasConceptScore W943834288C41008148 @default.
- W943834288 hasConceptScore W943834288C510870499 @default.
- W943834288 hasConceptScore W943834288C70388272 @default.
- W943834288 hasConceptScore W943834288C77088390 @default.
- W943834288 hasLocation W9438342881 @default.
- W943834288 hasOpenAccess W943834288 @default.
- W943834288 hasPrimaryLocation W9438342881 @default.
- W943834288 hasRelatedWork W1490568028 @default.
- W943834288 hasRelatedWork W1530849343 @default.
- W943834288 hasRelatedWork W1764389895 @default.
- W943834288 hasRelatedWork W180883346 @default.
- W943834288 hasRelatedWork W1929580575 @default.
- W943834288 hasRelatedWork W1964932403 @default.
- W943834288 hasRelatedWork W1973968234 @default.
- W943834288 hasRelatedWork W1998275721 @default.
- W943834288 hasRelatedWork W2035766551 @default.
- W943834288 hasRelatedWork W2125467704 @default.
- W943834288 hasRelatedWork W2184639510 @default.
- W943834288 hasRelatedWork W2353978291 @default.
- W943834288 hasRelatedWork W2354435599 @default.
- W943834288 hasRelatedWork W241264472 @default.
- W943834288 hasRelatedWork W2993904653 @default.
- W943834288 hasRelatedWork W3023102804 @default.
- W943834288 hasRelatedWork W3125453682 @default.
- W943834288 hasRelatedWork W579489894 @default.
- W943834288 hasRelatedWork W759763707 @default.
- W943834288 hasRelatedWork W2577969177 @default.
- W943834288 isParatext "false" @default.
- W943834288 isRetracted "false" @default.
- W943834288 magId "943834288" @default.
- W943834288 workType "book-chapter" @default.