Sheet1 Rank Monthly Salary Gende Senior...

Question

Sheet1
    Rank    Monthly Salary    Gende
    Senior Manager    125,000    M
    Manager    100,000    M
    Manager    100,000    M
    Manager    100,000    M
    Manager    100,000    M
    Manager    100,000    F
    Manager    100,000    F
    Manager    100,000    F
    Manager    100,000    F
    Manager    100,000    F
    Supervisor    75,000    M
    Supervisor    75,000    F
    Supervisor    75,000    M
    Supervisor    75,000    F
    Supervisor    75,000    M
    Supervisor    75,000    M
    Supervisor    75,000    F
    Supervisor    75,000    F
    Supervisor    75,000    F
    Supervisor    75,000    M
    Supervisor    75,000    M
    Supervisor    75,000    M
    Supervisor    75,000    M
    Supervisor    75,000    F
    Supervisor    75,000    F
    Supervisor    75,000    M
    Supervisor    75,000    M
    Supervisor    75,000    F
    Supervisor    75,000    M
    Supervisor    75,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    M
    Employees    45,000    F
    Employees    45,000    M
    Employees    45,000    F

dataset-4-uxnp1lit.xlsx

Parul · Accepted Answer

Sheet2
	Row Labels	Sum of Monthly Salary
	F	3305000
	Employees	2205000
	Manager	500000
	Supervisor	600000
	M	3720000
	Employees	2295000
	Manager	400000
	Senior Manager	125000
	Supervisor	900000
	Grand Total	7025000
Analysis of Data
Total	
Employees	Manager	Supervisor	Employees	Manager	Senior Manager	Supervisor	F	M	2205000	500000	600000	2295000	400000	125000	900000	
Sheet1
	Rank	Monthly Salary	Gender
	Senior Manager	125,000	M
	Manager	100,000	M
	Manager	100,000	M
	Manager	100,000	M
	Manager	100,000	M
	Manager	100,000	F
	Manager	100,000	F
	Manager	100,000	F
	Manager	100,000	F
	Manager	100,000	F
	Supervisor	75,000	M
	Supervisor	75,000	F
	Supervisor	75,000	M
	Supervisor	75,000	F
	Supervisor	75,000	M
	Supervisor	75,000	M
	Supervisor	75,000	F
	Supervisor	75,000	F
	Supervisor	75,000	F
	Supervisor	75,000	M
	Supervisor	75,000	M
	Supervisor	75,000	M
	Supervisor	75,000	M
	Supervisor	75,000	F
	Supervisor	75,

Sheet1 Rank Monthly Salary Gender Senior...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment