ED 793 LAB #3LAB #3 OUTLINE1. SPSS Reminders2. Crosstabs and the SPSS Syntax Guide3. Missing Data AnalysisSPSS Command Rule Reminders1. Every command ends in a period (.).2. Commands and command specifications are NOT case sensitive (unlike UNIX).3. Commands MUST start in the first column, subcommands must be indented.4. Subcommands are separated from each other by a slash.5. Commands can be abbreviated to the first three letters except when duplicates exist.6. You can use the ** to put comments in your files to remind yourself of what you were doing. The ** must appear in the first column. 7. You can use the ! to repeat the last command you used that started with a particular letter.Crosstabs and the SPSS Syntax GuideCROSSTABS VARIABLES=varlist(min,max) [varlist...] /TABLES=varlist BY varlist [BY...] [/varlist...][/MISSING={TABLE**}] {INCLUDE} {REPORT}[/WRITE[={NONE**}]] {CELLS } {ALL }[/FORMAT= {AVALUE**} {TABLES**}] {DVALUE } {NOTABLES}[/CELLS=[{COUNT**}] [ROW ] [EXPECTED] [SRESID ]] {NONE } [COLUMN] [RESID ] [ASRESID] [TOTAL ] [ALL ][/STATISTICS=[CHISQ] [LAMBDA] [BTAU] [GAMMA] [ETA ]] [PHI ] [UC ] [CTAU] [D ] [CORR ] [CC ] [RISK] [KAPPA] [MCNEMAR] [ALL ] [NONE ]Example:CROSSTABS TABLES=HSGPA BY SEX /CELLS=COUNT ROW COLUMN EXPECTED /STATISTICS=CHISQ.1/13/19 ED 793 Lab1OUTPUT: HSGPA AVERAGE HIGH SCHOOL GRADE by SEX STUDENT'S SEX SEX Page 1 of 1 Count | Exp Val |MALE FEMALE Row Pct | Row Col Pct | 1 | 2 | TotalHSGPA --------+--------+--------+ 1 | 1 | 0 | 1 D | .5 | .5 | .0% |100.0% | .0% | | .0% | .0% | +--------+--------+ 2 | 3 | 1 | 4 C | 2.0 | 2.0 | .1% | 75.0% | 25.0% | | .1% | .0% | +--------+--------+ 3 | 6 | 0 | 6 C+ | 2.9 | 3.1 | .1% |100.0% | .0% | | .3% | .0% | +--------+--------+ 4 | 25 | 3 | 28 B- | 13.8 | 14.2 | .6% | 89.3% | 10.7% | | 1.1% | .1% | +--------+--------+ 5 | 117 | 88 | 205 B | 100.7 | 104.3 | 4.4% | 57.1% | 42.9% | | 5.2% | 3.8% | +--------+--------+ 6 | 345 | 328 | 673 B+ | 330.5 | 342.5 | 14.6% | 51.3% | 48.7% | | 15.2% | 14.0% | +--------+--------+ 7 | 906 | 870 | 1776 A- | 872.2 | 903.8 | 38.5% | 51.0% | 49.0% | | 40.0% | 37.1% | +--------+--------+ 8 | 861 | 1056 | 1917 A OR A+ | 941.5 | 975.5 | 41.6% | 44.9% | 55.1% | | 38.0% | 45.0% | +--------+--------+ Column 2264 2346 4610 Total 49.1% 50.9% 100.0% Chi-Square Value DF Significance-------------------- ----------- ---- ------------Pearson 48.93990 7 .00000Likelihood Ratio 54.18568 7 .000001/13/19 ED 793 Lab2Expected Value = (Row Total*Column Total)/Grand TotalIf Significance < .05 then the relationship is statistically significantMantel-Haenszel test for 34.89732 1 .00000linear associationMissing Data Analysistemporary.select if missing(hsgpa)=1.frequencies var=sex racegrp.MISSING DATA ON HSGPA: Valid CumValue Label Value Frequency Percent Percent PercentMALE 1 36 50.7 50.7 50.7FEMALE 2 35 49.3 49.3 100.0 ------- ------- ------- Total 71 100.0 100.0 Valid CumValue Label Value Frequency Percent Percent PercentWhite 1 38 53.5 59.4 59.4African American 2 7 9.9 10.9 70.3Am Ind/Hispanic 3 2 2.8 3.1 73.4Asian 4 15 21.1 23.4 96.9Multicultural 5 2 2.8 3.1 100.0 . 7 9.9 Missing ------- ------- ------- Total 71 100.0 100.0TOTAL SAMPLE: Valid CumValue Label Value Frequency Percent Percent PercentMALE 1 2300 49.1 49.1 49.1FEMALE 2 2381 50.9 50.9 100.0 ------- ------- ------- Total 4681 100.0 100.0 Valid CumValue Label Value Frequency Percent Percent PercentWhite 1 3299 70.5 73.1 73.1African American 2 294 6.3 6.5 79.6Am Ind/Hispanic 3 220 4.7 4.9 84.5Asian 4 568 12.1 12.6 97.1Multicultural 5 130 2.8 2.9 100.0 . 170 3.6 Missing ------- ------- -------1/13/19 ED 793 Lab3This function is a logical operator. It is a 1 if hsgpa is missing and it is a 0 if hsgpa is not missing. The select ifstatement allows you to take subsample of your data.Total 4681 100.0 100.0NOTE: If you plan to use a race variable in any of your analyses, use the RACEGRP variable thatwas created at the end of the file. It