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.53% | 146 |
| 2 | 10.31% | 2839 |
| 3 | 16.61% | 4574 |
| 4 | 53.03% | 14605 |
| 5 | 19.52% | 5376 |
| 100% | 27542 | |
| The average efficacy with a population of 27542 is 21.8717. The data suggests all patients in US will have efficacy results between 19.68453 and 24.05887 | ||
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 |
|---|