Have you ever thought about how poverty and divorce rates could be correlated? Whether or not there is any relationship between poverty and happiness or divorce and happiness?
The primary goal of my project is to determine the relationships between poverty rates, divorce rates and the happiness index for a period of four years(2008-2011) in the 50 US states. In this project, you can see the following:
1. In the worksheet 'STATE DATA', you can choose a state (from the 50 states in USA) by clicking at the drop-down box in the cell named 'State'. Next, you can choose any two parameters by clicking at the drop-down box in the cells named 'Parameter 1' and 'Parameter 2'. When you do that, the cells below 'Parameter 1' and 'Parameter 2' display the value of the that particular parameter for the chosen state.
2. In the worksheet 'PIVOT TABLE', you can choose
3. In the worksheet 'STATISTICS", you can choose any two parameters and see the scatter-plot diagram, the correlation and the co-variance between the two.
The ultimate goal of my project is to learn more about Excel and to construct an interactive tool in order to explore relationships between any two parameters.
The primary goal of my project is to determine the relationships between poverty rates, divorce rates and the happiness index for a period of four years(2008-2011) in the 50 US states. In this project, you can see the following:
1. In the worksheet 'STATE DATA', you can choose a state (from the 50 states in USA) by clicking at the drop-down box in the cell named 'State'. Next, you can choose any two parameters by clicking at the drop-down box in the cells named 'Parameter 1' and 'Parameter 2'. When you do that, the cells below 'Parameter 1' and 'Parameter 2' display the value of the that particular parameter for the chosen state.
2. In the worksheet 'PIVOT TABLE', you can choose
3. In the worksheet 'STATISTICS", you can choose any two parameters and see the scatter-plot diagram, the correlation and the co-variance between the two.
The ultimate goal of my project is to learn more about Excel and to construct an interactive tool in order to explore relationships between any two parameters.