Author: Michelle Hand
-
GeoAnalysis on Worksite Clinics
A portion of our department consults on worksite clinics to our clients, and a question arose during a meeting whether it was possible to calculate the percentage of employees that lived within a certain radius from the proposed clinic. A representative of our team stated we could run a third-party mapping software for $250 in…
-
Mental Shift: NCHA Summer Conference
This week, Myrtle Beach is not only for the ocean breeze. Two colleagues and I attended the North Carolina Healthcare Association Summer Meeting in Myrtle Beach from July 20–22 to speak from our Mental Shift webinar series. Our presentation touches on a mental health perspective few of us think about — how employee mental health,…
-
Analyzing enrollment rates between current and prior years
Today, right before a client meeting, I was asked to determine whether the client’s drop in overall membership was due to the drop in spouses on the plan. I thought this would be a good time to practice learning some newly acquired stats skills. Here is the original data that sparked the question: I first…
-
Medicare Costs for Preventive Medicine in US States
As a way to help me learn how to analyze healthcare data, I am practicing equations on simple datasets. This dataset is sourced from data.cms.gov and updated on June 5, 2021: https://data.cms.gov/provider-data/search?theme=Physician%20office%20visit%20costs. Medicare compiles this data from their procedure lookup tool. The data sets contains US zip codes, minimum, maximum and mode Medicare charges for new…
Handled with Data 