Open recovered workbooks? Your recent changes were saved. Do you want to continue working wh... 1. A public program plans to provide free STIs vaccines to reduce STI cases in a community. They want B11 4 x v fx you to evaluate the potential impact of vaccines on total cases of STIs before the implementation of the policy. B C D E F G Baseline Risky Sexual Encounters Estimate of Price Elasticity of Demand for Risky Sexual En The baseline (pre-policy) risky sexual encounters is 1000. The baseline STI incidence is 20 out of 100 1000 -1.5 risky sexual encounters (i.e., the incidence is 20% or 0.2). The vaccine has been proven to reduce STI incidence to 5 out of 100 risky sexual encounters (i.e., the incidence is 5% or 0.05). Baseline STI incidence (out of 100) 20% Researchers estimated that the price elasticity of risky sexual encounters (as follows) is -1.5. 10 Step 1. Baseline STI cases 11 12 Ep = (% change in risky sexual encounters)/(% change in STI incidence) 13 Post-Policy STI incidence (out of 100) 5% The public program considers the policy a success if it reduces the STI cases. Please use the 15 16 EXCEL spreadsheet to predict whether this program will be a success. 17 Step 2. Percentage Change in STI incidence 18 Step 1. Calculate the baseline STI cases 19 20 21 Step 3. Percentage Change in Risky Sexual Encounters Step 2. Calculate the percentage change in STI incidence after the policy 22 23 Step 3. Calculate the percentage change in risky sexual encounters after the policy 24 25 Step 4. Post-policy Numbers of Risky Sexual Encounters Step 4. Calculate the post-policy number of risky sexual encounters Step 5. Calculate the post-policy number of STI cases Step 5. Post-policy cases of STIs Step 6. Based on your prediction, is this policy likely to be a success? Briefly, explain. Step 6. Based on your prediction, is this policy likely to be a success? Briefly explain. Please upload the completed EXCEL spreadsheet used for calculation and explanation for step 6 to the D2L dropbox