Data Analysis Question 1(a) Weekly Ordinary Time Salary Descriptives Statistic Std. Error Weekly ordinary time salary (excluding paid overtime, etc.) Mean $874.17 $57.403 95% Confidence Interval for...

1 answer below »
Data Analysis
Question 1(a)
Weekly Ordinary Time Salary





































































Descriptives
StatisticStd. Error
Weekly ordinary time salary (excluding paid overtime, etc.)Mean$874.17$57.403
95% Confidence Interval for MeanLower Bound$758.69
Upper Bound$989.65
5% Trimmed Mean$856.16
Median$742.50
Variance158165.461
Std. Deviation$397.700
Minimum$400
Maximum$1,720
Range$1,320
Interquartile Range$690
Skewness.633.343
Kurtosis-.908.674






Question 1(b) i
Gender
































































































































Descriptives
GenderStatisticStd. Error
Weekly ordinary time salary (excluding paid overtime, etc.)MaleMean$852.04$68.201
95% Confidence Interval for MeanLower Bound$711.58
Upper Bound$992.50
5% Trimmed Mean$835.81
Median$810.00
Variance120936.438
Std. Deviation$347.759
Minimum$420
Maximum$1,590
Range$1,170
Interquartile Range$461
Skewness.693.456
Kurtosis-.398.887
FemaleMean$900.32$97.397
95% Confidence Interval for MeanLower Bound$697.77
Upper Bound$1,102.87
5% Trimmed Mean$882.93
Median$680.00
Variance208694.703
Std. Deviation$456.831
Minimum$400
Maximum$1,720
Range$1,320
Interquartile Range$781
Skewness.537.491
Kurtosis-1.383.953




(b) (ii)
Manager s and non managers































































































































Descriptives
PositionStatisticStd. Error
Weekly ordinary time salary (excluding paid overtime, etc.)ManagerMean$929.13$78.629
95% Confidence Interval for MeanLower Bound$766.47
Upper Bound$1,091.78
5% Trimmed Mean$915.60
Median$810.00
Variance148381.853
Std. Deviation$385.204
Minimum$400
Maximum$1,720
Range$1,320
Interquartile Range$537
Skewness.672.472
Kurtosis-.614.918
Non-ManagerMean$819.21$83.796
95% Confidence Interval for MeanLower Bound$645.86
Upper Bound$992.55
5% Trimmed Mean$797.04
Median$535.00
Variance168522.346
Std. Deviation$410.515
Minimum$420
Maximum$1,630
Range$1,210
Interquartile Range$735
Skewness.727.472
Kurtosis-1.057.918




(b) (iii)
Three levels of job security
























































































































































































Descriptives
Perception of Job Security at ConrobarStatisticStd. Error
Weekly ordinary time salary (excluding paid overtime, etc.)InsecureMean$849.71$134.949
95% Confidence Interval for MeanLower Bound$558.17
Upper Bound$1,141.25
5% Trimmed Mean$826.35
Median$680.00
Variance254958.066
Std. Deviation$504.934
Minimum$400
Maximum$1,720
Range$1,320
Interquartile Range$1,026
Skewness.950.597
Kurtosis-.9601.154
SecureMean$886.70$76.375
95% Confidence Interval for MeanLower Bound$726.85
Upper Bound$1,046.55
5% Trimmed Mean$872.17
Median$867.50
Variance116662.011
Std. Deviation$341.558
Minimum$500
Maximum$1,535
Range$1,035
Interquartile Range$668
Skewness.467.512
Kurtosis-.995.992
Very SecureMean$880.71$101.922
95% Confidence Interval for MeanLower Bound$660.53
Upper Bound$1,100.90
5% Trimmed Mean$873.02
Median$860.00
Variance145433.143
Std. Deviation$381.357
Minimum$420
Maximum$1,480
Range$1,060
Interquartile Range$846
Skewness.380.597
Kurtosis-1.1771.154




Question 2 (a)






































































Descriptives
StatisticStd. Error
Job satisfaction. Rating from 0 to 20.Mean13.67.369
95% Confidence Interval for MeanLower Bound12.92
Upper Bound14.41
5% Trimmed Mean13.76
Median14.00
Variance6.525
Std. Deviation2.554
Minimum8
Maximum18
Range10
Interquartile Range4
Skewness-.322.343
Kurtosis-.441.674






