C
Charles Deng
Hi All:
Is there anyone who can tell me how to calculate average
of valid values?
I have a huge data set with 1 to 6 valid values and 0 as
missing. I need to calculate average of only valid values
(1 to 6) for each record but to exclude 0 (missing). For
exmple,
1, 3, 3, 0, 5
The average for this record should be 3 because 0 is
missing value and should not be included. But when I use
Excel built in function Average, the result is 2.4.
Any help will be very very appreciated.
Charles
Is there anyone who can tell me how to calculate average
of valid values?
I have a huge data set with 1 to 6 valid values and 0 as
missing. I need to calculate average of only valid values
(1 to 6) for each record but to exclude 0 (missing). For
exmple,
1, 3, 3, 0, 5
The average for this record should be 3 because 0 is
missing value and should not be included. But when I use
Excel built in function Average, the result is 2.4.
Any help will be very very appreciated.
Charles