Assignment 2
Instructions
This assignment is designed to test your familiarity with formulas, filtering, formatting, and other essential commands in Excel. You will also create pivot tables to complete this assignment. Although you will not be asked to upload your dataset, it is strongly encouraged that you complete the assignment using the commands and techniques we learn in class (and the workflow requested on this assignment).
Introduction to the dataset
The data for this assignment come from the Global Trust Survey, a survey that aims to assess trust in institutions and social networks from citizens in countries around the globe. We have taken a subset of this data of respondents from the United States and Canada.
Selected variables
id: The respondents’ unique identifier
country: The country the respondent is from
trust_neighbors: Trust in neighbors on a scale of 1-5
trust_government: Trust in federal government on a scale of 1-5
trust_scientists: Trust in scientists from country on a scale of 1-5
trust_journalists: Trust in journalists from country on a scale of 1-5
trust_doctors_nurses: Trust in doctors and nurses from country on a scale of 1-5
Instructions
1.) Download the dataset trust_survey.xlsx from ELMS and open it in Excel.
2.) Create a new column called trust_total equal to the sum of all the existing trust variables. (Hint: Use a formula and click and drag.)
3.) Create a (pivot) table with the country as the rowand the average of each of the trust variables as the values.
4.) Sort the dataset by country first and trust_total second.
5.) Save the file EXACTLY as Assignment2.xlsx. You will not be able to upload it if it’s not a .xlsx.
6.) Complete the Assignment 2 submission on ELMS by the assigned date. You will upload your .xlsx file, but this will not necessarily be checked for accuracy. (That’s what the questions help assess.)