5. Hypothesis Testing for the Difference in 2 |Group Proportions: 2 points a. Is there any difference in the proportion of cats and the proportion of dogs owned by residents of Indiana? A sample of over 500 Indiana residents were selected and asked a series of question including whether or not they had a pet dog or pet cat. The EXCEL data file appears below: fcontentfenforcedfo10318wl.202310.5TAT.35000.103flndiana Surveyxlsx Test at .05 whether the proportion of dog owners is GREATER than the proportion of cat owners in Indiana. Show all 5 steps. HINTS: 1. While the samples are not independent this may impact your results. If you are using MINITAB the FISHER's exact test will provide the better results than the 2 sample z-test 2. If you find a different in the %'s indicate what % is HIGHER or LOWER