Spss analysis | Statistics homework help

Part 1: Ordering and Grouping Data Using Excel and SPSS

For Part 1, accomplish the following:

Order (sort) observations according to age.

Group observations by sex and investigate the age and income for males and females.

Create a new variable titled “Exercise Group” based on the variable “Minutes Exercise.” Use the following categories to create your groups: 1 = 0-30 minutes; 2 = 31-60 minutes; 3 = 61-90 minutes; 4 = 91-120 minutes; and 5 = 120+ minutes.