|
Thanks it worked. Regards, Ujjwal 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-arrayAfter 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.... AndreasRegards, 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.) AndreasDisclaimer :- 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-listDisclaimer :- 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. |