PLEASE SHOW HOW TO DO THESE QUESTIONS IN EXCEL. (Screenshot of excel functions)

I know how to do these questions by hand but I do not know the excel functions necessary to complete them.

?

Question 16 O pts The National Center for Education Statistics would like to test the hypothesis that the proportion of Bachelor's degrees that were earned by women equals 0.60. A random sample of 140 college graduates with Bachelor degrees found that 75 were women. The National Center for Education Statistics would like to set a = 0.10. The conclusion for this hypothesis test would be that because the absolute value of the test statistic is. more than the absolute value of the critical value, we can conclude that the proportion of Bachelor's degrees that were earned by women equals 0.60. O more than the absolute value of the critical value, we can conclude that the proportion of Bachelor's degrees that were earned by women does not equal 0.60. O less than the absolute value of the critical value, we cannot conclude that the proportion of Bachelor's degrees that were earned by women does not equal 0.60. O less than the absolute value of the critical value, we can conclude that the proportion of Bachelor's degrees that were earned by women does not equal 0.60. Question 12 O pts Many franchisers favor owners who operate multiple stores by providing them with preferential treatment. Suppose the Small Business Administration would like to perform a hypothesis test to investigate if 80% of franchisees own only one location using a = 0.05. A random sample of 120 franchisees found that 85 owned only one store. The p-value for this hypothesis test would be O 0.0121 O 0.0320 O 0.0759 O 0.1236