Job sta is a categorical data not numerical continuous data and therefore histogram cannot be produced ( it’s a bar chart)
Question 2b(1)
































































































































Descriptives
GenderStatisticStd. Error
Job satisfaction. Rating from 0 to 20.MaleMean14.50.471
95% Confidence Interval for MeanLower Bound13.53
Upper Bound15.47
5% Trimmed Mean14.67
Median15.00
Variance5.780
Std. Deviation2.404
Minimum9
Maximum17
Range8
Interquartile Range4
Skewness-.833.456
Kurtosis.128.887
FemaleMean12.68.516
95% Confidence Interval for MeanLower Bound11.61
Upper Bound13.75
5% Trimmed Mean12.65
Median13.00
Variance5.846
Std. Deviation2.418
Minimum8
Maximum18
Range10
Interquartile Range3
Skewness.122.491
Kurtosis.630.953




































































































































Descriptives
PositionStatisticStd. Error
Job satisfaction. Rating from 0 to 20.ManagerMean13.88.501
95% Confidence Interval for MeanLower Bound12.84
Upper Bound14.91
5% Trimmed Mean13.93
Median14.00
Variance6.027
Std. Deviation2.455
Minimum9
Maximum18
Range9
Interquartile Range4
Skewness-.247.472
Kurtosis-.408.918
Non-ManagerMean13.46.548
95% Confidence Interval for MeanLower Bound12.32
Upper Bound14.59
5% Trimmed Mean13.56
Median14.00
Variance7.216
Std. Deviation2.686
Minimum8
Maximum17
Range9
Interquartile Range5
Skewness-.361.472
Kurtosis-.425.918




Question 2b (3)

























































































































































































Descriptives
Perception of Job Security at ConrobarStatisticStd. Error
Job satisfaction. Rating from 0 to 20.InsecureMean12.07.286
95% Confidence Interval for MeanLower Bound11.45
Upper Bound12.69
5% Trimmed Mean12.02
Median12.00
Variance1.148
Std. Deviation1.072
Minimum11
Maximum14
Range3
Interquartile Range2
Skewness.714.597
Kurtosis-.5241.154
SecureMean13.80.683
95% Confidence Interval for MeanLower Bound12.37
Upper Bound15.23
5% Trimmed Mean13.94
Median14.50
Variance9.326
Std. Deviation3.054
Minimum8
Maximum17
Range9
Interquartile Range4
Skewness-.886.512
Kurtosis-.315.992
Very SecureMean15.07.529
95% Confidence Interval for MeanLower Bound13.93
Upper Bound16.21
5% Trimmed Mean15.08
Median15.00
Variance3.918
Std. Deviation1.979
Minimum12
Maximum18
Range6
Interquartile Range3
Skewness-.184.597
Kurtosis-1.2101.154




Question 3
Weekly Salary vs EduYears


Weekly Salary vs AtConrobar


Productivity vs AtConrobar


Overtime vs Age


Productivity vs WeekSalary


Days absent versuse age


Productivity versuse days absents


Weeksalary vrsuse age


Question 4
































































































































Descriptives
GenderStatisticStd. Error
Years of educationMaleMean13.00.511
95% Confidence Interval for MeanLower Bound11.95
Upper Bound14.05
5% Trimmed Mean12.85
Median12.00
Variance6.800
Std. Deviation2.608
Minimum10
Maximum19
Range9
Interquartile Range4
Skewness.850.456
Kurtosis-.279.887
FemaleMean14.55.525
95% Confidence Interval for MeanLower Bound13.45
Upper Bound15.64
5% Trimmed Mean14.33
Median14.00
Variance6.069
Std. Deviation2.464
Minimum12
Maximum21
Range9
Interquartile Range2
Skewness1.674.491
Kurtosis2.884.953




Question 5
































































































































Descriptives
GenderStatisticStd. Error
Days absent as taken as Personal Leave. Maximum of 5 days allowed.MaleMean2.935.3534
95% Confidence Interval for MeanLower Bound2.207
Upper Bound3.662
5% Trimmed Mean2.983
Median3.500
Variance3.247
Std. Deviation1.8020
Minimum.0
Maximum5.0
Range5.0
Interquartile Range3.6
Skewness-.351.456
Kurtosis-1.459.887
FemaleMean1.727.3454
95% Confidence Interval for MeanLower Bound1.009
Upper Bound2.445
5% Trimmed Mean1.641
Median1.250
Variance2.624
Std. Deviation1.6199
Minimum.0
Maximum5.0
Range5.0
Interquartile Range3.1
Skewness.858.491
Kurtosis-.499.953


