A human resource manager at Beta Technologies, Inc. is interested in developing profiles of the Beta full-time employees based on the given representative sample of 52 of the companys full-time workers in the cases accompanying Excel data file. In particular, she is interested in determining the average age, number of years of relevant full-time work experience prior to coming to Beta, number of years of full-time work experience at Beta, number of years of post-secondary education, and annual salaries for those employees. Besides, she would like to analyze these characteristics separately for male and female employees. She is also interested in understanding the relationships between the employees salaries and other characteristics.

1. Create descriptive statistics data for the following variables: Age, Prior_Experience, Beta_Experience, Education, and Annual_Salary. Explain the Beta Technologies average full-time employee profile.

2. Develop a scatter plot for Beta_Experience and Annual_Salary variables. Explain what possible relationships exist between these two variables.

3. Create a histogram for Annual_Salary frequencies, and explain those salary frequencies.

4. Identify the correlation coefficients matrix using all data variables, and explain the association (strength of correlation) between salaries and all other employees characteristics.

(Can you please insert answers' pictures of this question on the excel file while explaining so it will more clear )

A B E F D Case #1: Beta Technologies, Inc. 46 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Gender 1 0 0 1 0 0 1 0 1 1 0 1 1 0 1 0 1 Age Prior_Experience 35 7 15 26 1 24 4 52 21 43 10 35 8 36 14 47 13 25 33 8 26 1 43 13 37 8 31 6 45 6 46 13 Beta_Experience Education Annual_Salary 10 4 80,450 7 6 92,912 0 4 71,214 2 4 54,750 24 7 145,285 8 4 90,442 0 6 82,207 5 4 84,331 14 6. 129,489 1 4 58,118 3 6 83,956 6 0 58,439 7 4 90,638 4 6 80,167 2 0 46,371 13 6 98,613 16 5 116,927 N 0 4 5 4 21 22 32 36 41 47 23 4 12 16 11 18 3 5 13 4 3 7 13 18 4 1 14 4 4 4| 8 4 4| 65 | | 4 2 0 1 1 1 0 0 1 0 1 1 0 1 1 0 1 1 1 0 1 0 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 6 4 2| 4| 30 31 51 47 36 32 19 42 56 26 32 63 33 20 43 4 80,556 57,183 86,712 136,473 143,588 59,901 43,100| 130,053 71,259 59,106| 69,224 38,743| 94,965 103,388 59,014 89,205| 138,763 45,829 42,784 94,199 3 4 3 5 8 3 6 11 4 1 7 6 10| 5 2 11 13| 5 3 20 1 2 14| 4| 0 6 3 4 6 2| 4 3 5 0 41 42 43 44 45 46 47 48 49 6 13 5 14 11 4 4 10 1 0 0 1 0 1 1 0 0 1 0 0 1 0 1 0 37 54 28] 38 62 52] 32 22] 40 46| 23 33/ 55 48 4 1 8 6| 12] 2 6| 19 11 3| 3 4 11 2] 3| 12| 16| 1 4 9 2] 4 4 4| 6 1 6 4 4 4 6 4| 0 86,932 133,278 62,100 99,987 125,471 91,194 46,109 62,340 79,455 89,861 50,327 41,008 130,874 117,966 44,986 50 10 4 51 52 53 54 55 1 10 16 8 2 0 4 19/ 2