How Do I Replace Missing Values With Means?

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

herwitz
Posts: 5
Joined: Tue May 13, 2014 7:29 pm

How Do I Replace Missing Values With Means?

Postby herwitz » Tue May 13, 2014 7:45 pm

I have a large data set which contains some missing values. I would like to replace those missing values with the mean individual scores of their respective measures. Below is a screenshot of an example within my data set.

Image

Note that RSE_8 and RSE_8r in the third row are missing values. I intend to ignore RSE_8, as the total score (RSE_T, which is a summed score) uses the _nr values (i.e., those which were reverse-scored) when applicable. I would like RSE_8r (and all other missing values) to be the mean of the other RSE (and all other measures) items for each individual. In other words, using the example, I would like RSE_8r to be the mean of all appropriate RSE items within the third row. Is there an easy way for SPSS to do this for all missing values?

Many thanks for your time!

EDIT:

OS: Windows 7
SPSS 21
This is a psychology study with multiple measures.
Last edited by herwitz on Tue May 13, 2014 9:08 pm, edited 1 time in total.
statman
Administrator
Posts: 2737
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: How Do I Replace Missing Values With Means?

Postby statman » Tue May 13, 2014 8:41 pm

Wow! And why would one want to do this?

That aside. It might take a special maco or look into the OMS facility

Also ...
See the note below

NOTE: Please read the Posting Guidelines and always tell us your OS, the SPSS version and information about your study and data!

Statman
Statistical Services
herwitz
Posts: 5
Joined: Tue May 13, 2014 7:29 pm

Re: How Do I Replace Missing Values With Means?

Postby herwitz » Tue May 13, 2014 9:10 pm

Thanks for your reply, statman, and sorry for the missing info (edited above)!

Replacing missing values with mean scores is generally acceptable, so long as one is not replacing a lot of data.

What is a special maco or the OMS facility?
herwitz
Posts: 5
Joined: Tue May 13, 2014 7:29 pm

Re: How Do I Replace Missing Values With Means?

Postby herwitz » Tue May 13, 2014 9:45 pm


Who is online

Users browsing this forum: No registered users and 2 guests

cron