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.61% | 130 |
| 2 | 10.83% | 2319 |
| 3 | 19.28% | 4127 |
| 4 | 50.86% | 10890 |
| 5 | 18.42% | 3943 |
| 100% | 21411 | |
| The average efficacy with a population of 21411 is 3.8093. The data suggests all patients in US will have efficacy results between 3.42837 and 4.19023 | ||
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 |
|---|