The Clarence Fitness Center is analyzing the satisfaction level of their club members. Data based on a survey of customers is stored in the MS-Excel File.

Retrieve the SPSS file and label the variables according to the information below.

Clarence Fitness Center - Customer Survey Data

Column A:Weight and Exercise Equipment Satisfaction

Column B:Club Staff Satisfaction

Column C:Exercise Programs Satisfaction

Column D:Overall Club Satisfaction

Scale for Columns A - D

5 = Very Satisfied4 = Satisfied3 =Neutral2 = Dissatisfied1 = Very Dissatisfied

Column E:Years with the club

Column F:Gender (1 = Male2 = Female)

Column G:Typical Number of Visits Per Week

Column H:Age of Customer

1.Use the split file procedure to analyze the Frequency of typical patter of visits to compare males and females

2.Calculate the Average Number of Visits and prepare chart to compare Males and Females

3.What is the Average Age of Females compared to Males?

4.Plot two charts to compare (1) the Average Age of Males and Females (2) The Average Number of Visits of Males and Females

5.Which gender has the greater variation in (1) Number of Visits Per Week and (2) Age

6.Can you explain your results?