Missing Values calculating 0
Posted: Fri Apr 07, 2023 12:07 am
Hello,
I am writing my dissertation and running into a few issues. Mainly that my stats are not calculating, I have two missing values that participants did not answer the question on and then I am calculating this at the end so I can run analysis. However, my issue is that these values are blank and I can not give them a missing value of 0 as that is my measurement for deception and the absence of a number there is important. When I leave it blank it does not put anything in the total calculation and if I enter ignore_missing=1 then they report back as 0 when they should be much higher.
I have attached an image of it, the circle red is what I am being given with the calculation while the blue is what it should have (manually entered). I can not just use the manually entered values due to the fact that things such as the mean calculation will not take into account that they divide by 9 instead of 10 due to the missing answer.
If anyone knows the answer to this it would be much appreciated,
Thank you
I am writing my dissertation and running into a few issues. Mainly that my stats are not calculating, I have two missing values that participants did not answer the question on and then I am calculating this at the end so I can run analysis. However, my issue is that these values are blank and I can not give them a missing value of 0 as that is my measurement for deception and the absence of a number there is important. When I leave it blank it does not put anything in the total calculation and if I enter ignore_missing=1 then they report back as 0 when they should be much higher.
I have attached an image of it, the circle red is what I am being given with the calculation while the blue is what it should have (manually entered). I can not just use the manually entered values due to the fact that things such as the mean calculation will not take into account that they divide by 9 instead of 10 due to the missing answer.
If anyone knows the answer to this it would be much appreciated,
Thank you