Critical process question: generate stand dev on existing tables?

[Bill Weylock]

I am really in a jam because people working for me are not delivering for
reasons that are very muddy.

I have a spreadsheet that Jean earlier helped me format beautifully.

It presents, however, only counts and percentages of column/row
intersections.

Is there a way I can (with reasonable speed) compute standard deviations
and/or t-tests on the tables?

I¹m also looking into making our stat software behave better, but if I can
do this in Excel, it would be very very good.

Thanks!


Best,


- Bill


Panther 10.3.6
Office 2004
Windows XP Pro SP2
Office 2003

 

[JE McGimpsey]

Is there a way I can (with reasonable speed) compute standard deviations
and/or t-tests on the tables?

You can use STDEV() and TTEST(). Help has usage details...