Re: [Dorset] OT: Help Needed - Using OpenOffice to do a T-Test
Hello, Maybe this is just because I'm running Fedora but - basic install of OO.o from the main repos through Yum. Open Calc select a cell click the little = sign by the function bar Open the function wizard (odd icon to the left of the Sigma Category statistics TTEST is listed under those functions Sorry if I've missed something critical but I think that TTEST should act in the same way as the one in 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.orgchannel=%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.orgchannel=%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 d-...@hadrian-way.co.uk 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.orgchannel=%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.orgchannel=%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.orgchannel=%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.orgchannel=%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.orgchannel=%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.orgchannel=%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 mercha...@onetel.com 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.orgchannel=%23dorset List info: https://mailman.lug.org.uk/mailman/listinfo/dorset