A human resources manager at Beta Technologies Inc. is trying to determine the variable that best explains the variation of employee salaries using the sample of 52 full-time employees in the file Beta.xlsx.All variables are explained in the following table.

Beta Technologies, Inc. Employee Salary Structure mployee No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Gender 1 0 0 1 0 1 1 0 1 0 0 1 0 1 1 0 1 0 1 1 1 0 0 1 0 1 0 0 1 0 1 1 1 0 0 1 0 1 1 0 1 0 1 1 0 0 1 Age Prior_Experience Beta_Experience Education Annual_Salary 39 5 12 4 $38,450 44 12 8 6 $50,912 24 0 2 4 $29,356 25 2 1 4 $27,750 56 5 25 8 $109,285 41 9 10 4 $48,442 33 6 2 6 $40,207 37 11 6 4 $42,331 51 12 16 6 $87,489 23 0 1 4 $26,118 31 5 4 6 $41,956 27 0 8 0 $17,439 47 11 9 4 $49,638 35 5 5 6 $43,184 29 5 4 0 $14,371 46 4 15 6 $54,613 50 10 17 4 $76,927 30 3 6 4 $38,556 34 10 1 4 $37,183 42 11 8 4 $50,712 51 10 15 8 $90,473 63 16 20 4 $93,588 28 0 5 4 $36,901 32 4 1 4 $33,100 55 11 16 6 $89,867 45 20 2 4 $51,259 34 2 12 2 $19,106 33 2 7 4 $39,224 23 0 1 4 $28,743 40 4 13 6 $54,965 48 6 15 4 $53,388 27 0 6 0 $18,014 36 5 5 6 $39,205 58 9 22 4 $88,763 31 1 1 6 $35,829 21 0 1 2 $17,784 47 5 16 4 $54,199 35 3 7 4 $36,932 52 12 14 8 $93,278 29 3 3 2 $22,100 42 11 7 4 $49,987 60 10 21 4 $85,471 50 8 13 4 $51,194 33 1 2 6 $36,109 26 0 5 2 $21,750 38 6 6 6 $39,455 44 7 12 4 $49,861 48 49 50 51 52 0 1 0 0 1 25 37 53 46 20 0 8 13 7 0 3 5 13 18 1 4 4 6 4 0 $30,327 $31,008 $90,874 $57,966 $15,945 Em lo ee No. l throu 52 Gender l=female= U = male Age Age at last birthday (in years) _ _ Number of years of relevant professional experience prior to hiring Prior experience at Beta Technologies. Beta exE'ence Number of years of Hofessional gperience at Beta Technologies. Education Number of years of Est-second education. Annual salary Employee's current annual salary at Beta Technologies {in dollars]. {3} Construct relevant graphs to characterize the distributions for two variables: age and annual salary- (b) Use IMinitab or Excel to generate relevant graphs to reveal whether the employee's (i) gender, (ii) age= (iii) number of years of relevant work experience prior to employment at Beta, {iv} the number of years of employment at Beta, or (v) the number of years of postsecondary education has the strongest linear relationship with annual salary. {c} Use l'lu'nitab or Excel to generate relevant numerical measures in answers question in (h) again. (:1) In this part, suppose we onlyr focus on the rst 10 employees. Show the work to verify the correlation coefficient between annual salary and Beta experience is approximately 93%