2 uses categorical data therefore, we need to perform a hypothesis test for proportions. Again, always start by stating your null and alternative hypothesis. State the significance level as = .05. Find p-hat by using the "Sort & Filter" feature on Excel to sort the type of university; i.e., public or private, count the public ones and form your proportion of universities that are public. Since n*p > 5 and n*q > 5, we can use a normal distribution for our test. Find the cv. Find the STS