Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Linear Algebra with Applications

Authors: Bernard Kolman, David Hill

9th edition

132296543, 978-0132296540

More Books

Students also viewed these Mathematics questions

Question

The paleolithic age human life, short write up ?

Answered: 1 week ago