SELECT *, Avg(efficacy) as eAvg, count(*) as eCount FROM cases WHERE 1=1 GROUP BY efficacy
Cannabis Efficacy
| Efficacy | % of Total Patients | # of Patients |
|---|---|---|
| 1 | 0.5% | 181 |
| 2 | 8.13% | 2945 |
| 3 | 14.25% | 5160 |
| 4 | 56.56% | 20483 |
| 5 | 20.56% | 7445 |
| 100% | 36214 | |
| The average efficacy with a population of 36214 is 3.8855. The data suggests all patients in US will have efficacy results between 3.49695 and 4.27405 | ||
Efficacy Ratings
EFFICACY RATING LEGEND:
1 - Adverse Reaction
2 - No Change
3 - Partial Resolution of Symptoms
4 - Significant Resolution of Symptoms
5 - Total Resolution of Symptoms
Efficacy by Age & Gender
The following is a breakdown of efficacy averages by age and gender of the patients.
Most Effective Delivery Modes
The following is a breakdown of which delivery modes were used while having an efficacy rating of 4 or 5.
Most Effective Treatment
Below is a breakdown of treatments having an efficacy rating of 4 or 5, along with the number of times they were used effectively.
| Delivery Mode | Cannabis Profile | Daily Dosage | Est. Cost | # of times used effectively |
|---|