Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On 19/11/09 20:43, Terry Coles wrote: > On Thursday 19 Nov 2009, John Cooper wrote: >> and specifically http://www.ooomacros.org/user.php >> >> "This is a suite of macros to perform basic statistical analysis within >> OpenOffice. These macros give OpenOffice Calc the functionality which >> Analysis ToolPak gives Microsoft Excel, and many of these routines are >> unavailable in Excel." > > Hmmm. The docs specifically say that TTEST is supported, but when I opened > that suite of macros, I couldn't find it. Terry, I downloaded OOoStat_0.4.zip at http://sourceforge.net/projects/ooomacros/files/OOo%20Statistics/Version%200.4/OOoStat_0-4.zip/download Opened up the ZIP file and then OOoStatV0_4.sxc in OO v3.1 . It warned about macros being disabled so Tools/Options/OpenOffice.org/Security/Macro Security/Low and restart OpenOffice. Once opened click "INSTALL" and it will confirm installed ok. Click on bottom tab "ANOVA_1way" (next one after "Front"), select the cells containing :- Group Response A 0.98 B 0.75 C 0.61 B 1.19 C 0.61 C 1.1 A 1 B 0.9 A 1.42 C 0.69 C 0.49 B 1.75 A 1.42 A 1.25 A 1.85 B 0.9 B 0.4 C 0.16 A 1.47 A 1.31 Then Tools/Macros/Run Macro/OOoStatV0_4.sxc/OOoStat/Basic Stats/ANOVA_1Way/Run Which gave this output :- Group N MeanS.E.M. Sum squares Rank SumRS2/N A 8 1.340.1 14.83 121 1830.13 B 6 0.980.196.8158 560.67 C 6 0.610.122.6931 160.17 Total 20 1.010.1 24.33 210 2550.96 ANOVA Table Effect of Group Source SS df MS F p>F Kruskall-Wallis p>KW Between 1.822 0.917.580.0044 9.880.0071 Within 2.0417 0.12 Total 3.8619 0.2 -- -- Discover Linux - Open Source Solutions to Business and Schools http://discoverlinux.co.uk -- -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thu, 19 Nov 2009 22:14:01 -, Peter Merchant wrote: > Well, I'm blowed and need to retract this: > http://www.cl.cam.ac.uk/~mgk25/iso-time.html Big to small - same way time is written ;) -- Using Opera M2: http://www.opera.com/mail/ -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thu, 2009-11-19 at 20:43 +, Terry Coles wrote: > On Thursday 19 Nov 2009, John Cooper wrote: > > and specifically http://www.ooomacros.org/user.php > > > > "This is a suite of macros to perform basic statistical analysis within > > OpenOffice. These macros give OpenOffice Calc the functionality which > > Analysis ToolPak gives Microsoft Excel, and many of these routines are > > unavailable in Excel." > > Hmmm. The docs specifically say that TTEST is supported, but when I opened > that suite of macros, I couldn't find it. > > Becky has now worked out for herself that the tools in Excel calculate > multiple functions at once, whereas OOo only allows the functions to be > calculated piecemeal. It isn't a problem, but being a teenager, she'd rather > the tools did the work for her :-) > > Thanks everyone for trying to help. > > -- > Terry Coles > 64 bit computing with Kubuntu Linux > > Best wishes to her in her studies. I guess she'll soon be home for Christmas, and that'll bring a smile to Terry's face. On another front, I got a gentle reprimand the other day for expressing my dates in ascending order i.e. 19/11/2009, ala what I understood to be UK and Canadian standard, whereas my colleague wanted me to express them in ISO standard form. What brought this up was the expression of the date of the next meeting,and the date at the top of this, which is in damn-yankee form. Well, I'm blowed and need to retract this: http://www.cl.cam.ac.uk/~mgk25/iso-time.html my Colleague insisted that it was 19-Nov-2009. Peter M. -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thursday 19 Nov 2009, John Cooper wrote: > and specifically http://www.ooomacros.org/user.php > > "This is a suite of macros to perform basic statistical analysis within > OpenOffice. These macros give OpenOffice Calc the functionality which > Analysis ToolPak gives Microsoft Excel, and many of these routines are > unavailable in Excel." Hmmm. The docs specifically say that TTEST is supported, but when I opened that suite of macros, I couldn't find it. Becky has now worked out for herself that the tools in Excel calculate multiple functions at once, whereas OOo only allows the functions to be calculated piecemeal. It isn't a problem, but being a teenager, she'd rather the tools did the work for her :-) Thanks everyone for trying to help. -- Terry Coles 64 bit computing with Kubuntu Linux -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On 19/11/09 19:20, Terry Coles wrote: > Hi, > > My daughter has to do an assignment at Uni using a T-Test. Although the Uni > says that work can be submitted in Either MS or Open Office, they've only > told > her how to do it in Excel and she only has OpenOffice. > > Is there anyone out there who knows how to do this or knows how to find out? > I never did statistics, so I have no idea what to look for. > > I found this: > http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_TTEST_function, > but don't really know how to use it. Ideally, she needs a step-by-step guide > similar to the one provided by the Uni for Excel. > Terry, see this http://www.oooforum.org/forum/viewtopic.phtml?t=25147 and specifically http://www.ooomacros.org/user.php "This is a suite of macros to perform basic statistical analysis within OpenOffice. These macros give OpenOffice Calc the functionality which Analysis ToolPak gives Microsoft Excel, and many of these routines are unavailable in Excel." -- -- Discover Linux - Open Source Solutions to Business and Schools http://discoverlinux.co.uk -- -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thu, 19 Nov 2009 19:50:37 -, Peter Merchant wrote: > Gives the usual problem:- will she know if what she sees is correct? I suppose to answer that she could either run the test on her simpler input data she already has the answer for - or - she could try http://studentsttest.com/ Rob -- Using Opera M2: http://www.opera.com/mail/ -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thu, 2009-11-19 at 19:20 +, Terry Coles wrote: > Hi, > > My daughter has to do an assignment at Uni using a T-Test. Although the Uni > says that work can be submitted in Either MS or Open Office, they've only > told > her how to do it in Excel and she only has OpenOffice. > > Is there anyone out there who knows how to do this or knows how to find out? > I never did statistics, so I have no idea what to look for. > > I found this: > http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_TTEST_function, > but don't really know how to use it. Ideally, she needs a step-by-step guide > similar to the one provided by the Uni for Excel. > > -- > Terry Coles > 64 bit computing with Kubuntu Linux > > has she tried TTEST(a1:a21; b1:b21 ; 1 ; 1)0ne-tailed, paired samples as per the wiki reference? TTEST(data1 ; data2 ; mode; type) Gives the usual problem:- will she know if what she sees is correct? P. -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thursday 19 Nov 2009, Peter Merchant wrote: > 1. When is it due? Tomorrow afternoon (typical) :-) > 2. Can You send the Excel instructions? Done. -- Terry Coles 64 bit computing with Kubuntu Linux -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thursday 19 Nov 2009, Robert Bronsdon wrote: > Can you provide the instructions she has for doing it in Excel? It might > be pretty easy to translate them into OO.o I thought you might ask that. This is actually an Exeter Uni document, but I'm sure they won't mind if I temporarily put it on the web here: http://www.hadrian-way.co.uk/Misc/DataAnalysisGuide.doc > From what I can remember of TTests (its been a couple of years since I've > touched them) I would have though OO.o would handle them in a very similar > way to Excel. I'm trying to replicate the Excel stuff myself, but haven't got far yet. -- Terry Coles 64 bit computing with Kubuntu Linux -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thu, 2009-11-19 at 19:20 +, Terry Coles wrote: > Hi, > > My daughter has to do an assignment at Uni using a T-Test. Although the Uni > says that work can be submitted in Either MS or Open Office, they've only > told > her how to do it in Excel and she only has OpenOffice. > > Is there anyone out there who knows how to do this or knows how to find out? > I never did statistics, so I have no idea what to look for. > > I found this: > http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_TTEST_function, > but don't really know how to use it. Ideally, she needs a step-by-step guide > similar to the one provided by the Uni for Excel. > > -- > Terry Coles > 64 bit computing with Kubuntu Linux 1. When is it due? 2. Can You send the Excel instructions? I'll have a play. P. -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
On Thu, 19 Nov 2009 19:20:48 -, Terry Coles wrote: > Hi, > > My daughter has to do an assignment at Uni using a T-Test. Although the > Uni > says that work can be submitted in Either MS or Open Office, they've > only told > her how to do it in Excel and she only has OpenOffice. > > Is there anyone out there who knows how to do this or knows how to find > out? > I never did statistics, so I have no idea what to look for. > > I found this: > http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_TTEST_function, > but don't really know how to use it. Ideally, she needs a step-by-step > guide > similar to the one provided by the Uni for Excel. > Hello Terry, Can you provide the instructions she has for doing it in Excel? It might be pretty easy to translate them into OO.o From what I can remember of TTests (its been a couple of years since I've touched them) I would have though OO.o would handle them in a very similar way to Excel. Rob -- Using Opera M2: http://www.opera.com/mail/ -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset
[Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
Hi, My daughter has to do an assignment at Uni using a T-Test. Although the Uni says that work can be submitted in Either MS or Open Office, they've only told her how to do it in Excel and she only has OpenOffice. Is there anyone out there who knows how to do this or knows how to find out? I never did statistics, so I have no idea what to look for. I found this: http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_TTEST_function, but don't really know how to use it. Ideally, she needs a step-by-step guide similar to the one provided by the Uni for Excel. -- Terry Coles 64 bit computing with Kubuntu Linux -- Next meeting: Bournemouth, Wednesday 2009-12-02 20:00 Dorset LUG: http://dorset.lug.org.uk/ Chat: http://www.mibbit.com/?server=irc.blitzed.org&channel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset