Calculate MEAN and SUM for variables with missing data in SPSS

preview_player
Показать описание
In this SPSS tutorial I show you how to use SPSS syntax in order to calculate the mean and sum for variables with missing data.

Using the "SUM" or "MEAN" function, you can state how many items participants need to answer ".3" or ".4" in order to calculate a sum or mean for that participant. This way, you can bypass missing data and still calculate a sum or mean for each participant.
  1. Jon B Stats and Psych
  2. SPSS
  3. SPSS Data Preparation
  4. SPSS Mean
  5. SPSS Tutorial
  6. SPSS SUM Function
Рекомендации по теме
Calculate MEAN and 0:06:00

Calculate MEAN and SUM for variables with missing data in SPSS

How to Find 0:03:33

How to Find the Mean | Math with Mr. J

How to compute 0:06:08

How to compute sum of x, sum of x squared and mean using a scientific calculator || Stat Tutorials

Creating subscale scores 0:03:03

Creating subscale scores (mean or sum of items)

How to use 0:00:38

How to use the SUM function in Microsoft Excel

QUERY CALCULATIONS SUM 0:02:22

QUERY CALCULATIONS SUM AND AVERAGE

SPSS Using SUM 0:06:03

SPSS Using SUM function

Create Mean (Average) 0:03:29

Create Mean (Average) and Sum Variables in SPSS

Week-4|TA Session-2 3:29:51

Week-4|TA Session-2

Excel Statistics - 0:04:22

Excel Statistics - Average (Mean), Minimum, and Maximum in Excel (Sum Function)

Java Program #4 0:06:54

Java Program #4 - Find Sum and Average of Array Elements

Mean, Median, and 0:14:34

Mean, Median, and Mode of Grouped Data & Frequency Distribution Tables Statistics

How to find 0:00:49

How to find Mean, Median, Maximum, Minimum, Standard Deviation, sum in Origin | Statistics in Origin

Calculate sum, sum 0:04:27

Calculate sum, sum of square, mean, standard deviation and variance using scientific calculator

Find The Sum 0:06:42

Find The Sum And Average Of Numbers In A File | C++ Example

Lesson 17 - 0:01:31

Lesson 17 - Using Sum And Average

Calculate Sum and 0:01:50

Calculate Sum and Average of Values in an Array (Java)

Excel Statistics - 0:02:15

Excel Statistics - Mean (Average), Min, Max, Sum (Quick Method)

SUM, AVERAGE, MEDIAN, 0:02:32

SUM, AVERAGE, MEDIAN, MAX & MIN | Microsoft Excel

Find Mean or 0:08:12

Find Mean or Expectation of Sum of Numbers for Two Dice

Calculate Sum, Average, 0:16:05

Calculate Sum, Average, Variance and Standard Deviation: C Program

How to calculate 0:02:54

How to calculate in word table (sum, multiplication, average)

finding the total/ 0:01:47

finding the total/ sum of numbers given the mean and count

Learn Algorithm: To 0:08:49

Learn Algorithm: To Find Sum, Product and Average of Five Given Numbers| Computer Science_9 [1.3.2]

Комментарии
Автор

This was exactly the command I was looking for...thanks for the tutorial!!

amaleemccoy
Автор

This solved my problem! What is the easiest way to open the SPSS Script Editor?

patrickkielly
Автор

Hi, thanks for the helpful explanation.


I want to calculate a total score of a questionnaire with a couple of missing items, but want the missing data points to be included as the mean of the specific case/person's scores on that questionnaire only, rather than the dataset mean for that questionnaire. Is there a way to code this... for example


SUM.3(Item_1, Item_2, Item_3, Item_4, Item_5) IF SYSMIS, use MEAN)


Thanks for your help!

johnburke
Автор

Is there any other way from the drop-down menu?
I figured out another way by recording the missing value to be 0 and then running the compute command.

loaizabin