SPSS Worksheet Assignment

Complete the Assignment Worksheet using the Excel dataset provided by the instructor. Be sure that your completed worksheet contains the SPSS codebook for your data file, your responses to all questions, and all of the required SPSS output.

Step 2: Import the Microsoft Excel data file provided in this week’s learning resources into SPSS.

Step 3: Run and save the Codebook for your SPSS data file.

Step 4: Create an ungrouped frequency distribution table for each of the following:

AGE, SEX, EXERCISE, and CHNG_ENDUR.

Step 5: Run descriptive/summary statistics (mean, median, mode, standard deviation, and range) for both exercise types combined for AGE and CHNG_ENDUR.

Step 6: SPLIT the data file by exercise type (EXERCISE).

Step 7: Create a line graph that illustrates CHNG_ENDUR for each exercise type separately.

Step 8: Create pie charts for SEX for each exercise type group.

Step 9: Run descriptive/summary statistics (mean, median, mode, standard deviation, and

range) for each exercise type separately for AGE and CHNG_ENDUR.

Step 10: Review all of your SPSS output and answer each of the following questions:

Step 11: Paste all required output below.

A. Output—SPSS Codebook

B. Output—all ungrouped frequency distribution tables:

C. Output—descriptive/summary statistics for both exercise groups combined:

D. Output—line graphs for CHNG_ENDUR for each exercise group separately:

E. Output—pie charts for SEX for each exercise group separately:

F. Output—descriptive/summary statistics for each exercise group separately: