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 |
---|