5b


Question 6 (a)






































































Descriptives
StatisticStd. Error
Productivity Performance - 100% as baseMean98.860.6349
95% Confidence Interval for MeanLower Bound97.583
Upper Bound100.138
5% Trimmed Mean98.825
Median98.000
Variance19.349
Std. Deviation4.3988
Minimum91.2
Maximum107.0
Range15.8
Interquartile Range7.4
Skewness.221.343
Kurtosis-.975.674




































































































































Descriptives
GenderStatisticStd. Error
Productivity Performance - 100% as baseMaleMean99.981.7791
95% Confidence Interval for MeanLower Bound98.376
Upper Bound101.585
5% Trimmed Mean99.850
Median98.050
Variance15.783
Std. Deviation3.9728
Minimum95.3
Maximum107.0
Range11.7
Interquartile Range6.7
Skewness.632.456
Kurtosis-1.161.887
FemaleMean97.536.9799
95% Confidence Interval for MeanLower Bound95.499
Upper Bound99.574
5% Trimmed Mean97.478
Median96.300
Variance21.125
Std. Deviation4.5962
Minimum91.2
Maximum105.0
Range13.8
Interquartile Range8.8
Skewness.207.491
Kurtosis-1.531.953


( c)
( see lecture 8), do not copy word for word.
(d)


Question 7 (a)






































































Descriptives
StatisticStd. Error
Age of respondentMean36.461.651
95% Confidence Interval for MeanLower Bound33.14
Upper Bound39.78
5% Trimmed Mean36.43
Median36.00
Variance130.849
Std. Deviation11.439
Minimum17
Maximum58
Range41
Interquartile Range20
Skewness-.038.343
Kurtosis-1.082.674


(b)































































































































Descriptives
PositionStatisticStd. Error
Age of respondentManagerMean38.421.997
95% Confidence Interval for MeanLower Bound34.29
Upper Bound42.55
5% Trimmed Mean38.73
Median38.50
Variance95.732
Std. Deviation9.784
Minimum18
Maximum53
Range35
Interquartile Range15
Skewness-.469.472
Kurtosis-.377.918
Non-ManagerMean34.502.611
95% Confidence Interval for MeanLower Bound29.10
Upper Bound39.90
5% Trimmed Mean34.19
Median30.50
Variance163.652
Std. Deviation12.793
Minimum17
Maximum58
Range41
Interquartile Range21
Skewness.360.472
Kurtosis-1.192.918

(C) See lecture 8
Question 8
H0: µ = 45
HA
: µ ? 45
































One-Sample Test
Test Value = 45
tdfSig. (2-tailed)Mean Difference95% Confidence Interval of the Difference
LowerUpper
Age of respondent-5.17347.000-8.542-11.86-5.22


p-value
Assume a = 0.05
If p-value
A

(and the memorandum)
Conclusion:
There is insufficient evident to suggest that the mean age of all employees nationwide working in similar industries to Conrobar is 45 years.
Answered Same DayDec 24, 2021

Answer To: Data Analysis Question 1(a) Weekly Ordinary Time Salary Descriptives Statistic Std. Error Weekly...

Robert answered on Dec 24 2021
126 Votes
Data Analysis
1. The employee databasecontains the variable weekly ordinary time salary (WkSalry).With
reference to thesample, we require:
(a) Summary statistics for the entire sample of 48 employees for this variable, that you
thinkmay berelevant.
Descriptive Statistics
N Minimum Maximum Mean
Std.
Deviation Skewness Kurtosis
Statistic Statistic Statistic Statistic Statistic Statistic Std. Error Statistic Std. Error
Weekly ordinary time

salary (excluding
paid overtime, etc.)
48 $400 $1,720 $874.17 $397.700 .633 .343 -.908 .674
Valid N (listwise) 48




