Pivot Tables and standard deviation bug

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jimdilger@gmail.com - 24 Jul 2006 20:44 GMT

I am using Excel 2004 with OS X 10.4.7 on a Powerbook G4.

I noticed some unexpectedly small and large standard deviations coming
from a pivot table. I calculated these standard deviations with the
STDEV function and compared this with the pivot table. They are
different! Sometimes by as much as 200% different. I opened the same
spreadsheet with Excel on a PC and there was no discrepancy between the
two calculations of standard deviation.

I can send a copy of this spreadsheet to anyone who wants to follow
this up.

How does one alert Microsoft about this error?

Reply to this Message

Patrick McMillan [MSFT] - 28 Jul 2006 19:10 GMT

Hi,

I can help you with this. I'll follow-up with you directly off the list.

Thanks,

Pat

On 7/24/06 12:44 PM, in article
1153770265.705523.4650@i3g2000cwc.googlegroups.com, "jimdilger@gmail.com"

> I am using Excel 2004 with OS X 10.4.7 on a Powerbook G4.
>
[quoted text clipped - 9 lines]
>
> How does one alert Microsoft about this error?

--
Pat McMillan
Macintosh Business Unit
Microsoft Corp.

This posting is provided ³AS IS² with no warranties, and confers no rights.

Reply to this Message

jimdilger@gmail.com - 30 Jul 2006 15:40 GMT

Great! How do I get in touch with you?
Jim

> Hi,
>
[quoted text clipped - 27 lines]
>
> This posting is provided ³AS IS² with no warranties, and confers no rights.

Reply to this Message

Mac Forum / Applications / Excel / July 2006

Pivot Tables and standard deviation bug