There are other functions, like GEOMEAN, HARMEAN, and TRIMMEAN which give the geometric mean, the harmonic mean and the trimmed mean (excluding a portion of highest and lowest values) of their arguments. MODE returns the most frequent value of its list of arguments.MEDIAN returns the median value (the value at the 50th percentile) of its respective list of arguments.AVERAGE returns the mean average of its list of arguments.MInd you, I am not going to provide a full “Statistics using Calc” guide here, I just want to suggest a few statistical functions for basic descriptive and inferential statistics. There is also OOo_Stat, an external add-in, that you can include to assist you with your analyses. of statistical (and other types of) functions that you can use. Calc has a considerable variety of functions documented in the openoffice wiki. However, for those who need or have to (or … whatever), here are some very very basic info on using statistical functions in Calc. R can be found at one of its many mirrors. Although, I wouldn’t recommend doing so since there are other, better software packages to complete simple and complex statistical analyses, such as R, a statistical programming language and environment with excellent analysis and graph capabilities. I don’t know why, but, occasionally, people may have to do minimal or even considerable statistical calculations using Calc, the ‘s spreadsheet part of the Office Productivity Suite.
0 kommentar(er)
