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.51% | 166 |
| 2 | 8.97% | 2898 |
| 3 | 15.15% | 4895 |
| 4 | 55.07% | 17795 |
| 5 | 20.29% | 6557 |
| 100% | 32313 | |
| The average efficacy with a population of 32313 is 66462.6703. The data suggests all patients in US will have efficacy results between 59816.40327 and 73108.93733 | ||
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 |
|---|