Re: Gnumeric: Help Required



Can we draw the bell shaped histogram (Normal Graph).

Regards,
Ujjwal Joshi

On 02/01/2012 7:52 PM, Andreas Guelzow wrote:
On Mon, 2012-01-02 at 19:18 +0530, Ujjwal Joshi wrote:
Thanks for the feedback I was using Anderson Darling test form the
functions option.
If you want to see the array value returned by an array function you
need to enter it as an array function. See
http://projects.gnome.org/gnumeric/doc/sect-data-formulas.shtml#sect-data-formulas-array

 After your response I tried the Normality Test option in the menu.


Can we have a trend line (straight line) on the data points to know
how much every data point is deviating from the straight line?
I am not quite sure about hte mathematical meaning of the "how much" but
of course you can add a trendline to the plot. In the properties dialog,
select the series and "Add" a trend line....

Andreas
Regards,
Ujjwal Joshi

On 02/01/2012 7:06 PM, Andreas Guelzow wrote: 
Are you using a tool from the statistics menu or are you using the
attest function directly? In the latter case you need to enter it as
an array function.


Please describe in more detail what you are doing.


Andreas 

A J Guelzow 



On 2012-01-02, at 6:15, Ujjwal Joshi <ujjwal joshi newgen co in>
wrote:


When I am doing Anderson Darling Test in the tool it is giving a
single value, but as per the help file, this function returns an
array with the first row giving the p-value of the
Anderson-Darling Test, the second row the test statistic of the
test, and the third the number of observations in the sample.

Please comment.

Regards,
Ujjwal Joshi

On 28/12/2011 1:37 PM, Jean Brefort wrote: 
Insert/Chart... then select Statistics in the plot families list, the
supported plot types should appear.
You might first select the data before selecting the menu item.

Regards,
Jean

Le mercredi 28 décembre 2011 à 09:41 +0530, Ujjwal Joshi a écrit :
How can we draw a box plot in gnumeric?

Regards,
Ujjwal Joshi

On 23/12/2011 12:35 AM, Andreas Guelzow wrote: 
On Thu, 2011-12-22 at 17:20 +0530, Ujjwal Joshi wrote:
I am working in a software company and we were in the process of
selecting an open source for statistical analysis. I have tried to
list down the statistical analysis/tools that are required in our
profile/job and then mapped it to gnumeric to know whether this toll
furnishes all our requirements.
Would request you to go through the document and let me know incase I
have missed out some feature(s) in guneric, also would appreciate
in-case you can suggest some open source tool that will cater all are
requirements. 
The primary open source statistics tool is the R-project. So for
hardcore statistical needs you may want to use that.

Nevertheless you missed some Gnumeric features.
2
Scatter
Plot
available in insert->chart






3
Box
Plot
available in insert->chart






4
Probability and Probability Distribution Plots
some
are
available in insert->chart






14
Hypothesis Testing
Lots of
hypothesis testing tools are available in Gnumeric. You need to be more specific.






14.3
F test
Statistics->TwoSampleTests->TwoVariances:FTest






14.4
Simple
t-test
Easily
done
using
TTEST
function






14.5
Paired
t-test
Statistics->TwoSampleTests->TwoMeans->...







Since Gnumeric is a spreadsheet program lots of the rest can probably be
easily constructed. (All the Statistics-> items are really constructed
from existing sheet functions.)

Andreas
Disclaimer :- This e-mail and any attachment may contain confidential,
proprietary or legally privileged information. If you are not the
original intended recipient and have erroneously received this
message, you are prohibited from using, copying, altering or
disclosing the content of this message. Please delete it immediately
and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts
no responsibilities for loss or damage arising from the use of the
information transmitted by this email including damages from virus and
further acknowledges that no binding nature of the message shall be
implied or assumed unless the sender does so expressly with due
authority of NSTL.

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Disclaimer :- This e-mail and any attachment may contain
confidential, proprietary or legally privileged information. If
you are not the original intended recipient and have erroneously
received this message, you are prohibited from using, copying,
altering or disclosing the content of this message. Please delete
it immediately and notify the sender. Newgen Software Technologies
Ltd (NSTL) accepts no responsibilities for loss or damage arising
from the use of the information transmitted by this email
including damages from virus and further acknowledges that no
binding nature of the message shall be implied or assumed unless
the sender does so expressly with due authority of NSTL. 



Disclaimer :- This e-mail and any attachment may contain confidential,
proprietary or legally privileged information. If you are not the
original intended recipient and have erroneously received this
message, you are prohibited from using, copying, altering or
disclosing the content of this message. Please delete it immediately
and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts
no responsibilities for loss or damage arising from the use of the
information transmitted by this email including damages from virus and
further acknowledges that no binding nature of the message shall be
implied or assumed unless the sender does so expressly with due
authority of NSTL.


    

Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.



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