Statistics Project, Part 1: Opening Axioms in Microsoft® Excel® and Running Descriptive Statistics

Name

University of

PSYCH/625: Statistics ce the Behavior Sciences

Name

August 17, 2020

Statistics Project – Part I: Opening Axioms in Excel and Running Descriptive Statistics

o Gender

o Male:24, Female:26

o Age

o Mean:32.02 Median:31 Mode:29

o Correlativeness with Direct Superintendent

o Mean:2.5 Median:3 Mode:3

o

o Telecommute Schedule

o Mean:1.18 Median:1 Mode:1

o

o Correlativeness with Coworkers

o Mean:1.92 Median:2 Mode:2

o

o Workplace Enjoyment Rating

o Mean:7.4 Median:8 Mode:8

o

o Workplace Promise Rating

o Mean:7.64 Median:7 Mode:8

Descriptive Statistics – Extract from Excel

Descriptives on Gender

Mean 1.52

Standard Error 0.071371

Median 2

Mode 2

Standard Deviation 0.504672

Sample Variance 0.254694

Kurtosis -2.07801

Skewness -0.08256

Range 1

Minimum 1

Maximum 2

Sum 76

Count 50

Confidence Level (95.0%) 0.143426

Period Descriptives

Mean 32.02

Standard Error 0.613780523

Median 31.5

Mode 29

Standard Deviation 4.340083701

Sample Variance 18.83632653

Kurtosis -1.086420147

Skewness 0.188689657

Range 15

Minimum 25

Maximum 40

Sum 1601

Count 50

Confidence Level (95.0%) 1.23343814

Superintendent Descriptives

Mean 2.5

Standard Error 0.14357

Median 3

Mode 3

Standard Deviation 1.015191

Sample Variance 1.030612

Kurtosis -1.06177

Skewness -0.06096

Range 3

Minimum 1

Maximum 4

Sum 125

Count 50

Confidence Level (95.0%) 0.288514

Telecommute Descriptives

Mean 1.18

Standard Error 0.054884

Median 1

Mode 1

Standard Deviation 0.388088

Sample Variance 0.150612

Kurtosis 0.988872

Skewness 1.717824

Range 1

Minimum 1

Maximum 2

Sum 59

Count 50

Confidence Level (95.0%) 0.110293

Coworkers Descriptives

Mean 1.92

Standard Error 0.094069

Median 2

Mode 2

Standard Deviation 0.665168

Sample Variance 0.442449

Kurtosis -0.65243

Skewness 0.08876

Range 2

Minimum 1

Maximum 3

Sum 96

Count 50

Confidence Level (95.0%) 0.189039

Workplace Enjoyment Descriptives

Mean 7.4

Standard Error 0.2

Median 8

Mode 8

Standard Deviation 1.414214

Sample Variance 2

Kurtosis -0.24984

Skewness -0.71252

Range 5

Minimum 4

Maximum 9

Sum 370

Count 50

Confidence Level (95.0%) 0.401915

Workplace Promise Descriptives

Mean 7.64

Standard Error 0.175569046

Median 8

Mode 8

Standard Deviation 1.241460628

Sample Variance 1.54122449

Kurtosis 0.859898343

Skewness -0.934455767

Range 6

Minimum 4

Maximum 10

Sum 382

Count 50

Confidence Level (95.0%) 0.352819207

Summary

Variable Description of Values

Gender 1= Male, 2=Female

Age Chronological Period (in years)

Correlativeness With Direct Superintendent 1 = privative correlativeness, 2 = impartial correlativeness, 3 = indisputefficient correlativeness, 4 = excellent correlativeness

Telecommute Schedule 1= no ability to telecommute, 2 = efficient to telecommute at mediumest 2 days per week

Correlativeness With Coworkers 1 = privative correlativeness, 2 = no correlativeness, 3 = indisputefficient correlativeness

Workplace Enjoyment Rating Scale 0-10, 0 = no enjoyment, 10 = fully blithesome

Workplace Promise Rating Scale 0-10, 1 = no promise, 10 = numerously occupied

Overall Combined Rating Scale 0-20, 0 = referpotent attributpotent attributpotent attributpotent blithesome and referpotent attributpotent attributpotent attributpotent occupied, 20 = fully blithesome and numerously occupied

According to the presented axioms, there are 50 fellow-creatures. Twenty-four were males, timeliness twenty-six were females ranging from the period of 25-40. The averperiod period was estimated to be 32.02, timeliness the median was 31, and most of the participants were period twenty-nine. When asked about correlativeness with superintendent they were told that 1 = privative correlativeness, 2 = impartial correlativeness, 3 = indisputefficient correlativeness, 4 = excellent correlativeness. The medium of this axioms was 2.5; the median was three and to-boot the command. The telecommute faction was 1= no ability to telecommute, brace = efficient to telecommute at mediumest brace days per week; the medium of these results was 1.18, the median was a undivided and the command remained a undivided as courteous. In the correlativeness with coworkers, the medium was 1.92, the median was brace, and the command was to-boot 2; 1 = privative correlativeness, brace = no correlativeness, 3 = indisputefficient correlativeness. Workplace Enjoyment Rating Scale 0-10, 10 = fully blithesome, its medium was a 7.4, median, and command an 8. Workplace Promise Rating Scale 0-10, 10 = numerously occupied, its medium was 7.64, the median 7 and the command 8.