Staff Data
Start with the Excel workbook (spreadsheet) Staff Data
– start.xlsx.
Create a binary encoding in column I for any male employee
over 50. The column label in I1
for this
encoding should be titled “Males > 50”. Create a function in I2 that can be copied down throughout the
range
that returns a 1
if both are of th
ese conditions
(i.e. Gender is M and Age is greater than 50 years
of age) are true. If both of these conditions are not true, then return
a 0
. Though this can be performed
various ways, utilize the IF and AND functions.
Create a binary encoding in column J for any female who is
45 or under. The column lab
el in J
1 for this
enc
oding should be titled “Female and Age <= 45”. Create a 1 if both are true and a 0 otherwise. Though
this can be performed various ways, utilize the IF and AND functions.
Create a binary e
ncoding in column K if an employee is either a male that is over the age of 50 or is a
female who is 45 or under. The column heading for K1 should be “
Male and Age >
50”
or
“Female and
Age <= 45.
” Hint: Utilize the information that you have already encoded in columns I and J along with
the logical functions (i.e. IF and OR
).
In M1:O7 there is a preformatted range. In cells N2 and O2, calculate the average age and salary for the
entire staff shown in the range A1:G359. In cells N3 and O3, calculate the average age and salary for just
the males shown in
the range A1:G359. In cells N4 and O4, calculate the average age and salary for just
the females shown in the range A1:G359. In cells N5 and O5, calculate the average age and salary for the
first binary encoded column in column I. In cells N6 and O6, calcu
late the average age and salary for the
second binary encoded column in column J. Finally, in cells N7 and O7, calculate the average age and
salary for the third binary encoded column in column K. Format the range N2:N7 so it shows only one
decimal. Format
range O2:O7 as an accounting format showing two decimals.
Hint: You will need to utilize the AVERAGEIF function
. When summarizing the binary encodings, utilize
the encoded values of 1 and 0 to your advantage.
Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!WRITE MY ESSAY NOW
