Conduct a chi-square test from Chapter 11 in Excel with an example dataset; include table of observed vs expected.  Excel Directions:  Chi-Square:  Build observed counts table.  Calculate expected counts: = (row_total * col_total

Conduct a chi-square test from Chapter 11 in Excel with an example dataset; include table of observed vs expected.  Excel Directions:  Chi-Square:  Build observed counts table.  Calculate expected counts: = (row_total * col_total) / grand_total.  Compute (Observed – Expected)² / Expected in each cell and sum => chi-square statistic.  Use =CHISQ.DIST.RT(chi_square_stat, df) to compute p-value.  https://openstax.org/books/introductory-statistics-2e/pages/10-1-two-population-means-with-unknown-standard-deviations