how do i do this, what formulas do i use

please explain steps

thank you!!

using excel

Degree Age PhD 38 PhD 32 AVERAGE EARNINGS Age Floor PhD 49 Age Ceiling Bachelor's Master's Doctorate PhD 22 1 24 PhD 22 25 29 Bachelor's 56 30 34 Bachelor's 56 35 39 Master's 31 40 44 Master's 32 45 49 PhD 53 50 54 PhD 53 55 59 PhD 50 60 100 PhD 50 PhD 41 PhD 24 Eamings $20,130 $21,061 $21,061 $21,229 $21,229 $21,275 $21,275 $21,275 $21,275 $21,275 $21,275 $21,275 $21,275 $21,806 $22,002 $22,155 $ $22,191 $22,559 $22.559 $23,244 $24,273 $25,908 $26,527 $27,487 $28,060 $28,223 $28,223 $29,388 $29,388 $29,388 $29,388 $30,248 Instructions Columns A:C hold earnings, degree, and age data. Please fill in the table above (in the green filled cells) with the average earnings by age bracket and degree level. Use formulas so the results would remain unchanged if columns A:C were to be reorganized. PhD 32 PhD 28 Master's 31 Master's 31 Bachelor's 33 Answer PhD 26 Other Questions (please include your formulas used to determine the answer) What is the median earnings in the sample? What is the degree of the person with median earnings in the sample? What is the age of the person with median earnings in the sample? Master's 65 PhD 45 PhD 30 Master's 69 PhD 23 PhD 23 Master's 60 Master's 45 PhD 27 PhD 27 Master's 34