Office 2011 Add-In

Does this NAIL the answer on the head for you?
http://support.microsoft.com/kb/2431349

If so, come back and thank me profusely.

 

That version is *really* bare bones, and really not suitable for real statistical analysis.

And, yes, that same company offers a much more powerful add-in, the StatPlus:mac product, and they have student/university pricing. Check with your university - they may have an additional license, or be willing to get a university license if there's enough demand for it. Your company might pay for a student license for you - I would pay for a license for one of my employees. AnalystSoft has provided excellent support for their products - I'm not a shill for them, just a happy customer who wished for something like this when I was taking engineering and statistics courses 22 years ago...

And, you'll want to make sure your Office suite is updated too. QED.

 

Ah, welcome to the limited world of the Mac version of Excel. Sorry for the delay, we've been dealing with nasty windy weather here related to that storm hitting NA - it's not as cold but the 40-60 MPH winds are wreaking havoc. I see you're in Michigan - I have been to MI in Dec/Jan, and it was fun (and cold!). OK, done whining.

MS has a different architecture for running "extensions" - add-ins, etc. - they eliminated a lot of functionality in Office 2011 to "extend" the Office suite applications. I'll spare you the details. AnalystSoft came up with a pretty slick workaround - and it actually is a far-more stable solution than running an in-application add-in.

What one needs to do with StatPlus is run it alongside Excel - and you do your analysis in StatPlus on the open Excel documents. Don't open Excel initially - opening StatPlus opens Excel in the background. There's a couple of short YouTube videos I've bookmarked that illustrate the basic principle of getting your work done:

http://www.youtube.com/watch?v=a6vkcD_bvJM
and
http://www.youtube.com/watch?v=jr1MZfuZIdg (skip to about 50 seconds)

They're both running LE in those videos, but you'll get the idea of how to get started. Keep in mind that they're statisticians who wrote software which performs statistical analysis alongside a workbook/spreadsheet application. Yikes! I'm an engineer, but also have technical and creative writing experience - their instructions gave me chills initially. The videos will help, I'm sure, moreso than my writing a short missive. Check out the other two videos by Richard Glover - they're helpful as well! Cheers!