How many variables does the Salaries dataset contain? Formula for excel (Please not the data continues down the columns of the sheet past the Screen shot of excel:

Transcribed Image Text:

A 1 Employee Name 2 Adams, David 3 Adkins, Michael 4 Aguilar, Kevin 5 Alexander, Charles 6 Allen, Thomas 7 Allison, Timothy 8 Alvarado, Sonia 9 Alvarez, Steven 10 Anderson, Teason 11 Andrews, Diane 12 Andrews, James 13 Anthony, Robert 14 Armstrong, David 15 Arnold, Cole 16 Ashley, Michael 17 Atkins, Kevin 18 Atkinson, Danielle 19 Austin, William 20 Avila, Jody 21 Ayala, Polly 22 Ayers, Douglas 23 Bailey, Victor 24 Baker, Barney 25 Baldwin, Ray 26 Ball, Kirk 27 Ballard, Martin 28 Banks, Ryan 29 Barber, Robbie Barker, Heidi 31 Barnes, Grant 32 Barnett, Brenda 33 Barr, Jennifer B Building Department с D Operations Research Center Creative Accounting Status Full Time Full Time Full Time Contract Full Time Full Time Main Product Development North Accounting West Accounting West Operations Main Operations Main Creative Main IT Taft Accounting East Account Management Contract North Account Management North Accounting East IT North Quality Control North Sales Full Time North Account Management Full Time North Operations Hourly North Account Management Full Time Main Account Management Full Time Main Accounting Hourly Main Account Management Full Time Main East Taft East North Sales South IT Main IT North Operations West Account Management Main Accounting North Human Resources North Marketing Half-Time Contract Hourly Full Time Half-Time Contract Contract Full Time Contract Full Time Full Time Full Time Hourly Full Time Full Time Hourly Full Time Full Time E Hire Date 28-Apr-18 25-Oct-12 11-Dec-04 18-Apr-13 13-Jun-14 15-Jun-13 31-May-14 3-Oct-14 15-Apr-07 5-Feb-07 9-Sep-17 2-Feb-17 21-Dec-17 3-Sep-13 24-Apr-17 22-Jul-15 29-May-05 19-Dec-04 24-May-19 7-Sep-17 26-Apr-17 21-Aug-14 7-Jan-10 9-Jun-14 30-Jul-18 30-Jul-13 25-Jan-06 26-Sep-04 29-Oct-17 2-Nov-13 15-Apr-10 16-Oct-17 F Years 2 8 16 7 6 7 6 6 13 13 3 3 2 7 3 5 15 15 1 3 3 6 10 6 2 7 $6 14 16 7 10 3 G Benefits D R R DMR M DM DMR DMR 3 D M DM DMR DMR R R DM DMR M DMR D H Salary 49,260 55,840 39,000 74,500 119,730 82,500 35,045 89,450 71,300 26,688 49,570 26,925 45,030 22,860 63,206 18,904 23,560 62,688 33,508 43,320 52,940 42,800 80,050 48,250 87,980 87,030 21,648 37,760 29,760 12,836 47,350 49,770 A 1 Employee Name 2 Adams, David 3 Adkins, Michael 4 Aguilar, Kevin 5 Alexander, Charles 6 Allen, Thomas 7 Allison, Timothy 8 Alvarado, Sonia 9 Alvarez, Steven 10 Anderson, Teason 11 Andrews, Diane 12 Andrews, James 13 Anthony, Robert 14 Armstrong, David 15 Arnold, Cole 16 Ashley, Michael 17 Atkins, Kevin 18 Atkinson, Danielle 19 Austin, William 20 Avila, Jody 21 Ayala, Polly 22 Ayers, Douglas 23 Bailey, Victor 24 Baker, Barney 25 Baldwin, Ray 26 Ball, Kirk 27 Ballard, Martin 28 Banks, Ryan 29 Barber, Robbie Barker, Heidi 31 Barnes, Grant 32 Barnett, Brenda 33 Barr, Jennifer B Building Department с D Operations Research Center Creative Accounting Status Full Time Full Time Full Time Contract Full Time Full Time Main Product Development North Accounting West Accounting West Operations Main Operations Main Creative Main IT Taft Accounting East Account Management Contract North Account Management North Accounting East IT North Quality Control North Sales Full Time North Account Management Full Time North Operations Hourly North Account Management Full Time Main Account Management Full Time Main Accounting Hourly Main Account Management Full Time Main East Taft East North Sales South IT Main IT North Operations West Account Management Main Accounting North Human Resources North Marketing Half-Time Contract Hourly Full Time Half-Time Contract Contract Full Time Contract Full Time Full Time Full Time Hourly Full Time Full Time Hourly Full Time Full Time E Hire Date 28-Apr-18 25-Oct-12 11-Dec-04 18-Apr-13 13-Jun-14 15-Jun-13 31-May-14 3-Oct-14 15-Apr-07 5-Feb-07 9-Sep-17 2-Feb-17 21-Dec-17 3-Sep-13 24-Apr-17 22-Jul-15 29-May-05 19-Dec-04 24-May-19 7-Sep-17 26-Apr-17 21-Aug-14 7-Jan-10 9-Jun-14 30-Jul-18 30-Jul-13 25-Jan-06 26-Sep-04 29-Oct-17 2-Nov-13 15-Apr-10 16-Oct-17 F Years 2 8 16 7 6 7 6 6 13 13 3 3 2 7 3 5 15 15 1 3 3 6 10 6 2 7 $6 14 16 7 10 3 G Benefits D R R DMR M DM DMR DMR 3 D M DM DMR DMR R R DM DMR M DMR D H Salary 49,260 55,840 39,000 74,500 119,730 82,500 35,045 89,450 71,300 26,688 49,570 26,925 45,030 22,860 63,206 18,904 23,560 62,688 33,508 43,320 52,940 42,800 80,050 48,250 87,980 87,030 21,648 37,760 29,760 12,836 47,350 49,770

Answer rating: 100% (QA)

The Salaries dataset contains 10 variables Heres how you can count the variables in Excel even if th... View the full answer