Marriage and Divorce Rates Analysis Dashboard – CDC Data set

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

In this analysis we gather data from CDC for Marriage and Divorce rates across all the states of USA for past several years. As usual the bulk of the time is consumed in the data gathering, munging and preparation step for the analysis.

All the data for each year is manually copy/pasted from the website into excel and then we mix the data with census to derive the states Census regions. This allows us to compare the marriage and divorce rates by the Census regions. Later, you can see the complete development process in the video link at the bottom of this analysis.

Let us see the average trend by the Census Regions

1. Marriage rates by Census region

Image

Image

The following trend line compares the marriage and divorce rates

Image

Observations

  • Marriage rates for Northeast and Midwest follows the same trend.
  • Marriage rates have been declining

Next, we analyze the marriage and divorce rates by each state.

Image

Image

Image

Image

Next, we analyze the Divorce rates.

Image

Image

Image

Image

 

Complete development process

You can watch the complete dashboard building process in this video

To watch the rates for all Stats at once, you can play with this prebuilt dashboard Marriage and Divorce Dashboard.

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH