States With Most Private School Students

privateschools
Click to enlarge in a new tab

I went to a fine suburban public school, but sometimes I wondered what it would be like to go to a fancy private school with a fancy sounding name like The Summit Country Day School or The Seven Hills School (the “the” in front is how you know it’s fancy). Those are two of the most expensive and top-rated schools in Cincinnati, which run just over $20,000 a year. That doesn’t have much on New York City private schools, like Dalton, Marymount, or the Ethical Cultural Fieldston School, the latter of which is $47,000 a year. Cities like Cincinnati, where I live, are full of Catholic schools. We have 7 all-girls, 5 all-boys, and many co-ed Catholic high schools in the greater Cincinnati area. So I was curious- where are there a high percentage of private schools? Would NYC or somewhere in the Northeast top the list?

I ran this analysis of the percentage of private school students using both the state population and the total number of students (public + private) as the denominator (the results were pretty similar, but note how DC goes down a lot further, relatively speaking, in the bottom graph).  DC has the highest private to public ratio of students and Utah and Wyoming are among the lowest.

Continue reading

College Ballers (part 2)

basketballstats2

Click to enlarge in a new window.

Finally, part 2 of my women’s NCAA Basketball stats. The above data shows which states the players from the top 15 schools hail from (at end of 2016 season). Texas soars to the top with 20, followed by 12 from Ohio, and 9 from California and Georgia.  But don’t forget that the University of Texas and Baylor are in the top 15, and Ohio State is as well, and they recruited a lot of Ohioans. California has UCLA and Stanford. Georgia doesn’t have any schools but have a few close by- South Carolina, Florida State, and Tennessee. So that begs the question- are these schools so good because these areas are hotbeds for basketball talent, or are these athletes a bit lucky to live in an area with a top program, or a bit of both?  UConn has been the #1 team for years and they consistently recruit far from Connecticut for their top players. However, they, like most teams, have more local players filling out their roster, which explains some of the results.

The tables to the right show analysis I did combining my Athletes data with my Schools data to answer the question- do players come from wealthier towns, and therefore likely wealthier families? By using school data on the number of students on free or reduced lunch, I bucketed all 99,000 public schools in my data set into 5 equal-sized buckets. Level 1 is the poorest schools, or the bottom 20% (highest percentage of free/reduced lunch), and Level 5 is the top 20%. 43 of the athletes were in Level 5, and the numbers keep decreasing through Level 1. So the answer to my question is yes, players are, on average, coming from richer public schools. And just for fun, I also ran their private schools through and found that the majority went to Catholic school, but that’s no shocker given the sheer number in this country.

For reference, the top 15 schools at the end of 2016 were (in alphabetical order): Arizona State, Baylor, Florida State, Kentucky, Louisville, Maryland, Notre Dame, Ohio State, Oregon State, South Carolina, Stanford, Tennessee, Texas, UCLA, and the University of Connecticut.

USA Olympians on Instagram

USA Olympians Ranked by Growth in followers during August
topgrowth

I’m a huge fan of the Olympics and hold a party every time to watch the Opening Ceremonies. I thought it would be fun to see which athletes at the 2016 Rio games had the most social media followers and which ones saw the most growth in followers during the Games. The list above is all the USA Olympians who saw their Instagram follower counts double after the Games were over (only those with at least 4000 followers were included). The list below is the top 20  with the most followers regardless of growth. Male basketball players feature prevalently, not to my surprise. But it was nice to see Serena and Alex Morgan up there in the top 5 along with Simone Biles at #7.

top20totals

Continue reading

College Ballers (part 1)

bball_stats

