Hello, please see attachment. I need an explaination with excel. I know how to do on paper , but not with formulas in excel

10.66 The owner of a restaurant that serves Continental-style entrees has the business objective of learning more about the pat- terns of patron demand during the Friday-to-Sunday weekend time period. She decided to study the demand for dessert during this time period. In addition to studying whether a dessert was ordered, she will study the gender of the individual and whether a beef entree was ordered. Data were collected from 630 customers and organized in the following contingency tables: GENDER DESSERT ORDERED Male Female Total Yes 50 96 146 No 250 234 484 Total 300 330 630 BEEF ENTREE DESSERT ORDERED Yes No Total Yes 74 68 142 No 123 365 488 Total 197 433 630 a. At the 0.05 level of significance, is there evidence of a differ- ence between males and females in the proportion who order dessert? b. At the 0.05 level of significance, is there evidence of a differ- ence in the proportion who order dessert based on whether a beef entree has been ordered