Slight difference between Saiku stats and Excel

  • Asked
  • Active
  • Viewed 3092 times
0

Hi,

I was checking my calculated field by comparing the average in Saiku versus in Excel. I filled 10 plots for the field to be calculated. I enter the same data in my Excel file too so I could compare between Saiku and Excel.

I always have a difference: The district average is 23.21% in Excel but 23.13 in Saiku; the average of one smaller administrative unit is 15.63% in Excel and 15.5% in Saiku. When I exclude the values for which I am not confident, the average is 25.03% in Excel and 24.83% in Saiku.

Any reason about these discrepancies? Anybody else noticed this?

Thanks,

Florence

asked

flandsberg 101●2●59●83 accept rate: 0%

Be the first one to answer this question!

Insert an image

Say what the image shows, for people who can't see it.
At least 50 characters

Powered by the Open Foris edition of OSQA Content licensed under CC BY-SA 3.0

This Q&A software is free and open source (GPL). Any organisation can run it for its own community: get the code and instructions at github.com/openforis/osqa.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.