I compiled statistics on the top 15 women’s college basketball teams during March Madness this year using their rosters. I calculated the average height for each team as well as figured out who the shortest and tallest players are. The shortest stands at 5’3″ and the tallest two are 6’7″. While UConn was the number one team, it ranked 12th in height out of the 15 teams I analyzed.  I also did some race/ethnicity statistics based on their photos and articles I found, so it is by no means an exact science since it’s not like they list that in people’s bios (also note that if they are half non-Caucasian, they tend to be listed as the non-Caucasian race/ethnicity). All the rosters list the women’s high schools, so I was able to see what percentage go to public versus private school or homeschool. The majority are public schooled (72%).  The 19 “Blank” entries represent the 18 international students and 1 homeschooled student- Moriah Jefferson of UConn.  In addition to AAU, Moriah played for a homeschool team in Texas during the winter season.  Florida State has the most international players of any team.

On the next post, I’ll share some other interesting stats and charts, like which states these athletes come from as well as analysis using the schools they came from.

 

Christian Book Overload

Disclaimer: The data in this post is approximate and not 100% verified or factual.
books_by_pastor

Click the chart to enlarge

I did a previous post on the Top 20 Megachurches and noticed while researching the pastors that, boy, have they written a lot of books! Holy cow. I thought it was just Joel Osteen, but I was wrong. The graphic above is the approximate number of books written* by the pastors of the top 50 megachurches according to one ranking list I found**. 476 books total! How do they have so much to say to write 10, 15, 30 books?! And are they writing these during work time when they should be doing other things for their church? Are they getting rich off these books? Tons of the these churches or pastors have an online store on their website to sell the books and dvds and study guide companions, which is a huge turn off for me. The whole thing just made me groan. It’s such a business and kind of feels like a scam. I doubt Jesus would have wanted it this way.

Continue reading

Serena versus the world

PointsPerCountry

Above is a graph showing the ranking points by country for the top 100 women players on the WTA tour as of August 10, 2015. As you can see, the United States is the clear #1 with over 25,000 points (for reference, winning a grand slam like Wimbledon nets you 2000 points; a large event like Cincinnati’s Western & Southern Open gives you 900, and an ITF event (the minor leagues) adds around 50-150 points). The WTA uses a rolling 12 month point system so you never reset to zero (the ATP tour, the last I checked, does reset each year in January).

I made some more cool visualizations with Microsoft’s Power BI technology that shows there’s more than meets than eye when evaluating which country is dominating. Continue reading

Names with Biggest Increase in Popularity

So, it’s been forever since I posted. Got busier at work, the weather has been nice and I’ve gone on several trips- typical excuses. But I hope to get back to some more regular posts!

The 2014 baby names were released and I hope to load them into my database soon. In the meantime, here’s a fun list of names that saw dramatic increases in the last several years and to what or whom that can be attributed.  I compiled the list by calculating which names saw the largest percentage increase in a two year timespan, filtering out very rare names, alternate spellings and only looking at the last 10 years. Here are the top 10…

Name Year Count 2 Years Prior* % Increase Reason
Cataleya F 2012 636 < 5 31,700% Female assassin in movie Columbiana
Jaslene F 2008 872 5 17,000% Winner of America’s Next Top Model Season 8
Kanye M 2004 507 5 10,040% Rapper Kanye West
Rihanna F 2006 571 6 9,400% Singer Rihanna***
Allisson F 2008 767 12 6,300% Mexican TV star Allisson Lozz
Talan M 2006 1058 20 5,200% Reality star on MTV’s Laguna Beach
Audrina F 2007 412 8 5,000% Reality star on MTV’s The Hills
Akeelah F 2006 403 8 5,000% Movie Akeelah and the Bee
Marely F 2008 1004 21 4,700% ?
Miley F 2007 1232 26 4,600% Actress/singer Miley Cyrus from Disney’s Hannah Montana****

*If the name did not appear in the database two years prior, I assigned it a value of 2. It’s hard to say whether it had zero names or up to four names, so it was a compromise. Plus assigning it at 0 made the percentages seem ridiculously high**- it would have been 63,000%  for Cataleya, for example.
**Because 31,700% isn’t ridiculously high at all. 🙂
***Her real name is Robyn Rihanna Fenty
****Her real name is Destiny Hope Cyrus