You will be asked to conduct a Chi-Square analysis using the table below by us

  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)