5) CHART - Create a 3-D pie chart showing the breakdown of total Hours Worked into...

5) CHART - Create a 3-D pie chart showing the breakdown of total Hours Worked into total Overtime Hours and the NonOvertime hours located at the bottom of the database listing, row 37 columns E, F, G. The pie chart should show the values, the legend should indicate Overtime Hours and NonOvertime, and the chart title should be Total Daily Hours. Place this chart so that it will fill cells K1:R16. (Hint: When selecting the data for this chart remember that pie charts show parts of a whole so there’s no reason to include a total if you are displaying the parts making up that total.) [In spreadsheets, does it make sense to put totals at the bottom of the database?] 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. 10) DATA TABLE – on SHEET 3 create a One-Variable Data Table that will take the ODD numbers from 1 to 55 and will show each of the following independent calculations: multiply by $6.64; divide by 3.245; add $8.23 to each number; subtract 4 from each number.

Expert Solution

kindly see the uploaded images for the answers. I am not able to upload excel file else I could have uploaded that also. I have saved an excel file for this whole question

Colby Messinger answered 1 year ago

Draw a pie chart showing the relative proportion of the major components of energy expenditure. Compare...

Draw a pie chart showing the relative proportion of the major components of energy expenditure. Compare between the two drives that influence our desire to eat 3) Make a chart that compares the methods for measuring body fat

2. If total utility is not listed in a chart showing the number of apples consumed...

2. If total utility is not listed in a chart showing the number of apples consumed a. it is impossible to determine. b. it can be indirectly calculated by looking at total costs. c. it still can be determined by adding the sums of all the marginal utilities. d. both b) and c) are correct. 3. The rational economic being who compares costs and benefits a. does not think about the marginal costs and benefits, only the total costs and...

Make the following: a. frequency distribution b. pareto chart c. probability distribution d. pie graph for...

Make the following: a. frequency distribution b. pareto chart c. probability distribution d. pie graph for the following set of numbers : Prophecy - 15 out of 50 Advice - 7 out of 50 Wisdom - 17 out of 50 Compliments - 4 out of 50 Misc. - 7 out of 50

Which of the 3 analysis techniques (pie chart, financial statement, ratio analysis) would you as a...

Which of the 3 analysis techniques (pie chart, financial statement, ratio analysis) would you as a planner use, and with that in mind, what would be important … and how would you present those findings to your client.

On May 21, 2019, Christine worked 4.5 hours on Job A-1, and 3 hours on general...

On May 21, 2019, Christine worked 4.5 hours on Job A-1, and 3 hours on general "overhead activities." Christine is paid $20 per hour. Overhead is applied based on $30 per direct labor hour. Additionally, on May 21 Job A-1 requisitioned and entered into production $250 of direct material. On May 21, Christine, while working on Job A-1 used $27 of indirect material. Indirect material is included in the overhead application rate. Use this information to determine the total cost...

Create a query that shows the last name, employee ID, hours worked, and overtime amount owed...

Create a query that shows the last name, employee ID, hours worked, and overtime amount owed for hourly employees who earned overtime during week 2. Overtime is paid at 1.5 times the normal hourly rate for all hours worked over 40. Note that the amount shown in the query should be just the overtime portion of the wages paid. Also, this is not a totals query- amounts should be shown for individual workers. QBE grid template. This is the exact...

From the SAS data set myclass.fueldata, create - a horizontal bar chart showing the average highway MPG for each class;

From the SAS data set myclass.fueldata, create - a horizontal bar chart showing the average highway MPG for each class; - a vertical bar chart showing the average highway MPG for different fuel types; - a histogram showing the distribution of highway MPG for each class; Add a title to each chart and label axes properly.

create a power series for 5/2x-3 c=-3 create a power series for 5/(2x-3)^2 c=-3

3.) List at least 5 solvency ratios, 5 liquidity ratios, and 5 profitability ratios, showing the...

3.) List at least 5 solvency ratios, 5 liquidity ratios, and 5 profitability ratios, showing the formula for each and a brief explanation of why they are useful.

Create Gantt Chart and network Diagram Task Precedes Optimistic MostLikely Pessimistic Norm$ CrashTime Crash$ A D...

Create Gantt Chart and network Diagram Task Precedes Optimistic MostLikely Pessimistic Norm$ CrashTime Crash$ A D 4 4 4 1000 3 1301 B E 2 3 28 1391 4 2000 C F 2 4 12 2000 4 2713 D G 2 3 22 1198 5 1400 E G 1 4 7 899 3 1100 F H 7 10 19 2500 6 3765 G H 1 3 11 792 3 1450 H none 2 2 8 300 1 504

Question