Windows 7 - Averaging columns with missing numbers
Asked By sbwesti
22-Jan-10 10:52 AM
Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
How does Excel handle averaging numbers in a column when some of the cells are blank?
Office
(1)
Excel
(1)
Webcrossing.JaKIaxP2ac0
(1)
Leopard
(1)
Containzero
(1)
Divides
(1)
Zeroes
(1)
CyberTaz replied to sbwesti
Assuming you are using the =AVERAGE() function, it is designed to ignore blank
cell or those that contain text. IOW, if the range is 10 cells & 4 of them
are empty the function totals the 6 values & divides the sum by 6. If those
4 cells contain 0s it will divide by 10 because 0 is a value.
--
HTH |:>)
Bob Jones
[MVP] Office:Mac
sbwesti replied to sbwesti
Thank you for your response. <br><br>I am using the =AVERAGE()function. My column has 34 rows, of which 4 cells are blank (they do not contain a "0"). The average Excel calculated was 40.69, standard deviation of 4.24. <br><br>I then copied and pasted just the 30 rows of numbers to eliminate the blank cells - the new average was 41.49, standard deviation of 4.47. <br><br>This is obviously a problem when many more rows are involved! Any thoughts?
CyberTaz replied to sbwesti
Are you certain that the 'blank' cells are actually blank & do not contain
zero values? Select each of them & take a look at the formula bar. If Excel>
Preferences> View has the check removed on "Show zero values" cells
containing zeroes *display* as blank but the zero values stored in them are
included in the computations.
Since your column containing the blanks averages lower than the column
without them I tend to suspect that to be the reason. Testing here yields
exactly the same result for both columns regardless of cell formatting.
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 1/23/10 7:56 AM, in article 59bb16ec.1@webcrossing.JaKIaxP2ac0,
Error 23 / 03 / 2008 2:32:47 PM Application Hang None 1001 N / A PAULS-OFFICE Error 23 / 03 / 2008 2:32:38 PM Application Hang (101) 1002 N / A PAULS-OFFICE Information 23 / 03 / 2008 1:37:20 AM SecurityCenter None 1800 N / A PAULS OFFICE Information 22 / 03 / 2008 1:37:27 AM SecurityCenter None 1800 N / A PAULS-OFFICE Information 21 / 03 / 2008 1:36:56 AM SecurityCenter None 1800 N / A PAULS-OFFICE Information 20 / 03 / 2008 4:06:15 PM SecurityCenter None 1800 N / A PAULS-OFFICE Information 20 / 03 / 2008 4:05:29 PM Winlogon None 1001 N / A PAULS OFFICE Information 20 / 03 / 2008 3:43:10 PM SecurityCenter None 1800 N / A PAULS-OFFICE Information 20 / 03 / 2008 2:56:13 PM SecurityCenter None 1800 N / A PAULS-OFFICE
102 2010-05-07 13:58:39:189 1300 11f4 Agent * Title = Update for Microsoft Office Word 2007 (KB974561) 2010-05-07 13:58:39:189 1300 11f4 Agent * UpdateId = {9452E2DD 101 2010-05-07 13:58:39:189 1300 11f4 Agent * Title = Update for Microsoft Office OneNote 2007 Help (KB963670) 2010-05-07 13:58:39:189 1300 11f4 Agent * UpdateId 05-07 13:58:39:189 1300 11f4 Agent * Title = Update for the 2007 Microsoft Office System (KB981715) 2010-05-07 13:58:39:189 1300 11f4 Agent * UpdateId = {AC4180ED-FA59 PM: - Security Update for Windows Vista (KB973768) - Update for Windows Vista (KB972145) - Update for Microsoft Office Outlook 2007 Junk Email Filter (KB981433) - Security Update for Windows Vista (KB975560) - Security Update for Microsoft Office Outlook 2007 (KB972363) - Security Update for Windows Vista (KB973565) - Security Update for Windows Vista (KB974318 Windows Vista (KB970238) - Security Update for Windows Vista (KB974571) - Security Update for the 2007 Microsoft Office System (KB974234) - Microsoft .NET Framework 1.1 Service Pack 1 Security Update for Windows 2000 Windows Server 2008, Windows 7, and Windows Server 2008 R2 (KB953297) - Security Update for Microsoft Office Publisher 2007 (KB980470) - Security Update for Microsoft Works 8 (KB977304) - Security Update for the 2007 Microsoft Office System (KB978380) - Update for Microsoft Office InfoPath 2007 (KB976416) - Security Updat 2010-05-07 14
set associations control panel. i have set the association to open all .doc files with office word 2007, but the error's still there!!!! any ideas?? Hi Chrissy, Are you able set associations control panel. i have set the association to open all .doc files with office word 2007, = but = 20 the error's still there!!!! any ideas?? Same problem for me description of the problem, = the exact error message verbatim and also indicate the version of Office = installed in your system. - - = 20 Regards, Ramesh Srinivasan, Microsoft MVP [Windows Shell / User] Windows = C2 04 PM FileExtInfo © 2005-2007 Ramesh Srinivasan. Homepage: http: / / www.winhelponline.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [HKEY_CLASSES_ROOT \ .XLS] @ = "Excel.Sheet.8" [HKEY_CLASSES_ROOT \ .XLS \ Excel.Sheet.8] [HKEY_CLASSES_ROOT \ .XLS \ Excel.Sheet.8 \ ShellNew] [HKEY_CLASSES_ROOT \ .XLS \ PersistentHandler] @ = "{98de59a0-d175-11cd-a7bd-00006b827d94}" [HKEY_CLASSES_ROOT \ .XLS \ shellex] [HKEY_CLASSES_ROOT XLS \ shellex \ {8895b1c6-b41f-4c1c-a562-0d564250836f}] @ = "{00020827-0000-0000-C000-000000000046}" [HKEY_CLASSES_ROOT \ Excel.Sheet.8] @ = "Microsoft Office Excel 97-2003 Worksheet" [HKEY_CLASSES_ROOT \ Excel.Sheet.8 \ CLSID] @ = "{00020820-0000-0000-C000-000000000046}" [HKEY_CLASSES_ROOT
checker My email spell checker has disapeared. I thnk it happened when I upgraded to Office 2007. All the dictionaries are gone except French. Does anyone know how to get the They have always "stolen" access to some unrelated, co-installed Microsoft product, such as MS Office (up to, but not including, Office 2007), or MS Works (except for later versions; not Works 8, which came with my hills and valleys. I called MSN today about this same issue. You can install Microsoft Office 2003 and get your spell checker back, but Office 2007 does not support it. There are other spell checkers you can download - check google for those. More appropriate advice would have been that if Office 2007 is installed to only install the Spelling and Proofing Tools for Office 2003. Negating the use of Office 2007, while an option if wishing to revert to Office 2003, is not a universal
Way http: / / www.catb.org / ~esr / faqs / smart-questions.html The MSOCache folder contains the Office Setup files, so that to = repair / reinstall an Office component, you don't have to insert the = Office CD-ROM everytime. If the MSOCache folder is deleted, you'll need = to use the Office CD-ROM to repair or reinstall Office components. In = addition to the links supplied by Shenan, these may help also: Prevent accidental deletion of Office Setup Files when using the Disk = Cleanup utility: http: / / www.winhelponline.com / articles / 131 / 1 / How to recreate the Office 2003 Setup files folder (MSOCache) after = deleting it accidentally using Disk Cleanup utility: = 20 http 20 OK - I read the info in the Google links. The problem is I have Office 2000 Pro upgraded to Office XP Pro so why do I have an MSOCACHE folder