Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

In SPSS, how can I use the mean of a variable as a variable?

SPSS can use the mean of a variable as a variable only in a very inelegant manner. Following is an example:

DATA LIST /student 1-3. BEGIN DATA 40 60 97 55 END DATA. COMPUTE dummy=1. AGGREGATE OUTFILE=new /BREAK=dummy /NEW=mean(student). MATCH FILES TABLE=new / FILE=* /BY dummy. EXECUTE.

After the program has read the data, create a dummy variable. With AGGREGATE, you can calculate statistics across cases, and save the results in an SPSS system file. By using MATCH FILES (with TABLE and BY), you can join the original and new files, matched on the dummy variable.

For more about statistical and mathematical software, email the UITS Stat/Math Center, visit the center's web page, or phone 812-855-4724 (IUB) or 317-278-4740 (IUPUI). The center is located in Bloomington at 410 N. Park Avenue, and is open for consultation by appointment Monday-Friday 9am-5pm.

This is document abkm in domain all.
Last modified on January 27, 2011.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.