Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computing > NZ Computing > Stats Experts: Use Gnumeric, Don’t Use Excel

Reply
Thread Tools

Stats Experts: Use Gnumeric, Don’t Use Excel

 
 
Lawrence D'Oliveiro
Guest
Posts: n/a
 
      02-21-2010
Interesting. Gnumeric initially cloned Excel so exactly that it reproduced
the same calculation bugs. However, those have now been fixed, while Excel
remains as buggy as ever <http://www.csdassn.org/reportdetail.cfm?ID=508>.
 
Reply With Quote
 
 
 
 
Squiggle
Guest
Posts: n/a
 
      02-22-2010
Lawrence D'Oliveiro threw some characters down the intarwebs:
> Interesting. Gnumeric initially cloned Excel so exactly that it reproduced
> the same calculation bugs. However, those have now been fixed, while Excel
> remains as buggy as ever <http://www.csdassn.org/reportdetail.cfm?ID=508>.
>

Why would you use a spreadsheet to do statistical anaylysis? There are
tools designed for doing statistical analysis, SPSS, R and Matlab with
the stats toolkit all being good examples, and far better choices than
gnumeric or excel.

Using excel,gnumeric or any other general purpose spreadsheet for
statistical analysis sounds a bit like using a baseball bat to drive nails.
 
Reply With Quote
 
 
 
 
peterwn
Guest
Posts: n/a
 
      02-22-2010
On Feb 22, 2:03*pm, Squiggle <(E-Mail Removed)> wrote:
> Lawrence D'Oliveiro threw some characters down the intarwebs:> Interesting. Gnumeric initially cloned Excel so exactly that it reproduced
> > the same calculation bugs. However, those have now been fixed, while Excel
> > remains as buggy as ever <http://www.csdassn.org/reportdetail.cfm?ID=508>.

>
> Why would you use a spreadsheet to do statistical anaylysis? *There are
> tools designed for doing statistical analysis, SPSS, R and Matlab with
> the stats toolkit all being good examples, and far better choices than
> gnumeric or excel.
>
> Using excel,gnumeric or any other general purpose spreadsheet for
> statistical analysis sounds a bit like using a baseball bat to drive nails.


Hence the logical conclusion of your argument is that the Excel bugs
do not need fixing as people should be using specialist software for
the task in hand. What a cop-out!

Enough people seem to use statistical functions in spreadsheets as to
warrant their retention and in the case of Gnumeric to warrant
volunterers to get stuck in and fix the bugs.

 
Reply With Quote
 
Gib Bogle
Guest
Posts: n/a
 
      02-22-2010
peterwn wrote:
> On Feb 22, 2:03 pm, Squiggle <(E-Mail Removed)> wrote:
>> Lawrence D'Oliveiro threw some characters down the intarwebs:> Interesting. Gnumeric initially cloned Excel so exactly that it reproduced
>>> the same calculation bugs. However, those have now been fixed, while Excel
>>> remains as buggy as ever <http://www.csdassn.org/reportdetail.cfm?ID=508>.

>> Why would you use a spreadsheet to do statistical anaylysis? There are
>> tools designed for doing statistical analysis, SPSS, R and Matlab with
>> the stats toolkit all being good examples, and far better choices than
>> gnumeric or excel.
>>
>> Using excel,gnumeric or any other general purpose spreadsheet for
>> statistical analysis sounds a bit like using a baseball bat to drive nails.

>
> Hence the logical conclusion of your argument is that the Excel bugs
> do not need fixing as people should be using specialist software for
> the task in hand.


That is a non sequitur.
 
Reply With Quote
 
peterwn
Guest
Posts: n/a
 
      02-22-2010
On Feb 22, 6:00*pm, Gib Bogle <(E-Mail Removed)> wrote:
> peterwn wrote:
> > On Feb 22, 2:03 pm, Squiggle <(E-Mail Removed)> wrote:
> >> Lawrence D'Oliveiro threw some characters down the intarwebs:> Interesting. Gnumeric initially cloned Excel so exactly that it reproduced
> >>> the same calculation bugs. However, those have now been fixed, while Excel
> >>> remains as buggy as ever <http://www.csdassn.org/reportdetail.cfm?ID=508>.
> >> Why would you use a spreadsheet to do statistical anaylysis? *There are
> >> tools designed for doing statistical analysis, SPSS, R and Matlab with
> >> the stats toolkit all being good examples, and far better choices than
> >> gnumeric or excel.

>
> >> Using excel,gnumeric or any other general purpose spreadsheet for
> >> statistical analysis sounds a bit like using a baseball bat to drive nails.

>
> > Hence the logical conclusion of your argument is that the Excel bugs
> > do not need fixing as people should be using specialist software for
> > the task in hand. *

>
> That is a non sequitur.


