Marriage and Divorce Rates Analysis Dashboard – CDC Data set

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.

Posted in analytics, business intelligence, dashboards | Tagged , , , , , , ,


Has InfoCaptor Convinced you?

If so, click to buy now, including 60 minutes of dashboard development for free!