5. Place some data filters on the Beta file. Specifically, show only those records of employees earning no less than $50,000, having an education level of either 4 or 8 years, are between 50 and 60 years old (inclusive), and are male. Then show only those with above average" prior experience. Copy-paste the values from your remaining data set to another sheet so that you can calculate the average salary of this remaining group using a simple AVERAGE function. Home Insert Page Layout Formulas Data Review View Cut Calibri 11 A- A- Copy Paste B I U A ili Format A2 fox D E F G H Education 6 UINO Beta Experience 12 8 2 1 25 10 N 6 16 1 4 8 6 4 6 4 6 0 4 6 O on 5 4 15 17 6 1 6 4 4 4 B 2 3 Gender Age Prior Experience 4 Female 39 5 5 Male 44 12 6 Male 24 7 Female 25 8 Male 56 9 Female 41 9 10 Female 33 6 11 Male 37 11 12 Female 51 12 13 Male 23 14 Male 31 5 15 Female 27 16 Male 47 17 Female 35 5 18 Female 29 5 19 Male 46 4 20 Female 50 10 21 Male 30 3 22 Female 34 10 23 Female 42 11 24 Female 51 10 25 Male 63 16 26 Male 28 27 Female 32 4 28 Male 55 11 29 Female 45 20 30 Male 34 2 31 Male 33 2 32 Female 23 0 33 Male 40 4 34 Female 48 6 35 Female 27 0 36 Female 36 5 37 Male 58 9 38 Male 31 1 39 Female 21 0 40 Male 47 5 41 Female 35 3 42 Female 52 12 43 Male 29 3 44 Female 42 11 45 Male 60 10 46 Female 50 8 47 Female 33 1 48 Male 26 49 Male 38 6 50 Female 44 7 51 Male 25 52 Female 37 53 Male 53 13 54 Male 46 7 55 Female 20 15 20 5 1 16 2 12 7 1 13 15 6 5 22 1 1 16 7 14 3 7 21 13 2 5 6 12 3 5 13 OAAAANAAANDAANA OAAANAAAAA Annual Salary $38,450 $50,912 $29,356 $27,750 $109,285 $48,442 $40,207 $42,331 $87,489 $26,118 $41,956 $17,439 $49,638 $43,184 $14,371 $54,613 $76,927 $38,556 $37,183 $50,712 $90,473 $93,588 $36,901 $33,100 $89,867 $51,259 $19,106 $39,224 $28,743 $54,965 $53,388 $18,014 $39,205 $88,763 $35,829 $17,784 $54,199 $36,932 $93,278 $22,100 $49,987 $85,471 $51,194 $36,109 $21,750 $39,455 $49,861 $30,327 $31,008 $90,874 $57,966 $15,945 OOOOO 1