Question: use the data to answer the following questions Use StatCrunch to produce a two-way contingency table as we did in Unit 3 (Module 8). Use

use the data to answer the following questions
- Use StatCrunch to produce a two-way contingency table as we did in Unit 3 (Module 8). Use the row variablegenderand column variableclass.
- Copy the table in your StatCrunch output window and paste it in your response.
- After you paste the content of your StatCrunch output window into your discussion post, keep the table titledContingency table results,and delete theChi-Square results.
- Analyze the data in your two-way table by findingappropriatepercentages for each bullet point below. Write each conditional percentage as a ratio (e.g. 25 out of 40) and as a percentage (e.g. 25/40 = 62.5%).
- What percentage of students are females?
- What percentage of students are males and seniors?
- What percentage of female students are sophomores?
- What percentage of first-year students are male?


Calibri 11 A A E = ab Wrap Text AY O 4 Paste = Merge & Center $ ~ % " .00 Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate i POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... A1 X V Gender A E C D E F G H J K L M N 0 P Q R S T U W X Y Z AA AB AC Gender Class Hours Work Loans CC Deb 2 Female 4 15 7763 3 Female 18 3010 1177 4 Female 15 1394 5 Male 12 24 15555 2643 6 Female 4 40.5 1623 0 7 Female 18 0 12867 5032 8 Male 15 17.5 11543 4253 9 Female 14 0 0 2747 10 Female 4 43.5 16141 6994 11 0 0 1371 12 Male 2 17 6496 352 13 Female 0 1261 14 Female 18 0 1187 15 Male 21 7.5 6925 2917 16 Female 15 0 3506 17 Female 17 0 2873 18 Male 12 0 11868 6300 19 Male 19 9.5 10137 5040 20 Male 0 3900 1600 21 Male 12 0 7325 4191 22 Male 9473 23 Female 12 1364 0 0 24 Male 9 3930 25 Female 3 42 16551 6422 26 Male 20 7979 3178 27 Male 12 O 3663 28 Female 1917 29 Female 16 5 48RR 1249 StatCrunch_U_Survey_results (1 + E Ready - + 70% O Type here to search 9:36 PM ST X ARO 5/26/2021Calibri - 11 a Wrap Text Ex AY O Paste BIU~ E : Merge & Center $ ~ % " .00 Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate X i POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... X A1 X Gender A B E F G H J K L M N 0 P Q R S T U V W X Y Z AA AB AC C 24 Male 0 3930 25 Female 3 42 16551 6422 26 Male 20 7979 317 27 Male 16 12 0 3663 28 Female 16 0 0 1917 29 Female 15 16.5 4886 1249 30 Male 3 31.5 14909 10527 31 Male 17 10852 5302 32 Female 17 0 33 Female 9 24.5 13018 2279 34 Male 20 0 495 1605 35 Female 12 0 0 0 36 Male 15 0 5846 1907 37 Female 14 21.5 14287 2563 38 Female 12 0 1344 39 Male 20 0 3403 40 Female 15 2504 41 Female 16 17.5 1197 42 Female 15 0 6900 43 Male 16 O 3778 44 Male 13 0 1638 45 Female 15 18.5 6514 1050 46 Female 4 35 16561 2683 47 Female 16 0 16020 220 48 Male 22 2187 1465 49 Female 0 0 6997 50 Female 0 1189 2712 51 Female 13 3846 0 52 StatCrunch_U_Survey_results (1 + Ready - - + 70% 9:42 PM O Type here to search X ARO 5/26/2021
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
