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. Please answer with equations.

11

AutoSave OFF Home Insert G Paste [A v D57 Draw Page Layout Times New Roman BIU Formulas Data Review View v 11 A A A fxx B C D Hourly Rate: $ 6.64 Overtime Rate: $ 11.11 5 Average Hours Worked by Males in Dept No 2: Assignment10 Automate Tell me Q-SEIRES Comments Share Wrap Text General 1 7 Insert Delete Merge & Center $%9 Conditional Format Cell Formatting as Table Styles Format v v Sort & Filter Find & Select Analyze Data Sensitivity E Gender Depi ne M 2 Total Number of Overtime Hours: 5.4 36 Total Overtime Pay: S 400.00 G H ] J K L M N 0 P Q R S T Total Daily Hours 1 Manufacturing 2 sales 3 computer 8 9 10 Employees Gender Dept No 11 Adkins, Dorinda F 2 Department sales Ilours Worked Overtime Ilours NonOvertime Daily 0 0 0 NONE Daily Pay $ 12 Boucher, Leslie F 3 computer 9 8 OVERTIME S 64.23 13 Carman, Nancy F 2 sales I 0 7 46.48 $ 46.48 14 Clayton, Rex M Manufacturing 12 4 8 OVERTIME S 97.56 15 Crenshaw, Sheila F Manufacturing 10 2 8 OVERTIME S 75.34 -Hour Workad Overtime Ho NonOvertim 16 Darrell, Bailey M 2 sales 4 0 4 26.56 $ 26.56 17 Donlon, Susic F 1 Manufacturing 9 1 8 OVERTIME S 64.23 18 Diffe, Kois F 3 computer 6 0 6 39.84 $ 39.84 19 Hall, Mike M 2 sales 5 0 1 3335 33.20 20 Hammons, Larry M 1 Manufacturing 6 0 6 39.84 $ 39.84 21 Hill, Joy F 1 Manufacturing 10 2 8 OVERTIME $ 75.34 22 Hill, Peggy Jean F 3 computer 1 8 OVERTIME $ 64,23 23 Huntington, Mike M 2 sales 0 7 46.48 $ 46.48 24 Lee, Tammy F 3 computer 0 7 46.48 $ 46.48 25 Picrec, Sammy M 3 computer 5 8 OVERTIME $ 108.68 26 Pierson, Tony M Manufacturing 11 3 8 OVERTIME S 86.45 27 Savoie. Tony M 3 computer 9 1 X OVERTIME S 64.23 28 Shelton, Kent M 1 Manufacturing 0 53.12 $ 53.12 29 Smith, Brian M 3 computer 12 4 8 OVERTIME $ 97.56 30 Stall, Marlene F 3 computer 0 0 0 NONE $ 31 Tibbetts, Rusty M 2 sales 0 53.12 $ 53.12 32 Trice, Ricky M 3 computer 14 6 8 OVERTIME $ 119.79 33 Webb. Patry F 2 sales 8 0 8 53.12 S 53.12 34 Webb, William W. M 1 Manufacturing 11 8 OVERTIME S 86.45 35 White, Bill M 3 computer LI 3 8 OVERTIME $ 86.45 36 Whitehead, Bobby M 2 sales 3 0 3 19.92 $ 19.92 37 200 36 173 $ 1.548 32 38 39 40 Hours worked 418 42 43 44 Employees 45 Boucher, Leslie 46 Clayton, Rex 47 Crenshaw. Sheila Ready Sheet1 Dept No 3 1 Sheet2 Accessibility: Investigate Gender Depi No. Average Daily Pay F 1 S 71.64 M 1 S 72.69 F 2 S 33.20 M 2 S 35.86 F 3 S 42.96 M 3 S 95.34 Sheet3 + 100%