How to Change Percentages to an Average

Introduction

This article describes how to go from a categorical variable which displays individual categories and percentages: 

To a numeric variable which displays the overall average: 

Requirements

A categorical variable in your data set which contains meaningful underlying numeric values. For example, an age variable which is coded with age range midpoints: 

Method

1. Create a table from your variable by dragging it from the Data Sets tree onto the page. 

2. Select the variable in the Data Sets tree. 

3. From the toolbar menu, select Anything > Data > Variables > Modify > Restructure > Average. 

See Also

How to Change a Variable Set From Displaying Percentages to Averages

How to Change Averages to Percentages