SOCI EXCEL ASSIGNMENT: Short n quick task that requires some DESCRIPTIVE STATISTICS & suitable ((GRAPH/TABLE/HISTOGRAM) to compare the results.
You will be working with the BC Student Outcome Survey 2021-2023.
You are free to use any number of variables in the data to illustrate or highlight the answers to the question: "How are Sociology/Arts students doing?"
You should use at least THREE metrics/measures (variables) to tell the story. Your story should make comparing to other schools/discipline. The type of comparison is up to you. Some of your measures should be a measure that includes multiple schools / programs and not just a one data point.
i.e. compare the salary of Arts students vs. non Arts students
You can use Excel to generate the descriptive statistics as well as the appropriate display (graph/chart/table) to tell the story.
Grade Breakdown
3 metrics - 5 marks
calculations (show work within Excel) - 5 marks
group comparison - 5 marks
proper data displays - 5 marks
Note from me:
- I need to submit the Excel file with recoded data and calculations.
- Please note their needs to be key continuous variable (Q51NE2 - this, pls refer to codebook to understand).
- And the descriptive statistics need to be displayed that will include: MAX, MIN, MEAN, 1ST QUATER, 3RD QUARTER, IQR, LOWER IF, UPPER IF.
- Please use these 3 variables: EMPLOYMENT, Q51NE2, FURTH_STUDIES

Very helpful and complete the task accurately on time.
Post the same Task