6) DATA TABLE - Create a Data Table that shows the average Daily Pay by gender f
ID: 3918959 • Letter: 6
Question
6) DATA TABLE - Create a Data Table that shows the average Daily Pay by gender for each department number. Start the criteria in cell E40 and the data table in cell E44.
7) SUBTOTALS - Create a Subtotal showing the total hours worked by department and the total overtime hours worked by gender within each department. Change to Outline View 3. [Which department works the most hours and do you see something odd about the overtime hours?] Copy the subtotal information to Sheet 2 using Copy/Paste Special Values (previously undisplayed/hidden data will appear when copied to Sheet 2).
Remove the Subtotaling on Sheet 1 using the Remove All button before continuing.
8) GOAL SEEK - In cell E7, place a formula that will multiply the Overtime Rate (B3) by the Total Number of Overtime Hours. Perform a Goal Seek to determine the overtime rate necessary to achieve $400 in total overtime pay. Leave the goal seek in place so that it can be graded.
9) EXTRACT (Advanced Filter) - Sort the database by the employees' names in ascending order. Extract just the name and the department number (Dept. No.) of those who worked more than 8 hours. Start the criteria in cell A40 and the extract output in cell A44.
Forulas Data Review View Home Insert Page Layout File Times New Roman 11A A1 a Copy Paste Format Painter Merge & Center Number Alignment Font Clipboard Total Number of Overtime Hours: A6 2Hourly Rate: S 6.64 3 Overtime Rate: 8.23 5 Average Hours Worked by Males in Dept No 2: Toial Number of Overtime Hours: Total Overtime Pay: 0 Employees Cender Dept No Department Hours Worked Overtime Hours NonOvertime Daily Daily Pay 11 Dartell, BaileyM 12 Shelton, Kent 13 Diffee, Kois s 26.56 Stull, Marlene 15 Crenshaw, SheilaF 17 Huntington, Mike M 19 Smith, Brian S 61.35 S 46.48 S 33.20 20 Hill, Pepzy Joan 21 Hil, Joy 22 White, Ball 23 Whitebead, 24 Adkina, Dorinda F S 61.35 S 69.58 $ 77.81 $ 19.92 S 61.35 S86.04 S 102.50 S 77.81 S 46.48 61.35 Clayton, Rex Triee, Ricky 28 Webb, William WM 29 Carman, Nancy 31 Webb, Patay 39.84 46.48 33 Lee, Tammy 34 Tsbbatts, RustyM2 35 Pierson, Tony S 94.27 144500 173 Sheeti Sheet2Explanation / Answer
Hi!
The answer to //6:
Since you have not specified the language in which you need the solution, I am writing it assuming it for C# :
Below is a general code which you can implement from any cell of data sheet.
using System;
class ifdemo
{
public static void Main()
{
int i,n,sum1=0,sum2=0,m,f;
char gender;
Console.WriteLine("Enter values for department 1");
for (int i = 1; i <= 8; i++)
{
Console.WriteLine("Enter gender");
gender=Char.Parse(Console.ReadLine());
if(gender=77)
{
Console.WriteLine("Enter daily wage of that worker");
m=int.Parse(Console.ReadLine());
sum1=sum1+m;
}
else
{
Console.WriteLine("Enter daily wage of that worker");
f=int.Parse(Console.ReadLine());
sum2=sum2+f;
}
}
Console.WriteLine("The average daily wage of male of that dept is ", sum1/5);
Console.WriteLine("The average daily wage of female of that dept is ", sum2/3);
Console.WriteLine("Enter values for department 2");
for (int i = 1; i <= 8; i++)
{
Console.WriteLine("Enter gender");
gender=Char.Parse(Console.ReadLine());
if(gender=77)
{
Console.WriteLine("Enter daily wage of that worker");
m=int.Parse(Console.ReadLine());
sum1=sum1+m;
}
else
{
Console.WriteLine("Enter daily wage of that worker");
f=int.Parse(Console.ReadLine());
sum2=sum2+f;
}
}
Console.WriteLine("The average daily wage of male of that dept is ", sum1/5);
Console.WriteLine("The average daily wage of female of that dept is ", sum2/3);
Console.WriteLine("Enter values for department 1");
for (int i = 1; i <= 10; i++)
{
Console.WriteLine("Enter gender");
gender=Char.Parse(Console.ReadLine());
if(gender=77)
{
Console.WriteLine("Enter daily wage of that worker");
m=int.Parse(Console.ReadLine());
sum1=sum1+m;
}
else
{
Console.WriteLine("Enter daily wage of that worker");
f=int.Parse(Console.ReadLine());
sum2=sum2+f;
}
}
Console.WriteLine("The average daily wage of male of that dept is ", sum1/5);
Console.WriteLine("The average daily wage of female of that dept is ", sum2/5);
}
In the case of multiple questions, the Chegg expert can answer the first question completely, so I am solving the first question. However, if you need a solution to a specific question, you may please let me know in the comments. I would be happy to help you out.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.