Pivot Tables and standard deviation bug

[jimdilger]

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?

 

[Patrick McMillan [MSFT]]

Hi,

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

Thanks,

Pat

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?

--
Pat McMillan
Macintosh Business Unit
Microsoft Corp.

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

 

[jimdilger]

Great! How do I get in touch with you?

Hi,

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

Thanks,

Pat




--
Pat McMillan
Macintosh Business Unit
Microsoft Corp.

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