The dataset "Demographics" presents undergraduate participant data for gender and parenthood status. The research predicts that undergraduate females will be more likely to report that they are a parent compared to undergraduate males. Use the countifs function to complete the observed frequency table. The formulas for row/column totals and the formulas to complete the observed frequency table are already entered (values will appear when you complete the observed frequency table). Next, use excel formulas to compute the p value and Chi-square statistic. Report your findings in APA format below. Upload your completed excel file separately. Part 3 (10 points) The dataset "Supermodel" presents the salary, age, number of years spent modelling, and beauty rating of 231 supermodels. Select any two variables and use excel formulas or the data analysis toolpak to conduct a correlation analysis. Report your findings in APA format below. You can get your p value here: https://www.socscistatistics.com/pvalues/pearsondistribution.aspx