Task he84c0f2

Use the churn and WinLoss data, and assume the following: 

- Competitor Loss Ratio = (Total Contract Value of Lost deals/Total Contract Value of all deals)
- If competitor-lost deal value exceeds the retained renewal ARR for that tier: Increase the churned ARR for that tier by 15%
- If retained renewal ARR exceeds competitor-lost deal value: Reduce the competitor-lost contract value by 50%
- Severity Score = Adjusted Competitor Pressure + (Adjusted Churn Rate x (Adjusted Competitor Lost Value/ ...

Here are the answers to all of your questions: 

1. Which pricing tier has the highest severity score? "Team"
2. What is the highest severity score? 0.28
3. For the tier identified with the highest severity score, what is the single most frequent competitor appearing in lost deals? "Make"
4. For the tier identified with the highest severity score, calculate the Severity Score to Adjusted Churn Rate ratio? 1.49
5. For the tier identified with the highest severity score, calculate the Competitive Exposure Multiplier? 1.28
6. For the tier identified with the highest severity score, calculate the Scenario Sensitivity Factor? 0.12