PBHL-H 303: Health Administration Data Analysis

Regression Tables & Dashboard

Assignment Overview:

In this class, we worked on many different Excel projects, and these two examples, the regression table and the analytics dashboard, are just a small part of what I learned. Throughout the semester, we created different types of graphs, practiced cleaning data, ran statistical tests, and learned how to turn numbers into something that actually makes sense.

For the dashboard, I built a visual summary of patient data using charts, filters, and key metrics.

For the regression table, I used Excel to run a model and interpret the results, including the coefficients and predicted values.

What I Learned:

This class helped me use Excel in a much deeper way. I learned how to build dashboards, create different types of graphs, and run regression models. It also helped me feel more confident working with data and understanding what the results actually mean.

Program Competencies

Data analysis
Use of technology and digital tools
Critical thinking
Communication of findings

Marketing

Strategic Planning