Averaging variables across rows

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

BobbyJoe
Posts: 2
Joined: Fri Mar 18, 2016 3:27 pm

Averaging variables across rows

Postby BobbyJoe » Fri Mar 18, 2016 3:33 pm

I need to average all the variables for three rows of data (illustration: find the average of the heights, weights, BMIs, ages for rows 1, 2, 3 and merge these averages into one row). Is there a function that would let me do this? Thank you!

Example:
Variable Height Weight BMI Age
row 1
2
3
statman
Administrator
Posts: 2734
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: Averaging variables across rows

Postby statman » Fri Mar 18, 2016 7:06 pm

Unclear - These are not the same measurement level so .............?

And when you say 'row,' are you really talking about variables in a row?

Further ...
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
GerineL
Moderator
Posts: 1477
Joined: Tue Jun 10, 2008 4:50 pm

Re: Averaging variables across rows

Postby GerineL » Mon Mar 21, 2016 12:52 pm

you probably need the aggregate function.
BobbyJoe
Posts: 2
Joined: Fri Mar 18, 2016 3:27 pm

Re: Averaging variables across rows

Postby BobbyJoe » Mon Mar 21, 2016 4:39 pm

Thank you for your assistance. I ended up using the aggregate function.

Who is online

Users browsing this forum: No registered users and 2 guests

cron