If possible please show how to compute in excel.
Shoppers were asked about their regular grocery...
Shoppers were asked about their regular grocery shopping locations. The table below shows the responses of the sampled shoppers. We are interested in determining if the proportions of females in the three categories are different from each other Grocery chain scountMembership store ender warehouse Total Female 220 80 90 390 Male 80 70 60 210 Total 300 150 150 600 a. Provide the null and alternative hypotheses. b. Determine the expected frequencies c. Compute the sample proportions. d. Compute the critical values (CVi;) at the .10 level. Using pairwise comparisons, provide evidence showing which (if any) proportions are indeed different.