User Tools

Site Tools


statisticsfuctions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
statisticsfuctions [2015/09/14 06:28]
mwagner
statisticsfuctions [2015/09/14 06:52] (current)
mwagner Added PEARSON-Function
Line 6: Line 6:
  
 I don't know if Postgres has a similar fuction built in but it does have some statistics functions which can be used right on the database-server side. I don't know if Postgres has a similar fuction built in but it does have some statistics functions which can be used right on the database-server side.
 +
 +I am assuming this is also the way amazon.com determines which rank a particular book has in.
  
 Feel free to grab the demo sheet from http://​www.tapwag.org/​Rank_Demo.ods Feel free to grab the demo sheet from http://​www.tapwag.org/​Rank_Demo.ods
 +
 +===== PEARSON-Function =====
 +
 +This fuction determines if a two data sets are interrelated. As an example you might run a company which has different sales outlets (e.g. Apple stores) which have a certain size and produce a certain amount of turnover. You might as yourself if the size of the store and the turnover are interrelated. In short words: If I create bigger stores, will they produce more turnover taking these two factors into account?
 +
 +The Syntax is quite simple:
 +**=PEARSON(Matrix1;​Matrix2)**
 +
 +Again, I have set up a demo sheet at http://​www.tapwag.org/​Pearson_Demo.ods
statisticsfuctions.txt ยท Last modified: 2015/09/14 06:52 by mwagner