Your reflection should be around 400 words long. It should be written in paragraphs, with minimal grammatical and spelling mistakes.
Write your reflection.
In your reflection, respond to the following:
PART 1- THE RESULTS
Ranking 1
Insert your bar graph here to display your country ranking.
List the weights for each metric.
Ranking 2
Insert your bar graph here to display your country ranking.
List the weights for each metric.
Why did changing the weights create a different ranking of your 10 countries?
PART 2-THE MATH BEHIND THE SPREADSHEET.
Why is it important to use relative metrics instead of absolute metrics? Give an example.
Explain how the data is being refined (or rescaled) on page 4. Ie, the excel function in cell D4 “=C4/max(C4:C13*100)”. What is the purpose of that function and how is it “rescaling” the data?
Why does refining or rescaling the data matter? Give an example.
PART 3- ISSUES WITH RANKINGS.
Why did you select the metrics that you chose? What makes them important for happiness?
What are some limitations of using a weighted average ranking system? Give two specific examples of things that your ranking does not account for or issues that you see with using this method for ranking happiness.
Were you surprised that you could alter the ranking outcome by changing the weights? Explain.
PART 4- FUTURE IMPACT
Give an example of one application of the techniques in this project (using excel to automate multiple computations and creating graphs).
Give one example of a ranking that you have viewed in your life. This could be: Sports, music, gear, colleges, restaurants.
Did this project impact how you will view that ranking from now on? Explain yes or no and why.