Calculate the Appeal Score

**Calculate the Appeal Score:**

Use the responses from the column **"[Column with Likert scale ratings]"** in the attached CSV to calculate the Appeal score using the following formula:

Appeal score = (sum of all Likert ratings in **[Column with Likert scale ratings]**) divided by (number of responses) ÷ 5

Likert Ratings are coded as:

- Very Satisfied = 5
- Satisfied = 4
- Neutral = 3
- Dissatisfied = 2
- Very Dissatisfied = 1

After calculating the Appeal score, report where it lands on the following scale:

- **Very Good** = above 90%
- **Good** = 70–89%
- **Average** = 50–69%
- **Poor** = 30–49%
- **Very Poor** = 0–29%

Next, analyze the responses in the column **"[Column with qualitative explanations]"** in the CSV to identify common themes and provide clear, actionable suggestions for how the Appeal score could be improved.

📊 Appeal Score Calculation

- **Total Likert sum** = 370
- **Number of responses (N)** = 101
- **Maximum possible score** = 101 × 5 = 505

\text{Appeal Score} = \frac{370}{505} = 0.733 \; \text{(73.3%)}

---

✅ Scale Placement

**Appeal Score = 73.3% → Good (70–89%)**