Learnings:
Changes in the proposal:
Roadblocks:
What I would have done differently:
- Constructing an interactive spreadsheet.
- Construction of a scatter-plot.
- Running regression without the use of the Analysis ToolPak.
- While trying to find the INDEX function, I learnt about numerous other functions such as CHOOSE, HLOOKUP, VLOOKUP, and INDIRECT.
Changes in the proposal:
- I did not add a separate sheet where I could choose a state, a parameter and a year. This would give me only one value from the entire database and would not be useful in any way.
Roadblocks:
- Formatting the data was a problem. I had to enter a lot of data manually.
- Constructing an interactive table was very challenging.
- Using drop-down boxes to give out a list of values was difficult.
- There were missing data entries.
What I would have done differently:
- I would try to use a better way of data validation to create the drop-down boxes.
- I would try making two drop-boxes in the 'CORRELATION' sheet where selecting those two parameters would highlight the correlation between the two selected parameters.