Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Wrong average calculation

Hi    I created a matrix table for to calculate the average of my data by each category. Below is the montly expense data I have, classified by "abnormal" and "normal" expenses. I think the average...
Need Help
Show and Tell
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

Do you have rows with zero values in the Excel file that are not shown in the data provided?

Let's look at (2018 Abnormal) data provided:-

180 + 227.45 + 294.4 + 345.4 = 1,047.25

 

There are 4 entries and average shown in the matrix is 261.81. (1047.25 divided by 4)

 

If we take the average you give from excel (209.45) and divide the total above (1047.25), we get a nice round 5. So it suggests there's another row somewhere.

I haven't looked at the other years but it might be similar.