Can someone explain how to figure this out? The regular (column total * row total / over all total) did not work.

*Note: If you can show step-by-step equations it would be helpful for me to follow. Also, if you have excel formulas, (not add-ons), it would help as well.

Thank you in advance for your help.

How big is your family? A survey asked a sample of 2/80 adults how many children they had, and also how many siblings (brothers and sisters) they had. The results are summarized in the following contingency table. Number of Children Siblings 2 3 4 More than 4 0 52 19 31 13 10 5 180 56 102 45 28 20 2 180 58 102 45 28 18 3 119 34 56 32 20 15 56 18 32 14 10 6 More than 4 60 19 31 11 10 9 Send data to Excel Part: 0 / 2 Part 1 of 2 (a) Compute the expected frequencies under the null hypothesis. Round your answers to two decimal places. Number of Children Siblings 0 1 2 3 4 More than 4 0 18.26 32.58 14.32 9.49 6.53 1 181.05 56.22 100.31 44.09 29.21 20.12 2 181.05 100.31 29.21 20.12 3 120.14 37.30 66.56 29.26 19.38 13.35 57.13 31.65 9.22 6.35 More than 4 58.81 18.26 32.58 14.3 9.49 6.53 X 5