(b)A similar studybased on:
(i)gender
Descriptives
Gender Statistic Std. Error
Weekly ordinary time
salary (excluding paid
overtime, etc.)
Male Mean $852.04 $68.201
95% Confidence
Interval for Mean
Lower Bound $711.58
Upper Bound $992.50
5% Trimmed Mean $835.81
Median $810.00
Variance 1.209E5
Std. Deviation $347.759
Minimum $420
Maximum $1,590
Range $1,170
Interquartile Range $461
Skewness .693 .456
Kurtosis -.398 .887
Female Mean $900.32 $97.397
95% Confidence Lower Bound $697.77
Interval for Mean Upper Bound $1,102.8
7
5% Trimmed Mean $882.93
Median $680.00
Variance 2.087E5
Std. Deviation $456.831
Minimum $400
Maximum $1,720
Range $1,320
Interquartile Range $781
Skewness .537 .491
Kurtosis -1.383 .953




(ii)managers and non- managers
Descriptives
Position Statistic Std. Error
Weekly ordinary time salary MMean $929.12 $78.629
(excluding paid overtime,
etc.)
a
n
a
g
e
r
95% Confidence Interval for
Mean
Lower Bound $766.47
Upper Bound $1,091.78
5% Trimmed Mean $915.60
Median $810.00
Variance 1.484E5
Std. Deviation $385.204
Minimum $400
Maximum $1,720
Range $1,320
Interquartile Range $537
Skewness .672 .472
Kurtosis -.614 .918
N
o
n
-
M
a
n
a
g
e
r
Mean $819.21 $83.796
95% Confidence Interval for
Mean
Lower Bound $645.86
Upper Bound $992.55
5% Trimmed Mean $797.04
Median $535.00
Variance 1.685E5
Std. Deviation $410.515
Minimum $420
Maximum $1,630
Range $1,210
Interquartile Range $735
Skewness .727 .472
Kurtosis -1.057 .918



(iii) three levels of job security
Descriptives
Perception of Job Security at Conrobar Statistic Std. Error
Weekly ordinary time salary
(excluding paid overtime,
etc.)
Insecure Mean $849.71 $134.949
95% Confidence Interval for
Mean
Lower Bound $558.17
Upper Bound $1,141.25
5% Trimmed Mean $826.35
Median $680.00
Variance 2.550E5
Std. Deviation $504.934
Minimum $400
Maximum $1,720
Range $1,320
Interquartile Range $1,026
Skewness .950 .597
Kurtosis -.960 1.154
Secure Mean $886.70 $76.375
95% Confidence Interval for
Mean
Lower Bound $726.85
Upper Bound $1,046.55
5% Trimmed Mean $872.17
Median $867.50
Variance 1.167E5
Std. Deviation $341.558
Minimum $500
Maximum $1,535
Range $1,035
Interquartile Range $668
Skewness .467 .512
Kurtosis -.995 .992
Very Secure Mean $880.71 $101.922
95% Confidence Interval for
Mean
Lower Bound $660.53
Upper Bound $1,100.90
5% Trimmed Mean $873.02
Median $860.00
Variance 1.454E5
Std. Deviation $381.357
Minimum $420
Maximum $1,480
Range $1,060
Interquartile Range $846
Skewness .380 .597
Kurtosis -1.177 1.154


2. The employeedata base contains the variable job satisfaction (Jobsat).With reference to
thesample, we require:
(a) Summary statistics for the entire sample of 48 employees for this variable, that you
thinkmay berelevant.
Descriptive Statistics
N Minimum Maximum Mean
Std.
Deviation Skewness Kurtosis
Statistic Statistic Statistic Statistic Statistic Statistic Std. Error Statistic Std. Error
Job satisfaction.
Rating from 0 to 20.
48 8 18 13.67 2.554 -.322 .343 -.441 .674
Valid N (listwise) 48



(b)A similar study based on:
(i)gender
Descriptives
Gender Statistic Std. Error
Job satisfaction. Rating
from 0 to 20.
Male Mean 14.50 .471
95% Confidence Interval
for Mean
Lower Bound 13.53
Upper Bound 15.47
5% Trimmed Mean 14.67
Median 15.00
Variance 5.780
Std. Deviation 2.404
Minimum 9
Maximum 17
Range 8
Interquartile Range 4
Skewness -.833 .456
Kurtosis .128 .887
Female Mean 12.68 .516
95% Confidence Interval
for Mean
Lower Bound 11.61
Upper Bound 13.75
5% Trimmed Mean 12.65
Median 13.00
Variance 5.846
Std. Deviation 2.418
Minimum 8
Maximum 18 ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here