Re: [sqlite] Is it possible to use SQLITE to calculate the streakedness of numeric data?

2013-02-19 Thread Frank Chang
joe.fis...@tanguaylab.com, Michael Black, Marc L. Allen, and Simon Slavin, Our software architect defined data streakedness based upon Chauvenet's criterion. Thank you for all of your help. In statistical theory, *Chauvenet's criterion* (named for William Chauvenet

Re: [sqlite] Is it possible to use SQLITE to calculate the streakedness of numeric data?

2013-02-19 Thread Frank Chang
joe.fis...@tanguaylab.com, Michael Black, Marc. L Allen and Simon Slavin, Thank you for your help in helping me to convince our company's software architect that it is possible to calculate the streakedness of numeric data. ___ sqlite-users mailing lis

Re: [sqlite] Is it possible to use SQLITE to calculate the streakedness of numeric data?

2013-02-18 Thread Michael Black
sers@sqlite.org Subject: [sqlite] Is it possible to use SQLITE to calculate the streakedness of numeric data? Would anyone know how to use SQLITE to calculate the streakedness of data? The definition of streakedness is how many deviations away from the mean(i.e running average a numerical data strea

Re: [sqlite] Is it possible to use SQLITE to calculate the, streakedness of numeric data?

2013-02-18 Thread joe.fis...@tanguaylab.com
Frank, Don't really understand your question. Should be no problem to calculate anything once. Just write your algorithm. The problem comes in when you try to calculate it for a set of data. SQLite like MySQL doesn't have SQL 2003/2008 Window Functions. Oracle recently stated they will not be

[sqlite] Is it possible to use SQLITE to calculate the streakedness of numeric data?

2013-02-18 Thread Frank Chang
Would anyone know how to use SQLITE to calculate the streakedness of data? The definition of streakedness is how many deviations away from the mean(i.e running average a numerical data streak is Thank you for your help. A variable R can be used to indicate how many deviations away from the mean a