The spreadsheet “Exercise Data.xls” contains a fictitious data set of 20 variables with 1000 cases. For each numbered variable below, identify if the data is continuous, ordinal, or categorical. Then calculate the appropriate descriptive statistics from this list:
Mean
Median
Frequency distribution (do histograms, only from the ordinal and categorical variables)
Minimum
Maximum
Range
Cumulative percentage
7-point scale of preparedness – 7 is high, 1 is low
Rating from 0 to 100 of job satisfaction
Ranking all respondents for a promotion list (with 1 being the first to be promoted, 100 being the lowest ranking. It is possible to be equally rated. If three people were rated equally after the first 9, they would each get a ranking of 10. However, the next person would get a ranking of 13 since there are 12 people with a higher ranking)
Percent of job tasks that involve sensitive data
The facility number where the person works (1=Pentagon, 2=Ft. Bragg, etc.)
Number of contents with foreign agents reported last fiscal year
Distribution of an element
Follow-up measure of V7
Score on an aptitude test of security protocols
Score on aptitude test after training
Reported IQ score
Marital status (1=married, 0 = Not married (single, divorced, widowed))
If married, income of spouse
Number of reported threats
Number of threats confirmed
Year of last training
Age
All the security measures used in this facility are a necessary precaution*
There are no further security measures necessary at this facility*
No one in this facility would purposely compromise security*
*Respondents used this scale to state their opinions regarding questions 18 – 20.
5=Agree strongly
4=Agree
3=Neither agree nor disagree
2=Disagree
1=Strongly disagree
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|