K-12 Analysis
Josh Wilson
2/11/2021
| Year | Mktg | MQLs | Visits | Pipeline | Units |
|---|---|---|---|---|---|
| 2016 | 0 | 11 | 11 | 11 | 1 |
| 2017 | 0 | 262 | 249 | 188 | 29 |
| 2018 | 194 | 354 | 311 | 299 | 52 |
| 2019 | 2180 | 295 | 225 | 224 | 62 |
| 2020 | 2491 | 149 | 107 | 97 | 28 |
Percent Free & Reduced Lunch
Local Revenue
Federal Revenue
Instructional Expenditures
Total Students
Hispanic Student Population
Agency Type
| AgencyType | n | Mktg | MQLs | Visits | Pipeline | Units |
|---|---|---|---|---|---|---|
| 79 | 3 | 0 | 0 | 0 | 0 | |
| 1-Regular local school district that is NOT a component of a supervisory union | 45894 | 4813 | 1058 | 894 | 812 | 171 |
| 2-Local school district that is a component of a supervisory union | 797 | 38 | 2 | 2 | 2 | 1 |
| 3-Supervisory union administrative center (or county superintendent’s office serving the same purpose) | 8 | 1 | 1 | 0 | 0 | 0 |
| 4-Regional Education Service Agency (RESA) | 80 | 9 | 10 | 7 | 5 | 0 |
| 5-State agency providing elementary and/or secondary level instruction | 5 | 1 | 0 | 0 | 0 | 0 |
| 7-Independent Charter District | 5 | 0 | 0 | 0 | 0 | 0 |
Hot Spot Analysis
The purpose of this analysis is to understand where PDRs have devoted time, where they have been most efficacious in getting leads to move downfunnel, and what trends can we see across time.
I have two key recommendations across this entire analysis:
It seems like we have room to increase the volume of people we speak to. And, I don’t mean we should ‘spray and pray’. I think we can be strategic about who we target. The decreasing number of people we speak to definitely has downstream implications.
I think we need to build a better feedback loop between the data and PDRs/PDEs. We have so many K-12 accounts without connections to LEA IDs; the data in SF for K-12 is 2 years behind what is in the national database and our backend; and a lot of firmographic data is not at the fingertips of PDRs/PDEs.
Next Steps:
I’d love to provide the PDRs and PDEs with a set of accounts that have not received attention lately BUT could be viable based on the findings below.
Start a project to update information in SF.
Provide the PDEs/PDRs with a dashboard to help filter schools - if they want this.
Baseline on Key Metrics
For the baselines, these are good to keep in mind when you look at the same metrics cut in various ways. Note that PLtoVisit and PLtoSQL are roughly the same, meaning that when we get a visit, we tend to convert those accounts to pipeline.
| PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|
| 650 | 9.3% | 6.5% | 6.0% | 1.5% |
Looking at Key Metrics Across Quarters
The natural first place to start is with viewing key metrics across the quarters. All dates are in CY.
Instances where you see PLtoSQL > PLtoVisit means there was no visit logged, suggesting we jumped from a phone call to a proposal.
Key Thoughts:
- With the exceptino of CY20 Q2, we have been decreasing the number of people we speak to in the market.
- Across Calendar Year 19, we see decreasing efficacy across all of the metrics, with a small blip for PLtoVisit and PLtoSQL in Q3.
- The trend in CY 19 continued into the beginning of 2020 and then COVID hit, blowing up PL to Unit.
- Bright Spot: The past couple of quarters have shown some positive movements on the key metrics; we have not returned to CY19 averages.
| Outreach Quarter | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| 2019.1 | 832 | 13.6% | 10.0% | 10.9% | 2.6% |
| 2019.2 | 751 | 11.7% | 7.7% | 8.0% | 2.8% |
| 2019.3 | 703 | 12.8% | 9.7% | 8.1% | 1.8% |
| 2019.4 | 627 | 10.7% | 6.5% | 5.6% | 1.4% |
| 2020.1 | 539 | 6.7% | 4.3% | 3.3% | 0.9% |
| 2020.2 | 1025 | 3.5% | 1.9% | 1.9% | 0.5% |
| 2020.3 | 563 | 7.6% | 6.6% | 6.0% | 1.2% |
| 2020.4 | 425 | 8.0% | 6.1% | 4.5% | 1.2% |
| 2021.1 | 160 | 11.2% | 6.2% | 1.2% | 0.0% |
Let’s start to understand what’s happening beneath the movements in the key metrics. First, we break the key metrics out by state, for all of the data, to see if there are States where we spend a lot of time and underperform or vice versa.
- Illinois, Missouri, Virginia, Kansas, and Arizona are states where we see strong PL to Unit. Kansas and Arizona are on the smaller side of our focus.
- Texas, PA, Ohio, and Michigan all get a lot of attention without as much of a return.
- And, it looks as though some states are very difficult to get to visit and beyond: New Hampshire, Nevada, Louisiana, Alabama, etc. Perhaps, we only attend to these states when a lead comes in Warm?
- For States like Kentucky and Mississippi, et al., where have seen some pipeline yet have not closed Units, we need some more context on what is happening before making any decision regarding how to allocation attention.
| PrimaryState | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| TX | 659 | 7.6% | 4.1% | 4.7% | 0.6% |
| CA | 540 | 5.6% | 3.9% | 3.5% | 1.7% |
| NY | 486 | 8.2% | 5.8% | 5.1% | 1.2% |
| IL | 334 | 14.1% | 10.2% | 10.5% | 3.9% |
| PA | 275 | 8.4% | 5.5% | 4.4% | 0.7% |
| OH | 258 | 10.5% | 8.1% | 5.8% | 0.4% |
| MO | 245 | 11.0% | 8.2% | 9.4% | 2.4% |
| VA | 223 | 14.3% | 11.2% | 10.8% | 2.2% |
| MI | 220 | 13.2% | 10.5% | 6.8% | 0.5% |
| NJ | 193 | 9.8% | 6.7% | 5.7% | 1.6% |
| WI | 184 | 7.1% | 4.3% | 4.3% | 1.6% |
| MA | 143 | 10.5% | 6.3% | 7.0% | 1.4% |
| IN | 130 | 6.2% | 2.3% | 4.6% | 1.5% |
| GA | 120 | 6.7% | 5.8% | 5.8% | 1.7% |
| KS | 115 | 22.6% | 17.4% | 12.2% | 5.2% |
| MN | 113 | 7.1% | 4.4% | 4.4% | 1.8% |
| NC | 101 | 6.9% | 5.0% | 5.0% | 1.0% |
| WA | 89 | 14.6% | 13.5% | 11.2% | 1.1% |
| KY | 86 | 9.3% | 2.3% | 3.5% | 0.0% |
| OR | 84 | 7.1% | 6.0% | 3.6% | 1.2% |
| CT | 83 | 8.4% | 7.2% | 2.4% | 0.0% |
| FL | 82 | 4.9% | 2.4% | 1.2% | 0.0% |
| AZ | 79 | 16.5% | 12.7% | 12.7% | 7.6% |
| MS | 77 | 5.2% | 1.3% | 2.6% | 0.0% |
| SC | 71 | 11.3% | 9.9% | 7.0% | 4.2% |
| CO | 62 | 1.6% | 1.6% | 1.6% | 0.0% |
| NM | 56 | 12.5% | 8.9% | 10.7% | 5.4% |
| OK | 44 | 9.1% | 9.1% | 9.1% | 0.0% |
| AL | 40 | 10.0% | 10.0% | 7.5% | 0.0% |
| IA | 40 | 2.5% | 2.5% | 2.5% | 2.5% |
| LA | 40 | 2.5% | 0.0% | 0.0% | 0.0% |
| AR | 38 | 2.6% | 0.0% | 0.0% | 0.0% |
| TN | 37 | 13.5% | 2.7% | 2.7% | 2.7% |
| NE | 35 | 22.9% | 17.1% | 17.1% | 2.9% |
| ME | 30 | 6.7% | 3.3% | 6.7% | 0.0% |
| RI | 29 | 10.3% | 10.3% | 6.9% | 3.4% |
| UT | 29 | 13.8% | 10.3% | 6.9% | 0.0% |
| NH | 26 | 0.0% | 0.0% | 0.0% | 0.0% |
| MD | 22 | 9.1% | 4.5% | 9.1% | 0.0% |
| NV | 20 | 0.0% | 0.0% | 0.0% | 0.0% |
| AK | 13 | 30.8% | 23.1% | 15.4% | 7.7% |
| SD | 13 | 7.7% | 7.7% | 7.7% | 0.0% |
| ND | 12 | 8.3% | 0.0% | 0.0% | 0.0% |
| WV | 12 | 16.7% | 8.3% | 8.3% | 0.0% |
| DE | 8 | 12.5% | 12.5% | 0.0% | 0.0% |
| ID | 8 | 0.0% | 0.0% | 0.0% | 0.0% |
| DC | 7 | 14.3% | 0.0% | 0.0% | 0.0% |
| VT | 7 | 0.0% | 0.0% | 0.0% | 0.0% |
| WY | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| MT | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
Key Metrics by Locale
- There are PLs with ‘NA’ meaning the data is missing. This is because the accounts in SF do not have an LEA ID tagged to them. In a subsequent round of this, I’ll have that patched. I went through the data yesterday and tagged about 261 Accounts which had an MQL or Visit in the last year.
- We spend most of our time talking to Large Suburbs and they convert at the average, meaning most of our Units are for these types of schools.
- Surprisingly, Town: Distant and City: Mid Size stand out as performing well across all parts of the funnel.
- Whatever is buried in NA, Mid Sized Suburbs, and Remote seem to be underperforming locales.
| Locale | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| 21-Suburb: Large | 1673 | 10.3% | 7.5% | 7.1% | 1.5% |
| NA | 1147 | 5.5% | 2.7% | 2.1% | 0.4% |
| 41-Rural: Fringe | 480 | 10.0% | 6.7% | 6.9% | 1.7% |
| 32-Town: Distant | 426 | 12.9% | 10.1% | 8.9% | 2.6% |
| 42-Rural: Distant | 333 | 9.6% | 6.9% | 6.9% | 2.1% |
| 13-City: Small | 322 | 10.2% | 7.1% | 6.5% | 1.6% |
| 12-City: Mid-size | 257 | 12.8% | 8.2% | 8.9% | 3.9% |
| 33-Town: Remote | 242 | 10.3% | 6.6% | 5.8% | 1.7% |
| 31-Town: Fringe | 229 | 6.6% | 6.1% | 4.8% | 1.7% |
| 11-City: Large | 216 | 10.6% | 7.4% | 6.5% | 1.9% |
| 22-Suburb: Mid-size | 161 | 8.7% | 6.8% | 4.3% | 0.6% |
| 23-Suburb: Small | 94 | 7.4% | 6.4% | 6.4% | 3.2% |
| 43-Rural: Remote | 45 | 11.1% | 8.9% | 6.7% | 0.0% |
Town Distant and State
We wanted to take a quick look at the why Town Distant locales appear to be doing well. Seems to be driven by out-performance in a few key states: NY, IL, KY, and NE.
| Locale | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| TX | 56 | 12.5% | 5.4% | 8.9% | 1.8% |
| NY | 38 | 15.8% | 13.2% | 13.2% | 5.3% |
| WI | 31 | 6.5% | 3.2% | 3.2% | 0.0% |
| OH | 30 | 20.0% | 16.7% | 6.7% | 3.3% |
| CA | 29 | 6.9% | 3.4% | 3.4% | 0.0% |
| MO | 22 | 9.1% | 9.1% | 9.1% | 4.5% |
| KS | 21 | 42.9% | 38.1% | 33.3% | 14.3% |
| IL | 19 | 26.3% | 26.3% | 26.3% | 10.5% |
| VA | 19 | 15.8% | 10.5% | 10.5% | 0.0% |
| MI | 17 | 5.9% | 5.9% | 0.0% | 0.0% |
| MN | 15 | 13.3% | 6.7% | 6.7% | 0.0% |
| KY | 12 | 8.3% | 0.0% | 0.0% | 0.0% |
| OR | 12 | 0.0% | 0.0% | 0.0% | 0.0% |
| IN | 10 | 0.0% | 0.0% | 0.0% | 0.0% |
| UT | 7 | 28.6% | 28.6% | 14.3% | 0.0% |
| AL | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| AR | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| NC | 6 | 16.7% | 16.7% | 16.7% | 0.0% |
| NE | 6 | 50.0% | 50.0% | 50.0% | 16.7% |
| OK | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| WA | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| FL | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| GA | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| IA | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| MS | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| PA | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| SC | 5 | 20.0% | 20.0% | 20.0% | 0.0% |
| MA | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| MD | 4 | 25.0% | 25.0% | 25.0% | 0.0% |
| TN | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| LA | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| ME | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| NM | 2 | 50.0% | 50.0% | 0.0% | 0.0% |
| AK | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| AZ | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| SD | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| VT | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| WV | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
Mid Size City and State
When we do more and more cuts on these metrics, we get to smaller sample sizes. Even so, it is interesting to see which States are behind the success of each Locale. In this case, we see some States which have not popped before: Georgia, Missouri, Arizona. The N gets small for these states. However, does success in Arizona Mid Sized Cities create a blueprint for neighboring States: Nevada, New Mexico, Utah.
On the other side of the coin, Virginia, Kansas, and Florida have not performed well here. What makes them different from the other States?
| Locale | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| TX | 48 | 12.5% | 8.3% | 10.4% | 0.0% |
| CA | 39 | 10.3% | 5.1% | 2.6% | 2.6% |
| VA | 25 | 4.0% | 0.0% | 0.0% | 0.0% |
| GA | 12 | 41.7% | 33.3% | 33.3% | 16.7% |
| KS | 12 | 0.0% | 0.0% | 0.0% | 0.0% |
| FL | 10 | 0.0% | 0.0% | 0.0% | 0.0% |
| IL | 10 | 60.0% | 50.0% | 60.0% | 40.0% |
| CT | 9 | 0.0% | 0.0% | 0.0% | 0.0% |
| MI | 9 | 0.0% | 0.0% | 0.0% | 0.0% |
| WA | 9 | 22.2% | 11.1% | 11.1% | 0.0% |
| MO | 7 | 42.9% | 28.6% | 28.6% | 14.3% |
| OR | 6 | 16.7% | 0.0% | 0.0% | 0.0% |
| CO | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| MA | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| NC | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| AZ | 4 | 25.0% | 25.0% | 25.0% | 25.0% |
| MN | 4 | 25.0% | 25.0% | 25.0% | 0.0% |
| ND | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| OH | 4 | 25.0% | 25.0% | 25.0% | 0.0% |
| IA | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| NM | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| NY | 3 | 33.3% | 0.0% | 0.0% | 0.0% |
| RI | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| SD | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| AL | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| IN | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| NV | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| PA | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| UT | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| ID | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| MS | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| MT | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| SC | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| WI | 1 | 100.0% | 0.0% | 100.0% | 100.0% |
Key Metrics by Locale - Last 2 Quarters
Checking to see if the aggregated data and the recent quarters are show different results.
We see that Rural Fringe and Rural Distant are not performing as well as they have in the past. Town Distant and Suburb Large appear to remain aligned with past performance. And notably, City Mid Size is seriously struggling, as compared to previous quarters.
| Locale | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| 21-Suburb: Large | 302 | 10.6% | 8.3% | 7.0% | 1.3% |
| NA | 144 | 3.5% | 2.1% | 2.8% | 1.4% |
| 41-Rural: Fringe | 93 | 5.4% | 5.4% | 5.4% | 0.0% |
| 32-Town: Distant | 77 | 9.1% | 9.1% | 7.8% | 0.0% |
| 42-Rural: Distant | 68 | 5.9% | 5.9% | 4.4% | 1.5% |
| 13-City: Small | 55 | 9.1% | 7.3% | 7.3% | 1.8% |
| 11-City: Large | 54 | 9.3% | 5.6% | 5.6% | 1.9% |
| 12-City: Mid-size | 46 | 2.2% | 2.2% | 2.2% | 2.2% |
| 33-Town: Remote | 41 | 7.3% | 7.3% | 2.4% | 2.4% |
| 31-Town: Fringe | 37 | 8.1% | 5.4% | 2.7% | 0.0% |
| 22-Suburb: Mid-size | 36 | 11.1% | 11.1% | 5.6% | 0.0% |
| 23-Suburb: Small | 20 | 5.0% | 5.0% | 5.0% | 5.0% |
| 43-Rural: Remote | 15 | 13.3% | 6.7% | 6.7% | 0.0% |
Illinois by Locale
Illinois seems to be a bright spot and I wanted to see if there was anything of interest beneath the surface. In fact, what you see is some surprisingly high conversion rates for Locales where we tend to spend less time overall.
| Locale | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| 21-Suburb: Large | 126 | 15.1% | 9.5% | 8.7% | 1.6% |
| NA | 122 | 8.2% | 4.9% | 5.7% | 1.6% |
| 32-Town: Distant | 19 | 26.3% | 26.3% | 26.3% | 10.5% |
| 31-Town: Fringe | 14 | 28.6% | 28.6% | 28.6% | 21.4% |
| 41-Rural: Fringe | 13 | 7.7% | 0.0% | 7.7% | 0.0% |
| 12-City: Mid-size | 10 | 60.0% | 50.0% | 60.0% | 40.0% |
| 13-City: Small | 10 | 20.0% | 20.0% | 10.0% | 0.0% |
| 23-Suburb: Small | 7 | 0.0% | 0.0% | 0.0% | 0.0% |
| 42-Rural: Distant | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| 33-Town: Remote | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| 22-Suburb: Mid-size | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| 11-City: Large | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| 43-Rural: Remote | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
Looking at performance by OpEx
The quartiles are determined by where we devote attention (read: outreach) and not by the quartiles which exist within the market. Quartiles: 1M - 36M, 36M - 70M, 70M - 170M, 170M+
Often, we see linear ordering, with larger schools more likely to buy. In this case, we see that small schools and large schools are less likely to purchase than the schools in the middle.
| opex_quart | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| [1.31e+06,3.61e+07] | 1118 | 8.8% | 6.4% | 5.7% | 1.2% |
| (3.61e+07,6.97e+07] | 1120 | 11.6% | 8.8% | 7.9% | 2.2% |
| (6.97e+07,1.7e+08] | 1116 | 10.9% | 7.7% | 7.3% | 2.2% |
| (1.7e+08,5.96e+09] | 1117 | 9.9% | 6.9% | 6.7% | 1.7% |
| NA | 1154 | 5.5% | 2.8% | 2.2% | 0.5% |
Opex Quartile and State
- There are States where we do perform better the larger the school’s operating expense: Illinois and California roughly follow this pattern.
- There are some States where we only succeed in certain quartiles: Georgia (highest quartile), Oregon (lowest quartile), Tennessee (highest quartile).
- There are some states where our success is located more closely towards the median: Texas, New Mexico, and Minnesota.
- There are some States where our success is peripatetic: New York, Missouri, Arizona.
| Primary State | OpEx Quartile | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|---|
| AK | [1.31e+06,3.61e+07] | 2 | 50.0% | 50.0% | 50.0% | 0.0% |
| AK | (6.97e+07,1.7e+08] | 9 | 22.2% | 22.2% | 11.1% | 11.1% |
| AK | (1.7e+08,5.96e+09] | 2 | 50.0% | 0.0% | 0.0% | 0.0% |
| AL | [1.31e+06,3.61e+07] | 17 | 5.9% | 5.9% | 0.0% | 0.0% |
| AL | (3.61e+07,6.97e+07] | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| AL | (6.97e+07,1.7e+08] | 11 | 18.2% | 18.2% | 18.2% | 0.0% |
| AL | (1.7e+08,5.96e+09] | 7 | 14.3% | 14.3% | 14.3% | 0.0% |
| AL | NA | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| AR | [1.31e+06,3.61e+07] | 15 | 0.0% | 0.0% | 0.0% | 0.0% |
| AR | (3.61e+07,6.97e+07] | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| AR | (6.97e+07,1.7e+08] | 10 | 10.0% | 0.0% | 0.0% | 0.0% |
| AR | (1.7e+08,5.96e+09] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| AR | NA | 10 | 0.0% | 0.0% | 0.0% | 0.0% |
| AZ | [1.31e+06,3.61e+07] | 16 | 12.5% | 12.5% | 6.2% | 6.2% |
| AZ | (3.61e+07,6.97e+07] | 13 | 23.1% | 23.1% | 23.1% | 15.4% |
| AZ | (6.97e+07,1.7e+08] | 11 | 27.3% | 18.2% | 18.2% | 9.1% |
| AZ | (1.7e+08,5.96e+09] | 12 | 8.3% | 8.3% | 8.3% | 8.3% |
| AZ | NA | 27 | 14.8% | 7.4% | 11.1% | 3.7% |
| CA | [1.31e+06,3.61e+07] | 46 | 0.0% | 0.0% | 0.0% | 0.0% |
| CA | (3.61e+07,6.97e+07] | 93 | 4.3% | 3.2% | 3.2% | 2.2% |
| CA | (6.97e+07,1.7e+08] | 131 | 6.1% | 3.8% | 3.1% | 2.3% |
| CA | (1.7e+08,5.96e+09] | 158 | 7.6% | 5.1% | 4.4% | 1.9% |
| CA | NA | 112 | 5.4% | 4.5% | 4.5% | 0.9% |
| CO | [1.31e+06,3.61e+07] | 10 | 10.0% | 10.0% | 10.0% | 0.0% |
| CO | (3.61e+07,6.97e+07] | 7 | 0.0% | 0.0% | 0.0% | 0.0% |
| CO | (6.97e+07,1.7e+08] | 7 | 0.0% | 0.0% | 0.0% | 0.0% |
| CO | (1.7e+08,5.96e+09] | 18 | 0.0% | 0.0% | 0.0% | 0.0% |
| CO | NA | 20 | 0.0% | 0.0% | 0.0% | 0.0% |
| CT | [1.31e+06,3.61e+07] | 7 | 14.3% | 0.0% | 0.0% | 0.0% |
| CT | (3.61e+07,6.97e+07] | 20 | 10.0% | 10.0% | 0.0% | 0.0% |
| CT | (6.97e+07,1.7e+08] | 18 | 5.6% | 5.6% | 5.6% | 0.0% |
| CT | (1.7e+08,5.96e+09] | 22 | 9.1% | 9.1% | 4.5% | 0.0% |
| CT | NA | 16 | 6.2% | 6.2% | 0.0% | 0.0% |
| DC | NA | 7 | 14.3% | 0.0% | 0.0% | 0.0% |
| DE | (6.97e+07,1.7e+08] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| DE | (1.7e+08,5.96e+09] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| DE | NA | 6 | 16.7% | 16.7% | 0.0% | 0.0% |
| FL | [1.31e+06,3.61e+07] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| FL | (3.61e+07,6.97e+07] | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| FL | (6.97e+07,1.7e+08] | 9 | 0.0% | 0.0% | 0.0% | 0.0% |
| FL | (1.7e+08,5.96e+09] | 59 | 5.1% | 3.4% | 1.7% | 0.0% |
| FL | NA | 11 | 9.1% | 0.0% | 0.0% | 0.0% |
| GA | [1.31e+06,3.61e+07] | 15 | 0.0% | 0.0% | 0.0% | 0.0% |
| GA | (3.61e+07,6.97e+07] | 17 | 0.0% | 0.0% | 0.0% | 0.0% |
| GA | (6.97e+07,1.7e+08] | 24 | 0.0% | 0.0% | 0.0% | 0.0% |
| GA | (1.7e+08,5.96e+09] | 34 | 23.5% | 20.6% | 20.6% | 5.9% |
| GA | NA | 30 | 0.0% | 0.0% | 0.0% | 0.0% |
| IA | [1.31e+06,3.61e+07] | 14 | 0.0% | 0.0% | 0.0% | 0.0% |
| IA | (3.61e+07,6.97e+07] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| IA | (6.97e+07,1.7e+08] | 15 | 0.0% | 0.0% | 0.0% | 0.0% |
| IA | (1.7e+08,5.96e+09] | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| IA | NA | 2 | 50.0% | 50.0% | 50.0% | 50.0% |
| ID | [1.31e+06,3.61e+07] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| ID | (3.61e+07,6.97e+07] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| ID | (6.97e+07,1.7e+08] | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| ID | (1.7e+08,5.96e+09] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| ID | NA | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| IL | [1.31e+06,3.61e+07] | 39 | 10.3% | 10.3% | 10.3% | 2.6% |
| IL | (3.61e+07,6.97e+07] | 47 | 17.0% | 10.6% | 10.6% | 2.1% |
| IL | (6.97e+07,1.7e+08] | 66 | 18.2% | 12.1% | 12.1% | 4.5% |
| IL | (1.7e+08,5.96e+09] | 60 | 21.7% | 18.3% | 18.3% | 10.0% |
| IL | NA | 122 | 8.2% | 4.9% | 5.7% | 1.6% |
| IN | [1.31e+06,3.61e+07] | 59 | 5.1% | 1.7% | 3.4% | 0.0% |
| IN | (3.61e+07,6.97e+07] | 26 | 3.8% | 3.8% | 3.8% | 3.8% |
| IN | (6.97e+07,1.7e+08] | 20 | 20.0% | 5.0% | 15.0% | 5.0% |
| IN | (1.7e+08,5.96e+09] | 11 | 0.0% | 0.0% | 0.0% | 0.0% |
| IN | NA | 14 | 0.0% | 0.0% | 0.0% | 0.0% |
| KS | [1.31e+06,3.61e+07] | 40 | 32.5% | 30.0% | 20.0% | 7.5% |
| KS | (3.61e+07,6.97e+07] | 26 | 11.5% | 11.5% | 11.5% | 11.5% |
| KS | (6.97e+07,1.7e+08] | 20 | 35.0% | 10.0% | 5.0% | 0.0% |
| KS | (1.7e+08,5.96e+09] | 16 | 6.2% | 6.2% | 6.2% | 0.0% |
| KS | NA | 13 | 15.4% | 15.4% | 7.7% | 0.0% |
| KY | [1.31e+06,3.61e+07] | 16 | 12.5% | 0.0% | 0.0% | 0.0% |
| KY | (3.61e+07,6.97e+07] | 11 | 9.1% | 9.1% | 9.1% | 0.0% |
| KY | (6.97e+07,1.7e+08] | 27 | 7.4% | 3.7% | 7.4% | 0.0% |
| KY | (1.7e+08,5.96e+09] | 11 | 18.2% | 0.0% | 0.0% | 0.0% |
| KY | NA | 21 | 4.8% | 0.0% | 0.0% | 0.0% |
| LA | [1.31e+06,3.61e+07] | 5 | 20.0% | 0.0% | 0.0% | 0.0% |
| LA | (3.61e+07,6.97e+07] | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| LA | (6.97e+07,1.7e+08] | 7 | 0.0% | 0.0% | 0.0% | 0.0% |
| LA | (1.7e+08,5.96e+09] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| LA | NA | 17 | 0.0% | 0.0% | 0.0% | 0.0% |
| MA | [1.31e+06,3.61e+07] | 25 | 8.0% | 8.0% | 8.0% | 4.0% |
| MA | (3.61e+07,6.97e+07] | 31 | 16.1% | 9.7% | 9.7% | 0.0% |
| MA | (6.97e+07,1.7e+08] | 27 | 7.4% | 7.4% | 7.4% | 0.0% |
| MA | (1.7e+08,5.96e+09] | 13 | 0.0% | 0.0% | 0.0% | 0.0% |
| MA | NA | 47 | 12.8% | 4.3% | 6.4% | 2.1% |
| MD | [1.31e+06,3.61e+07] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| MD | (3.61e+07,6.97e+07] | 4 | 25.0% | 25.0% | 25.0% | 0.0% |
| MD | (6.97e+07,1.7e+08] | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| MD | (1.7e+08,5.96e+09] | 10 | 10.0% | 0.0% | 10.0% | 0.0% |
| MD | NA | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| ME | [1.31e+06,3.61e+07] | 15 | 6.7% | 0.0% | 6.7% | 0.0% |
| ME | (3.61e+07,6.97e+07] | 8 | 12.5% | 12.5% | 12.5% | 0.0% |
| ME | (6.97e+07,1.7e+08] | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| ME | NA | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| MI | [1.31e+06,3.61e+07] | 81 | 12.3% | 11.1% | 7.4% | 0.0% |
| MI | (3.61e+07,6.97e+07] | 54 | 16.7% | 13.0% | 7.4% | 1.9% |
| MI | (6.97e+07,1.7e+08] | 33 | 18.2% | 15.2% | 15.2% | 0.0% |
| MI | (1.7e+08,5.96e+09] | 14 | 0.0% | 0.0% | 0.0% | 0.0% |
| MI | NA | 38 | 10.5% | 5.3% | 0.0% | 0.0% |
| MN | [1.31e+06,3.61e+07] | 27 | 7.4% | 3.7% | 3.7% | 0.0% |
| MN | (3.61e+07,6.97e+07] | 15 | 6.7% | 6.7% | 6.7% | 6.7% |
| MN | (6.97e+07,1.7e+08] | 27 | 11.1% | 3.7% | 3.7% | 3.7% |
| MN | (1.7e+08,5.96e+09] | 18 | 11.1% | 11.1% | 11.1% | 0.0% |
| MN | NA | 26 | 0.0% | 0.0% | 0.0% | 0.0% |
| MO | [1.31e+06,3.61e+07] | 62 | 4.8% | 3.2% | 4.8% | 1.6% |
| MO | (3.61e+07,6.97e+07] | 82 | 14.6% | 12.2% | 13.4% | 3.7% |
| MO | (6.97e+07,1.7e+08] | 31 | 12.9% | 12.9% | 12.9% | 3.2% |
| MO | (1.7e+08,5.96e+09] | 30 | 20.0% | 13.3% | 13.3% | 3.3% |
| MO | NA | 40 | 5.0% | 0.0% | 2.5% | 0.0% |
| MS | [1.31e+06,3.61e+07] | 36 | 0.0% | 0.0% | 0.0% | 0.0% |
| MS | (3.61e+07,6.97e+07] | 24 | 8.3% | 4.2% | 4.2% | 0.0% |
| MS | (6.97e+07,1.7e+08] | 5 | 40.0% | 0.0% | 20.0% | 0.0% |
| MS | (1.7e+08,5.96e+09] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| MS | NA | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| MT | (6.97e+07,1.7e+08] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| NC | [1.31e+06,3.61e+07] | 12 | 16.7% | 16.7% | 16.7% | 0.0% |
| NC | (3.61e+07,6.97e+07] | 13 | 7.7% | 7.7% | 7.7% | 0.0% |
| NC | (6.97e+07,1.7e+08] | 22 | 9.1% | 9.1% | 9.1% | 4.5% |
| NC | (1.7e+08,5.96e+09] | 21 | 4.8% | 0.0% | 0.0% | 0.0% |
| NC | NA | 33 | 3.0% | 0.0% | 0.0% | 0.0% |
| ND | (6.97e+07,1.7e+08] | 4 | 25.0% | 0.0% | 0.0% | 0.0% |
| ND | (1.7e+08,5.96e+09] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| ND | NA | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| NE | [1.31e+06,3.61e+07] | 8 | 12.5% | 12.5% | 12.5% | 12.5% |
| NE | (3.61e+07,6.97e+07] | 14 | 35.7% | 21.4% | 21.4% | 0.0% |
| NE | (6.97e+07,1.7e+08] | 5 | 20.0% | 20.0% | 20.0% | 0.0% |
| NE | (1.7e+08,5.96e+09] | 5 | 20.0% | 20.0% | 20.0% | 0.0% |
| NE | NA | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| NH | [1.31e+06,3.61e+07] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| NH | (3.61e+07,6.97e+07] | 15 | 0.0% | 0.0% | 0.0% | 0.0% |
| NH | NA | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| NJ | [1.31e+06,3.61e+07] | 21 | 0.0% | 0.0% | 0.0% | 0.0% |
| NJ | (3.61e+07,6.97e+07] | 39 | 7.7% | 7.7% | 5.1% | 0.0% |
| NJ | (6.97e+07,1.7e+08] | 49 | 18.4% | 16.3% | 14.3% | 6.1% |
| NJ | (1.7e+08,5.96e+09] | 25 | 8.0% | 8.0% | 8.0% | 0.0% |
| NJ | NA | 59 | 8.5% | 0.0% | 0.0% | 0.0% |
| NM | [1.31e+06,3.61e+07] | 9 | 22.2% | 11.1% | 22.2% | 0.0% |
| NM | (3.61e+07,6.97e+07] | 12 | 25.0% | 16.7% | 16.7% | 16.7% |
| NM | (6.97e+07,1.7e+08] | 12 | 8.3% | 8.3% | 8.3% | 8.3% |
| NM | (1.7e+08,5.96e+09] | 12 | 8.3% | 8.3% | 8.3% | 0.0% |
| NM | NA | 11 | 0.0% | 0.0% | 0.0% | 0.0% |
| NV | (3.61e+07,6.97e+07] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| NV | (1.7e+08,5.96e+09] | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| NV | NA | 12 | 0.0% | 0.0% | 0.0% | 0.0% |
| NY | [1.31e+06,3.61e+07] | 144 | 10.4% | 7.6% | 7.6% | 2.1% |
| NY | (3.61e+07,6.97e+07] | 98 | 12.2% | 9.2% | 8.2% | 2.0% |
| NY | (6.97e+07,1.7e+08] | 127 | 4.7% | 3.9% | 3.9% | 0.8% |
| NY | (1.7e+08,5.96e+09] | 43 | 9.3% | 2.3% | 2.3% | 0.0% |
| NY | NA | 74 | 4.1% | 2.7% | 0.0% | 0.0% |
| OH | [1.31e+06,3.61e+07] | 69 | 7.2% | 2.9% | 1.4% | 0.0% |
| OH | (3.61e+07,6.97e+07] | 65 | 9.2% | 7.7% | 3.1% | 0.0% |
| OH | (6.97e+07,1.7e+08] | 71 | 15.5% | 14.1% | 12.7% | 1.4% |
| OH | (1.7e+08,5.96e+09] | 32 | 6.2% | 6.2% | 6.2% | 0.0% |
| OH | NA | 21 | 14.3% | 9.5% | 4.8% | 0.0% |
| OK | [1.31e+06,3.61e+07] | 11 | 0.0% | 0.0% | 0.0% | 0.0% |
| OK | (3.61e+07,6.97e+07] | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| OK | (6.97e+07,1.7e+08] | 10 | 40.0% | 40.0% | 40.0% | 0.0% |
| OK | (1.7e+08,5.96e+09] | 10 | 0.0% | 0.0% | 0.0% | 0.0% |
| OK | NA | 8 | 0.0% | 0.0% | 0.0% | 0.0% |
| OR | [1.31e+06,3.61e+07] | 22 | 9.1% | 9.1% | 9.1% | 4.5% |
| OR | (3.61e+07,6.97e+07] | 12 | 0.0% | 0.0% | 0.0% | 0.0% |
| OR | (6.97e+07,1.7e+08] | 25 | 12.0% | 12.0% | 4.0% | 0.0% |
| OR | (1.7e+08,5.96e+09] | 6 | 16.7% | 0.0% | 0.0% | 0.0% |
| OR | NA | 19 | 0.0% | 0.0% | 0.0% | 0.0% |
| PA | [1.31e+06,3.61e+07] | 43 | 11.6% | 7.0% | 7.0% | 0.0% |
| PA | (3.61e+07,6.97e+07] | 61 | 9.8% | 6.6% | 4.9% | 0.0% |
| PA | (6.97e+07,1.7e+08] | 58 | 12.1% | 6.9% | 6.9% | 1.7% |
| PA | (1.7e+08,5.96e+09] | 33 | 9.1% | 9.1% | 6.1% | 3.0% |
| PA | NA | 80 | 2.5% | 1.2% | 0.0% | 0.0% |
| RI | [1.31e+06,3.61e+07] | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| RI | (3.61e+07,6.97e+07] | 9 | 22.2% | 22.2% | 22.2% | 11.1% |
| RI | (6.97e+07,1.7e+08] | 4 | 25.0% | 25.0% | 0.0% | 0.0% |
| RI | (1.7e+08,5.96e+09] | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| RI | NA | 9 | 0.0% | 0.0% | 0.0% | 0.0% |
| SC | [1.31e+06,3.61e+07] | 8 | 0.0% | 0.0% | 0.0% | 0.0% |
| SC | (3.61e+07,6.97e+07] | 14 | 14.3% | 14.3% | 7.1% | 0.0% |
| SC | (6.97e+07,1.7e+08] | 18 | 16.7% | 11.1% | 11.1% | 11.1% |
| SC | (1.7e+08,5.96e+09] | 20 | 10.0% | 10.0% | 10.0% | 5.0% |
| SC | NA | 11 | 9.1% | 9.1% | 0.0% | 0.0% |
| SD | [1.31e+06,3.61e+07] | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| SD | (3.61e+07,6.97e+07] | 4 | 25.0% | 25.0% | 25.0% | 0.0% |
| SD | (1.7e+08,5.96e+09] | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| SD | NA | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| TN | [1.31e+06,3.61e+07] | 6 | 16.7% | 0.0% | 0.0% | 0.0% |
| TN | (3.61e+07,6.97e+07] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| TN | (6.97e+07,1.7e+08] | 6 | 33.3% | 0.0% | 0.0% | 0.0% |
| TN | (1.7e+08,5.96e+09] | 5 | 40.0% | 20.0% | 20.0% | 20.0% |
| TN | NA | 14 | 0.0% | 0.0% | 0.0% | 0.0% |
| TX | [1.31e+06,3.61e+07] | 91 | 11.0% | 7.7% | 5.5% | 0.0% |
| TX | (3.61e+07,6.97e+07] | 104 | 11.5% | 4.8% | 7.7% | 2.9% |
| TX | (6.97e+07,1.7e+08] | 103 | 6.8% | 3.9% | 4.9% | 1.0% |
| TX | (1.7e+08,5.96e+09] | 243 | 7.0% | 4.1% | 5.3% | 0.0% |
| TX | NA | 118 | 3.4% | 0.8% | 0.0% | 0.0% |
| UT | [1.31e+06,3.61e+07] | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| UT | (3.61e+07,6.97e+07] | 9 | 33.3% | 33.3% | 22.2% | 0.0% |
| UT | (6.97e+07,1.7e+08] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| UT | (1.7e+08,5.96e+09] | 17 | 5.9% | 0.0% | 0.0% | 0.0% |
| VA | [1.31e+06,3.61e+07] | 20 | 5.0% | 5.0% | 5.0% | 0.0% |
| VA | (3.61e+07,6.97e+07] | 80 | 21.2% | 17.5% | 17.5% | 3.8% |
| VA | (6.97e+07,1.7e+08] | 36 | 2.8% | 2.8% | 2.8% | 0.0% |
| VA | (1.7e+08,5.96e+09] | 60 | 18.3% | 11.7% | 10.0% | 3.3% |
| VA | NA | 27 | 7.4% | 7.4% | 7.4% | 0.0% |
| VT | [1.31e+06,3.61e+07] | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| VT | (3.61e+07,6.97e+07] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| VT | (6.97e+07,1.7e+08] | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| VT | NA | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| WA | [1.31e+06,3.61e+07] | 13 | 15.4% | 15.4% | 15.4% | 7.7% |
| WA | (3.61e+07,6.97e+07] | 11 | 18.2% | 18.2% | 18.2% | 0.0% |
| WA | (6.97e+07,1.7e+08] | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| WA | (1.7e+08,5.96e+09] | 40 | 22.5% | 20.0% | 15.0% | 0.0% |
| WA | NA | 20 | 0.0% | 0.0% | 0.0% | 0.0% |
| WI | [1.31e+06,3.61e+07] | 71 | 7.0% | 4.2% | 5.6% | 0.0% |
| WI | (3.61e+07,6.97e+07] | 46 | 4.3% | 2.2% | 0.0% | 0.0% |
| WI | (6.97e+07,1.7e+08] | 38 | 10.5% | 10.5% | 7.9% | 5.3% |
| WI | (1.7e+08,5.96e+09] | 10 | 10.0% | 0.0% | 10.0% | 10.0% |
| WI | NA | 19 | 5.3% | 0.0% | 0.0% | 0.0% |
| WV | (6.97e+07,1.7e+08] | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| WV | (1.7e+08,5.96e+09] | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| WV | NA | 6 | 33.3% | 16.7% | 16.7% | 0.0% |
| WY | (1.7e+08,5.96e+09] | 5 | 0.0% | 0.0% | 0.0% | 0.0% |
| WY | NA | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
Free & Reduced Lunch Quartiles
Interestingly, there does not seem to be any distinct pattern between the lunch quartiles and our success at any part of the funnel. The uniformity is interesting in and of itself. However, uniformity is often produced by the variuos interplay of underlying distributions.
| Lunch Quartile | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| [0,0.295] | 1040 | 11.2% | 7.9% | 7.2% | 2.0% |
| (0.295,0.468] | 1037 | 9.8% | 7.1% | 7.0% | 1.7% |
| (0.468,0.643] | 1038 | 10.7% | 8.2% | 6.9% | 1.8% |
| (0.643,1.01] | 1038 | 9.3% | 6.6% | 6.7% | 1.9% |
| NA | 1472 | 6.7% | 3.7% | 3.1% | 0.6% |
Free & Reduced Lunch Quartiles & Locale
Large Suburbs are where we spend a lot of our time and they also happen to be a place where we are successful across all of the Lunch quartiles. That is, a decent amount of the uniformity is driven by another variable, the Locale, which is itself a proxy for a few other variables.
For other Locales, there are potentially some sweet spots:
- Large Cities in the Second Quartile
- Mid Sized Cities in the Fourth Quartile
- Remote Rural or Distant Towns in the First Quartile (smaller N here)
| Locale | Lunch Quartile | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|---|
| 11-City: Large | [0,0.295] | 23 | 8.7% | 4.3% | 8.7% | 0.0% |
| 11-City: Large | (0.295,0.468] | 16 | 18.8% | 18.8% | 18.8% | 12.5% |
| 11-City: Large | (0.468,0.643] | 44 | 11.4% | 6.8% | 6.8% | 2.3% |
| 11-City: Large | (0.643,1.01] | 119 | 8.4% | 5.9% | 4.2% | 0.0% |
| 11-City: Large | NA | 14 | 21.4% | 14.3% | 7.1% | 7.1% |
| 12-City: Mid-size | [0,0.295] | 36 | 8.3% | 2.8% | 8.3% | 2.8% |
| 12-City: Mid-size | (0.295,0.468] | 47 | 10.6% | 4.3% | 4.3% | 0.0% |
| 12-City: Mid-size | (0.468,0.643] | 63 | 11.1% | 7.9% | 7.9% | 3.2% |
| 12-City: Mid-size | (0.643,1.01] | 88 | 14.8% | 12.5% | 12.5% | 6.8% |
| 12-City: Mid-size | NA | 23 | 21.7% | 8.7% | 8.7% | 4.3% |
| 13-City: Small | [0,0.295] | 32 | 12.5% | 6.2% | 6.2% | 0.0% |
| 13-City: Small | (0.295,0.468] | 86 | 11.6% | 8.1% | 8.1% | 2.3% |
| 13-City: Small | (0.468,0.643] | 94 | 10.6% | 8.5% | 7.4% | 2.1% |
| 13-City: Small | (0.643,1.01] | 83 | 9.6% | 7.2% | 6.0% | 1.2% |
| 13-City: Small | NA | 27 | 3.7% | 0.0% | 0.0% | 0.0% |
| 21-Suburb: Large | [0,0.295] | 644 | 11.5% | 8.2% | 7.6% | 1.7% |
| 21-Suburb: Large | (0.295,0.468] | 381 | 8.9% | 6.6% | 6.6% | 1.3% |
| 21-Suburb: Large | (0.468,0.643] | 253 | 10.7% | 7.5% | 5.5% | 1.2% |
| 21-Suburb: Large | (0.643,1.01] | 280 | 7.9% | 5.7% | 6.4% | 1.8% |
| 21-Suburb: Large | NA | 115 | 13.0% | 10.4% | 10.4% | 0.9% |
| 22-Suburb: Mid-size | [0,0.295] | 37 | 8.1% | 5.4% | 0.0% | 0.0% |
| 22-Suburb: Mid-size | (0.295,0.468] | 54 | 7.4% | 7.4% | 7.4% | 1.9% |
| 22-Suburb: Mid-size | (0.468,0.643] | 34 | 5.9% | 5.9% | 2.9% | 0.0% |
| 22-Suburb: Mid-size | (0.643,1.01] | 22 | 13.6% | 9.1% | 4.5% | 0.0% |
| 22-Suburb: Mid-size | NA | 14 | 14.3% | 7.1% | 7.1% | 0.0% |
| 23-Suburb: Small | [0,0.295] | 18 | 0.0% | 0.0% | 0.0% | 0.0% |
| 23-Suburb: Small | (0.295,0.468] | 37 | 8.1% | 8.1% | 8.1% | 2.7% |
| 23-Suburb: Small | (0.468,0.643] | 13 | 15.4% | 7.7% | 7.7% | 0.0% |
| 23-Suburb: Small | (0.643,1.01] | 17 | 5.9% | 5.9% | 5.9% | 5.9% |
| 23-Suburb: Small | NA | 9 | 11.1% | 11.1% | 11.1% | 11.1% |
| 31-Town: Fringe | [0,0.295] | 63 | 9.5% | 7.9% | 7.9% | 1.6% |
| 31-Town: Fringe | (0.295,0.468] | 78 | 7.7% | 7.7% | 6.4% | 3.8% |
| 31-Town: Fringe | (0.468,0.643] | 54 | 3.7% | 3.7% | 1.9% | 0.0% |
| 31-Town: Fringe | (0.643,1.01] | 31 | 3.2% | 3.2% | 0.0% | 0.0% |
| 31-Town: Fringe | NA | 3 | 0.0% | 0.0% | 0.0% | 0.0% |
| 32-Town: Distant | [0,0.295] | 27 | 14.8% | 11.1% | 0.0% | 0.0% |
| 32-Town: Distant | (0.295,0.468] | 92 | 12.0% | 8.7% | 8.7% | 2.2% |
| 32-Town: Distant | (0.468,0.643] | 145 | 17.9% | 15.2% | 12.4% | 4.1% |
| 32-Town: Distant | (0.643,1.01] | 126 | 8.7% | 5.6% | 7.9% | 2.4% |
| 32-Town: Distant | NA | 36 | 8.3% | 8.3% | 5.6% | 0.0% |
| 33-Town: Remote | [0,0.295] | 6 | 33.3% | 33.3% | 16.7% | 16.7% |
| 33-Town: Remote | (0.295,0.468] | 42 | 11.9% | 9.5% | 7.1% | 0.0% |
| 33-Town: Remote | (0.468,0.643] | 60 | 6.7% | 5.0% | 3.3% | 0.0% |
| 33-Town: Remote | (0.643,1.01] | 101 | 10.9% | 5.0% | 5.9% | 3.0% |
| 33-Town: Remote | NA | 33 | 9.1% | 6.1% | 6.1% | 0.0% |
| 41-Rural: Fringe | [0,0.295] | 123 | 8.9% | 5.7% | 6.5% | 2.4% |
| 41-Rural: Fringe | (0.295,0.468] | 113 | 12.4% | 7.1% | 7.1% | 0.9% |
| 41-Rural: Fringe | (0.468,0.643] | 135 | 10.4% | 8.1% | 7.4% | 2.2% |
| 41-Rural: Fringe | (0.643,1.01] | 86 | 10.5% | 7.0% | 8.1% | 1.2% |
| 41-Rural: Fringe | NA | 23 | 0.0% | 0.0% | 0.0% | 0.0% |
| 42-Rural: Distant | [0,0.295] | 29 | 20.7% | 17.2% | 13.8% | 13.8% |
| 42-Rural: Distant | (0.295,0.468] | 85 | 8.2% | 4.7% | 5.9% | 1.2% |
| 42-Rural: Distant | (0.468,0.643] | 135 | 8.9% | 6.7% | 7.4% | 1.5% |
| 42-Rural: Distant | (0.643,1.01] | 58 | 6.9% | 6.9% | 6.9% | 0.0% |
| 42-Rural: Distant | NA | 26 | 11.5% | 3.8% | 0.0% | 0.0% |
| 43-Rural: Remote | [0,0.295] | 2 | 50.0% | 50.0% | 50.0% | 0.0% |
| 43-Rural: Remote | (0.295,0.468] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| 43-Rural: Remote | (0.468,0.643] | 8 | 0.0% | 0.0% | 0.0% | 0.0% |
| 43-Rural: Remote | (0.643,1.01] | 27 | 14.8% | 11.1% | 7.4% | 0.0% |
| 43-Rural: Remote | NA | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| NA | NA | 1147 | 5.5% | 2.7% | 2.1% | 0.4% |
Proportion Hispanic
The middle two quartiles appear to perform better than the extremes.
| Hispanic Quartile | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|
| [0,0.0467] | 1114 | 9.4% | 6.9% | 6.5% | 1.3% |
| (0.0467,0.118] | 1114 | 11.8% | 8.9% | 8.1% | 2.2% |
| (0.118,0.32] | 1114 | 11.9% | 8.6% | 8.3% | 2.2% |
| (0.32,0.998] | 1113 | 7.8% | 5.5% | 4.9% | 1.6% |
| NA | 1170 | 5.8% | 2.7% | 2.2% | 0.5% |
Proportion Hispanic & Locale
- Locales where the highest proportion of Hispanic students translates into Units: Fringe Rural, Fringe Town, and Small Suburb
- Locales where a lower proportion of Hispanic students translates into Units: Large and Mid-Sized cities, Distant Rural, and also Small Suburbs.
- Large Suburbs where this is a decent sized proportion of Hispanic students seems to be a sweet spot.
| Locale | Hispanic Quartile | PLs | PLtoMQL | PLtoVisit | PLtoSQL | PLtoUnit |
|---|---|---|---|---|---|---|
| 11-City: Large | [0,0.0467] | 4 | 25.0% | 25.0% | 0.0% | 0.0% |
| 11-City: Large | (0.0467,0.118] | 28 | 10.7% | 3.6% | 7.1% | 3.6% |
| 11-City: Large | (0.118,0.32] | 65 | 10.8% | 6.2% | 7.7% | 1.5% |
| 11-City: Large | (0.32,0.998] | 118 | 10.2% | 8.5% | 5.9% | 1.7% |
| 11-City: Large | NA | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| 12-City: Mid-size | [0,0.0467] | 11 | 9.1% | 9.1% | 9.1% | 0.0% |
| 12-City: Mid-size | (0.0467,0.118] | 54 | 24.1% | 18.5% | 20.4% | 11.1% |
| 12-City: Mid-size | (0.118,0.32] | 84 | 10.7% | 4.8% | 7.1% | 3.6% |
| 12-City: Mid-size | (0.32,0.998] | 97 | 6.2% | 5.2% | 4.1% | 0.0% |
| 12-City: Mid-size | NA | 11 | 36.4% | 9.1% | 9.1% | 9.1% |
| 13-City: Small | [0,0.0467] | 36 | 11.1% | 11.1% | 11.1% | 2.8% |
| 13-City: Small | (0.0467,0.118] | 91 | 19.8% | 12.1% | 11.0% | 2.2% |
| 13-City: Small | (0.118,0.32] | 97 | 9.3% | 7.2% | 6.2% | 2.1% |
| 13-City: Small | (0.32,0.998] | 97 | 2.1% | 1.0% | 1.0% | 0.0% |
| 13-City: Small | NA | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| 21-Suburb: Large | [0,0.0467] | 293 | 13.0% | 9.2% | 9.9% | 1.7% |
| 21-Suburb: Large | (0.0467,0.118] | 438 | 11.4% | 8.7% | 7.3% | 1.1% |
| 21-Suburb: Large | (0.118,0.32] | 502 | 11.8% | 8.8% | 8.8% | 2.6% |
| 21-Suburb: Large | (0.32,0.998] | 439 | 5.7% | 3.6% | 3.0% | 0.5% |
| 21-Suburb: Large | NA | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| 22-Suburb: Mid-size | [0,0.0467] | 39 | 5.1% | 2.6% | 2.6% | 0.0% |
| 22-Suburb: Mid-size | (0.0467,0.118] | 47 | 14.9% | 12.8% | 6.4% | 2.1% |
| 22-Suburb: Mid-size | (0.118,0.32] | 53 | 5.7% | 3.8% | 3.8% | 0.0% |
| 22-Suburb: Mid-size | (0.32,0.998] | 22 | 9.1% | 9.1% | 4.5% | 0.0% |
| 23-Suburb: Small | [0,0.0467] | 33 | 6.1% | 3.0% | 3.0% | 3.0% |
| 23-Suburb: Small | (0.0467,0.118] | 27 | 3.7% | 3.7% | 3.7% | 0.0% |
| 23-Suburb: Small | (0.118,0.32] | 10 | 0.0% | 0.0% | 0.0% | 0.0% |
| 23-Suburb: Small | (0.32,0.998] | 24 | 16.7% | 16.7% | 16.7% | 8.3% |
| 31-Town: Fringe | [0,0.0467] | 76 | 6.6% | 6.6% | 5.3% | 0.0% |
| 31-Town: Fringe | (0.0467,0.118] | 82 | 4.9% | 4.9% | 4.9% | 1.2% |
| 31-Town: Fringe | (0.118,0.32] | 27 | 7.4% | 3.7% | 0.0% | 0.0% |
| 31-Town: Fringe | (0.32,0.998] | 44 | 9.1% | 9.1% | 6.8% | 6.8% |
| 32-Town: Distant | [0,0.0467] | 137 | 11.7% | 8.8% | 5.8% | 1.5% |
| 32-Town: Distant | (0.0467,0.118] | 95 | 12.6% | 11.6% | 10.5% | 2.1% |
| 32-Town: Distant | (0.118,0.32] | 95 | 15.8% | 13.7% | 12.6% | 4.2% |
| 32-Town: Distant | (0.32,0.998] | 99 | 12.1% | 7.1% | 8.1% | 3.0% |
| 33-Town: Remote | [0,0.0467] | 78 | 9.0% | 6.4% | 6.4% | 0.0% |
| 33-Town: Remote | (0.0467,0.118] | 28 | 14.3% | 10.7% | 10.7% | 3.6% |
| 33-Town: Remote | (0.118,0.32] | 45 | 15.6% | 11.1% | 6.7% | 0.0% |
| 33-Town: Remote | (0.32,0.998] | 87 | 8.0% | 3.4% | 3.4% | 3.4% |
| 33-Town: Remote | NA | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| 41-Rural: Fringe | [0,0.0467] | 173 | 4.0% | 2.9% | 2.9% | 0.0% |
| 41-Rural: Fringe | (0.0467,0.118] | 143 | 8.4% | 4.9% | 5.6% | 2.1% |
| 41-Rural: Fringe | (0.118,0.32] | 101 | 18.8% | 12.9% | 10.9% | 2.0% |
| 41-Rural: Fringe | (0.32,0.998] | 62 | 16.1% | 11.3% | 14.5% | 4.8% |
| 41-Rural: Fringe | NA | 1 | 0.0% | 0.0% | 0.0% | 0.0% |
| 42-Rural: Distant | [0,0.0467] | 203 | 8.9% | 5.4% | 5.4% | 2.5% |
| 42-Rural: Distant | (0.0467,0.118] | 77 | 10.4% | 9.1% | 7.8% | 2.6% |
| 42-Rural: Distant | (0.118,0.32] | 29 | 10.3% | 10.3% | 10.3% | 0.0% |
| 42-Rural: Distant | (0.32,0.998] | 22 | 9.1% | 9.1% | 9.1% | 0.0% |
| 42-Rural: Distant | NA | 2 | 50.0% | 0.0% | 50.0% | 0.0% |
| 43-Rural: Remote | [0,0.0467] | 31 | 12.9% | 12.9% | 9.7% | 0.0% |
| 43-Rural: Remote | (0.0467,0.118] | 4 | 0.0% | 0.0% | 0.0% | 0.0% |
| 43-Rural: Remote | (0.118,0.32] | 6 | 0.0% | 0.0% | 0.0% | 0.0% |
| 43-Rural: Remote | (0.32,0.998] | 2 | 50.0% | 0.0% | 0.0% | 0.0% |
| 43-Rural: Remote | NA | 2 | 0.0% | 0.0% | 0.0% | 0.0% |
| NA | NA | 1147 | 5.5% | 2.7% | 2.1% | 0.4% |