Of course. If spreadsheet programs have statistical functions for
whaever reason, or lack of, they should operate correctly.
 
Reply With Quote
 
Gib Bogle
Guest
Posts: n/a
 
      02-22-2010
peterwn wrote:
> On Feb 22, 6:00 pm, Gib Bogle <(E-Mail Removed)> wrote:
>> peterwn wrote:
>>> On Feb 22, 2:03 pm, Squiggle <(E-Mail Removed)> wrote:
>>>> Lawrence D'Oliveiro threw some characters down the intarwebs:> Interesting. Gnumeric initially cloned Excel so exactly that it reproduced
>>>>> the same calculation bugs. However, those have now been fixed, while Excel
>>>>> remains as buggy as ever <http://www.csdassn.org/reportdetail.cfm?ID=508>.
>>>> Why would you use a spreadsheet to do statistical anaylysis? There are
>>>> tools designed for doing statistical analysis, SPSS, R and Matlab with
>>>> the stats toolkit all being good examples, and far better choices than
>>>> gnumeric or excel.
>>>> Using excel,gnumeric or any other general purpose spreadsheet for
>>>> statistical analysis sounds a bit like using a baseball bat to drive nails.
>>> Hence the logical conclusion of your argument is that the Excel bugs
>>> do not need fixing as people should be using specialist software for
>>> the task in hand.

>> That is a non sequitur.

>
> Of course. If spreadsheet programs have statistical functions for
> whaever reason, or lack of, they should operate correctly.


Plus willful misconstruing. As you well know, he didn't say anything about the
need to fix bugs in Excel, and to claim such a "logical conclusion" is illogical.
 
Reply With Quote
 
peterwn
Guest
Posts: n/a
 
      02-22-2010
On Feb 23, 9:12*am, Gib Bogle <(E-Mail Removed)> wrote:

>
> > Of course. *If spreadsheet programs have statistical functions for
> > whaever reason, or lack of, *they should operate correctly.

>
> Plus willful misconstruing. *As you well know, he didn't say anything about the
> need to fix bugs in Excel, and to claim such a "logical conclusion" is illogical.


Which begs the question why he made an off topic comment to start
with. I construed his comment to mean "you might as well stick eith
Excel, as no serious statistics person uses spreadsheets for
statistics" and drew my conclusions from this.

 
Reply With Quote
 
Gib Bogle
Guest
Posts: n/a
 
      02-22-2010
peterwn wrote:
> On Feb 23, 9:12 am, Gib Bogle <(E-Mail Removed)> wrote:
>
>>> Of course. If spreadsheet programs have statistical functions for
>>> whaever reason, or lack of, they should operate correctly.

>> Plus willful misconstruing. As you well know, he didn't say anything about the
>> need to fix bugs in Excel, and to claim such a "logical conclusion" is illogical.

>
> Which begs the question why he made an off topic comment to start
> with. I construed his comment to mean "you might as well stick eith
> Excel, as no serious statistics person uses spreadsheets for
> statistics" and drew my conclusions from this.
>


Eh? He said this "Using excel,gnumeric or any other general purpose spreadsheet
for statistical analysis sounds a bit like using a baseball bat to drive nails."
Does this sound like advocating sticking with Excel? Not to me.
 
Reply With Quote
 
Lawrence D'Oliveiro
Guest
Posts: n/a
 
      02-22-2010
In message <hluvm4$qrc$(E-Mail Removed)>, Gib Bogle wrote:

> He said this "Using excel,gnumeric or any other general purpose
> spreadsheet for statistical analysis sounds a bit like using a baseball
> bat to drive nails."
> Does this sound like advocating sticking with Excel? Not to me.


But there was a clear implication that the bugs somehow didn’t matter.
 
Reply With Quote
 
Gib Bogle
Guest
Posts: n/a
 
      02-23-2010
Lawrence D'Oliveiro wrote:
> In message <hluvm4$qrc$(E-Mail Removed)>, Gib Bogle wrote:
>
>> He said this "Using excel,gnumeric or any other general purpose
>> spreadsheet for statistical analysis sounds a bit like using a baseball
>> bat to drive nails."
>> Does this sound like advocating sticking with Excel? Not to me.

>
> But there was a clear implication that the bugs somehow didn’t matter.


Not to me. The implication to me was that only a fool would use Excel for stats.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use Sitealizer Web Stats in rails 2.2 version? Vikas Gholap Ruby 1 02-05-2009 08:29 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Get Interface stats NOT VLAN stats on 6500 Mr Jibbles Cisco 3 07-03-2006 05:40 PM
Web Stats? Which to use? Which is best? Familyman HTML 3 02-09-2006 11:05 PM
Excel _WorkBook vs. Excel.Workbook =?Utf-8?B?SmltIEhlYXZleQ==?= ASP .Net 1 09-29-2004 03:48 PM



Advertisments