Search found 3 matches
- Sat Dec 07, 2024 10:25 am
- Forum: Help
- Topic: Computing Mean Score - ignoring certain values without excluding participant/row altogether
- Replies: 5
- Views: 39205
Re: Computing Mean Score - ignoring certain values without excluding participant/row altogether
In other words: 1. What does the formula "ignore_missing=1" actually do to the data? Is the mean calculated without the missing value, or is the missing value substituted for a value of 1? Sorry, as mentioned I don't understand the language of this software. I'm very new to data analysis a...
- Sat Dec 07, 2024 3:08 am
- Forum: Help
- Topic: Computing Mean Score - ignoring certain values without excluding participant/row altogether
- Replies: 5
- Views: 39205
Re: Computing Mean Score - ignoring certain values without excluding participant/row altogether
Hi Jonathon, thanks for your suggestion. Just a couple of follow-up questions: a) I'm not sure how this formula would work. Would I need to change all the 99s to 1s for it to work? Would it ensure that a mean based on all other scores and excluding the 99s (i.e. not substituting them for 0)? b) Ther...
- Sat Dec 07, 2024 2:51 am
- Forum: Help
- Topic: Computing Mean Score - ignoring certain values without excluding participant/row altogether
- Replies: 5
- Views: 39205
Computing Mean Score - ignoring certain values without excluding participant/row altogether
I’m working with a spreadsheet containing ‘99’ values – these are not missing values, but rather, where participants have chosen that a particular item in a scale is not applicable to them. I’ve been asked to create Mean scores for several scales including some of these 99 (not applicable) values. A...