he VP of HR at Uber has received an anonymous message asserting there are salary discrepancies in the organization. The VP has asked for your help in proving or disproving the assertion. The inquiry asserts there is a pay gap between two departments. The claim is that department A and department B do the same work but they do not receive equal pay. The VP wants to understand whether the concern is valid. Develop a set of findings and a recommendation using your knowledge of descriptive statistics (measures of central tendency and variability) and the dataset provided. Perform your calculations in the spreadsheet or in your notes. Then transfer your final answers into this playbook.

What is your objective?
Which stakeholders would you speak with?
What is your data question and how would you phrase it?

Based on the data set provided, do you have enough data to achieve your objective?

If you were to compare the salaries of Department A and B with the industry, what other data might you need?

What type of analysis could you do with this data?

REVIEW IT: Uber salary data

Access the salary data spreadsheet

Review the salary data

REVIEW IT: Finding the mean

Add up all of the values in your data set

Count the number of values in the data set

Divide the sum by the count

REVIEW IT: Finding the median

The median is the most informative measure of central tendency for skewed distributions or distributions with outliers. To find the median, first order your data. Then calculate the middle position based on n, the number of values in your data set.

If n is an odd number, the median lies at the position (n+1) / 2.

If n is an even number, the median is the mean of the values at position n / 2 and ( n/2) + 1.

Data Analytics Workflow Part 2

TRY IT:

ANALYSIS, CONCLUSIONS AND RECOMMENDATIONS

Take it further with another scenario

TRY IT:

If John joins department A with a salary of 450k and Lisa joins Department B with a salary of 70k will your opinion change about the discrepancy in salaries between A and B and why?

It's a Business Analytics class homework.

I need all answer ASAP please.

Thank you.

Module 8 Playbook Assignme.. salary calc example.xlsx-Go. salary calc example.xlsx - Go. What would be an appropriat.. Post a new question salary calc example XLSX \& File Edit View Insert Format Data Tools Help P=100%= View only - A1 - fx Employee Name \begin{tabular}{|c|l|l|l|l|} \hline \multicolumn{1}{|c|}{} & \multicolumn{1}{c|}{ A } & \multicolumn{2}{c|}{ B } \\ \hline 1 & Employee Name & Department & \multicolumn{2}{|c|}{ Salary } \\ \hline 2 & Jane & A & $108,457 \\ \hline 3 & Amar & A & $ & 82,235 \\ \hline 4 & Solaris & A & $ & 41,675 \\ \hline 5 & Arya & A & $ & 60,563 \\ \hline 6 & Duska & A & $ & 63,643 \\ \hline 7 & Evander & B & $ & 95,064 \\ \hline 8 & Idris & B & $ & 65,862 \\ \hline 9 & Kim & B & $ & 116,143 \\ \hline 10 & Kamal & B & $ & 64,520 \\ \hline 11 & Megan & B & $ & 43,394 \\ \hline 12 & & & & \\ \hline \end{tabular}