Question
For this assignment, you will use Excel to run descriptive statistics (and frequencies/pivot tables) using Emily's survey data Download Emily's survey data and complete an
For this assignment, you will use Excel to run descriptive statistics (and frequencies/pivot tables) using Emily's survey data Download Emily's survey data and complete an analysis of demographic data for those who attended training and those who did not. A short narrative will be included in your assignment submission.
You willgenerate descriptive statistics for the demographic variables and determine which questions may benefit from a frequency table.See instructions in the Excel file as well as the demo video.
The assignment data file includes a number of tabs:
- Instructions. Outlines the expectations for the assignment.
- Codebook. You will complete the codebook following the examples provided earlier in the course. Review these examples so you appropriately label the variable name which is much shorter than the description.
- Raw data. This is the raw data file of all responses to Emily's survey.
In the assignment file Download assignment filethat you submit, insert worksheets for all the questions analyzed. Please note, Excel includes Spell Check (Review > Spelling) which you are encouraged to use on your analysis text.
INSTRUCTIONS
ASSIGNMENT INSTRUCTIONS | ||
1 | Complete the codebook for Emily's survey. | Worksheet labeled: Codebook |
2 | Run descriptive statistics of the demographic background of the training participants and those who did not attend training. | Qs: 18, 19, 20, 21, 22, 23, 24, 25 |
3 | Run descriptive statistics for Q15 (attended and not attended). | |
4 | Decide which questions from those analyzed in this assignment would also benefit from frequency tables (obtained by running pivot tables) and insert those as you see fit. | |
5 | Highlight the statistic with the greatest meaning for each question. |