Re: Request for url to download Gnumeric 1.10.17



On Fri, 2012-02-24 at 14:51 +0530, Ujjwal Joshi wrote:
Do we have Probability Distribution Plots in gnumeric?

Well, Gnumeric is designed to plot data, but it is pretty simple to
persuade it to plot distributions provided you have current git.

Add a chart,
xy-plot with smoothed lines (third subtype on the second row)
select Series1
(X): row(Sheet1!$A$1:$A$1000)/40
Y:   r.dchisq(row(Sheet1!$A$1:$A$1000)/40,10)

This gives you the density curve of the chisq distribution with 10
degrees of freedom.


If you have Gnumeric 1.10.17 or 1.11.1 only, you can create a column
(A1:A1000) of numbers =row()/40
and a column (B1:B1000) of numbers
=r.dchisq(A1)/40,10) (in B1 dragged down to B1000)
and then use the range A1:A1000 for (X) and B1:B1000 for (Y).

Andreas


-- 
Andreas Guelzow <aguelzow pyrshep ca>




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]