Skip to Main Content

Concordian International School

Math IA: Statistics & probability

Linear Regression (code: 6)

R-Squared intuition (code: 7)

Chi Square (code: 10)

Chi-Square Tests

Use the following spreadsheet to carry out a chi-square test for independence, given a table of bivariate numerical data:

bivariate_categorical_data_and_chi-square_test_for_independence.xls

Use this spreadsheet to carry out a chi-square test for goodness-of-fit:

chi-square_test_for_goodness-of-fit.xls

Normal Distribution (code: 8)

Standard Deviation & Standard Error (code: 9)

Excel can do more than you think