Discuss the below:
A list of 52 employees is below.
1) Compute the mean, median, and standard deviation of the list of the 52 employees.
2) Use excel to choose a simple random sample of size 15 from this frame.
3) Compute the mean, medium, and standard deviation of the annual salaries for the 15 employees included in the simple random sample.Compare these statistics with the computed descriptive measures for the frame obtained. Is the simple random sample representative of the frame with respect to the annual salary variable?
Beta Technologies, Inc. Employee Salary Structure
Gender Age Prior_Experience Beta_Experience Education Annual_Salary
1 39 5 12 4 $38,450
0 44 12 8 6 $50,912
0 24 0 2 4 $29,356
1 25 2 1 4 $27,750
0 56 5 25 8 $109,285
1 41 9 10 4 $48,442
1 33 6 2 6 $40,207
0 37 11 6 4 $42,331
1 51 12 16 6 $87,489
0 23 0 1 4 $26,118
0 31 5 4 6 $41,956
1 27 0 8 0 $17,439
0 47 11 9 4 $49,638
1 35 5 5 6 $43,184
1 29 5 4 0 $14,371
0 46 4 15 6 $54,613
1 50 10 17 4 $76,927
0 30 3 6 4 $38,556
1 34 10 1 4 $37,183
1 42 11 8 4 $50,712
1 51 10 15 8 $90,473
0 63 16 20 4 $93,588
0 28 0 5 4 $36,901
1 32 4 1 4 $33,100
0 55 11 16 6 $89,867
1 45 20 2 4 $51,259
0 34 2 12 2 $19,106
0 33 2 7 4 $39,224
1 23 0 1 4 $28,743
0 40 4 13 6 $54,965
1 48 6 15 4 $53,388
1 27 0 6 0 $18,014
1 36 5 5 6 $39,205
0 58 9 22 4 $88,763
0 31 1 1 6 $35,829
1 21 0 1 2 $17,784
0 47 5 16 4 $54,199
1 35 3 7 4 $36,932
1 52 12 14 8 $93,278
0 29 3 3 2 $22,100
1 42 11 7 4 $49,987
0 60 10 21 4 $85,471
1 50 8 13 4 $51,194
1 33 1 2 6 $36,109
0 26 0 5 2 $21,750
0 38 6 6 6 $39,455
1 44 7 12 4 $49,861
0 25 0 3 4 $30,327
1 37 8 5 4 $31,008
0 53 13 13 6 $90,874
0 46 7 18 4 $57,966
1 20 0 1 0 $15,945