Using the data in the provided Excel file, complete the case study from class on covid vaccine efficiency using Israeli data broken down into finer cohorts.

a. Compute the unvaccinated severe risk for each group relative to the 30-39 group. (Hint: For each group, divide their severe risk per 100k by the 30-39 group's value of 6.2. For instance, the 30-39 group would have a relative risk score of 6.2/6.2 = 1.) Interpret this measure of risk - what does it mean?

b. Compete the vaccine efficiency rating (VE= 1- V/N) for each group. What do you make of the value of the 81-89 group compared with the others?

c. Write a summary of your results.