regression/anova

[j. diet]

Hi all,
I am a full time student and a bought the academic version of MS
Office X. Does this version have anova and regression capabilities? I
tried going to the add-on in the tools and the library, nothing.

Thanks!
J

 

[David J. Braden]

Forgot to mention--- the Analysis ToolPak's ANOVA is no great shakes
either. Better to do your own with the appropriate worksheet functions.
Here too there is ample posted discussion on this.

I realize this is slightly outside of your post, but I recommend, for
anything that is remotely important to you, that you avoid the ATP for
stat work of any sort. You can coax Excel into OK results if you know
its shortcomings, and know your analysis. May be just a lot easier to
use a dedicated stat package (R, an open-source version of S, is free,
and a lot better), or a spreadsheet whose developers are more serious
about accuracy, like Gnumeric, also free.

Regards,
DB

 

[David J. Braden]

J,
Thanks for the thanks. I hope I wasn't too obtuse; looking over the
thread again, I may well have been; it was certainly unintentional.

If you are interested in Excel's stat strengths and weaknesses, and some
workarounds, a Google search of the Excel groups for threads with the
following names will yield a lot of good stuff: Braden (me), Conrad
Carlberg, Harlan Grove, Myrna Larsen, Jerry W. Lewis, Bernard Liengme,
Mike Middleton, John Petrulis, and John Wilson. Sorry for any oversight
here. I would add Jon Peltier, Tom Ogilvy, Tushar Mehta and Chip
Pearson, except that they answer so many sorts of questions that a
search under their names might not be as productive for stat-specific
stuff. There are a *lot* of other contributors, though the above bunch
tends to get involved at some point in threads.

As an example, I recently found a real gem that involved Conrad and
Jerry years back. It is a poignant reminder of just how far Excel
*hasn't* come with respect to its stat potential.

Regards,
Dave B