You will be asked to conduct a Chi-Square analysis using the table below by using the Five Step process, Be sure to download this Excel file and complete the tables
Compute your expected frequencies using the method I showed you in Excel and upload your spreadsheet. I want to see the following:
Using the spreadsheet you downloaded, please complete the following:
- A table of expected frequencies (5pts)
- A table of chi-square square statistics (5pts)
- State your chi-square statistic (2pts)
- Report your degrees of freedom (2pts)
- Run your chi-square test for your p value (2pts)
- Be sure to show your work (input the commands in each cell) (5pts)