Frecuency Distribution

users
#1

Hi all:

  Would you please help me with this ?

  If I have a number of data about some topic, how can I get the type of
distribution using the LibreOffice's formula ? How can I know if it is
normal, gamma, etc. ? There is a way ?

For example:

Year Inflation of CR
1977 5,24971553
1978 8,11274841
1979 13,15353384
1980 17,78618715
1981 65,09133166
1982 81,75212345
1983 10,70142566
1984 17,34945384
1985 10,9251405
1986 15,42534076
1987 16,42746458
1988 25,33576785
1989 9,95444378
1990 27,25437251
1991 25,31611285
1992 16,96883188
1993 9,04288357
1994 19,85608235
1995 22,56778373
1996 13,88867535
1997 11,20231467
1998 12,35570391
1999 10,11290162
2000 10,24738868
2001 10,95604456
2002 9,68294967
2003 9,86787054
2004 13,12895123
2005 14,07496016
2006 9,43371564
2007 10,80552431
2008 13,90233262
2009 4,04704133
2010 5,82431576
2011 4,73574866
2012 4,55053048
2013 3,67954067
2014 5,12718527
2015 -0,80758134
2016 0,7651911
2017 1,08546538

Thanks and regards,

#2

I thought I had an answer to this, but I'm afraid it works only if the 2000 figure ends "8878", not "8868".

Sorry.

Brian Barker

#3

Hi Brian, well, thank you for your answer

Regards,

#4

Hi Brian, well, thank you for your answer

My point, of course, was that it was sufficient - indeed, better - to explain that you had a table with consecutive integers in one column and real values in the other, rather than listing eighty-two values and asking readers to make that observation themselves.

If I have a number of data about some topic, how can I get the type of distribution using the LibreOffice's formula ? How can I know if it is normal, gamma, etc. ? There is a way ?

The simple answer is that your data will certainly match none of those distributions - at least, not precisely.

Think of a straight line: this can be defined exactly by two points. If you have three points, they will not - except by an impossible coincidence - lie on a straight line. But if you believe that your data should lie on a straight line, there are techniques that determine the straight line which probably misses all of your points but is in some sense the "best fit" to them.

Similarly, your analytic distributions will be definable by a small number of points - certainly a lot less than your forty-one. So the best you can do is to attempt to fit various distributions to your data and also to discover how good the fit is in each case. That might help you to see which distribution the data fits best. But a better logic would be to decide from the nature of your data - what it represents - which distribution is likely, and then to fit the data to such a distribution (if that is necessary).

In any case, Calc does not appear to have any functionality that would help you here, but you will certainly be able to build formulae to achieve what you want in Calc once you have unearthed the relevant mathematics. That will surely be out there on the web.

I trust this helps.

Brian Barker

#5

Hi Brian:

  I've searched information in the web but usually it is more complex
than my knowledge can evaluate. For example, in Wikipedia found
https://en.wikipedia.org/wiki/Beta_distribution, but it so deep for me,
but show some graph with different values of Beta and Alpha that could
help me.

  I found some others like this, easier to understand the information:

https://stats.stackexchange.com/questions/47771/what-is-the-intuition-behind-beta-distribution

  And found a program named "SciDavies" that could help me too.

  But the major problem to me is my knowledge in statistics. It is not to
deep, although I already found some books that could help me too.

  In general, when I made my question about it, I was trying to find a
way to make the process easier and fast to me.

  Thank you very much because you try to help me, and clear me that
LibreOffice can't help with its formulas to solve my problem directly.

Regards,