![Page 1: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/1.jpg)
Data Analysis Lab 02 Using Crosstabs to compare percentages
![Page 2: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/2.jpg)
Open your Excel Dataset from Lab 1 and rename this lab 2, then highlight all the data, insert, pivot table,
name the pivot table tab “Lab 2 Crosstabs”
![Page 3: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/3.jpg)
Put Wordsum in Row and Values, leave the values as count
![Page 4: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/4.jpg)
Group into less than 5 words correct and 5 or more words correct
![Page 5: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/5.jpg)
Remove the old WORDSUM
![Page 6: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/6.jpg)
Remove the non answers
![Page 7: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/7.jpg)
Add Sex to the Row, label Male and Female, Put WORSUM2 in Column
![Page 8: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/8.jpg)
Copy with extra space around it, paste a copy next to it
![Page 9: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/9.jpg)
Change second chart to % of row total
![Page 10: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/10.jpg)
For Both Charts, reorder the DV so the 5+ is second, by clicking and dragging it
![Page 11: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/11.jpg)
Now Copy them both and paste below
![Page 12: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/12.jpg)
For Both Copies Replace Sex With, race and add labels Race, and add labels
![Page 13: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/13.jpg)
Then copy these Race and Wordsum Charts and paste them below and replace race with Degree
![Page 14: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/14.jpg)
Add labels for degree
![Page 15: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/15.jpg)
Use Page Layout and View, Page Break Preview to print all 6 charts on 1 page
![Page 16: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/16.jpg)
Next Check to see if your analysis is statistically significant
It seems that gender does not matter but that race and degree do.
![Page 17: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/17.jpg)
Save your dataset at the end of each lab
![Page 18: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/18.jpg)
![Page 19: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/19.jpg)
![Page 20: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/20.jpg)
Be sure to remove any older variables if they are in there
![Page 21: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/21.jpg)
![Page 22: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/22.jpg)
![Page 23: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/23.jpg)
Press change
![Page 24: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/24.jpg)
![Page 25: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/25.jpg)
![Page 26: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/26.jpg)
![Page 27: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/27.jpg)
![Page 28: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/28.jpg)
![Page 29: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/29.jpg)
Need to rename variable to be more accurate- type it right here in variable view
![Page 30: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/30.jpg)
Change the label too
![Page 31: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/31.jpg)
Next do the analysis of this DV by the following IV’s: Sex, Race and Degree
![Page 32: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/32.jpg)
![Page 33: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/33.jpg)
![Page 34: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/34.jpg)
![Page 35: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/35.jpg)
![Page 36: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/36.jpg)
![Page 37: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/37.jpg)
![Page 38: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/38.jpg)
Do the same with race
![Page 39: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/39.jpg)
![Page 40: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/40.jpg)
![Page 41: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/41.jpg)
Now do it with degree
![Page 42: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/42.jpg)
![Page 43: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/43.jpg)
![Page 44: Data Analysis Lab 02 Using Crosstabs to compare percentages](https://reader030.vdocuments.us/reader030/viewer/2022032607/56649eda5503460f94be96b1/html5/thumbnails/44.jpg)
Save your dataset at the end of each lab