1. Recreate the spreadsheet that calculates the measures of spread for the Health Care data given in this activity. Share the spreadsheet with your teacher.
2. Calculate the sample standard deviation for the 13 provinces and territories by hand for Year 2005. Be sure to include all steps in the calculation and a well organized solution. You may take a picture of work you have done by hand. Submit your work to your teacher.
3. Remove Nunavut from the data for the Year 2005. Recalculate the measures of spread and compare measures to the Year 2005 with Nunavut included. Comment on any significant changes and provide some explanation as to why those changes occurred.