Create a Pivot table that tabulates the number of employees by department & gender. Name the...
Create a Pivot table that tabulates the number of employees by department & gender. Name the worksheet for this "Employees by DeptGender". HINT: What data element do you need to COUNT in order to generate this pivot table? It would obviously have to be a data element whose value was different (unique, like a database table key) for every row in the table in order to insure an appropriate tabulation of employees by department). I would appreciate if the steps could be shown, thank you!
Homework Answers
Let us assume below table with entries as:
Now, Select entire entire sheet and GO to Insert Tab -> Pivot Table -> click Pivot Table
Below will pop up:
Now select as below:
Department in Row Label
Gender in Column Label
Employee in Summation Values
The table will be formed as:
Finally, from row label and colum label, deselect the blank tab to give final output
Add Answer to:
Create a Pivot table that tabulates the number of employees by
department & gender. Name the...
For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named ge...
For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named getSalesSortedByNames. Your function will have 2 parameters. The first parameter is a database cursor and the second parameter is a float. Your function should start by retrieving those rows in the staff table whose totalsales field is equal to the second parameter. (The next paragraph shows the Python...
DROP TABLE EMPLOYEE; DROP TABLE JOB; DROP TABLE EMP; DROP TABLE EMP_1; DROP TABLE EMP_2; CREATE...
DROP TABLE EMPLOYEE;
DROP TABLE JOB;
DROP TABLE EMP;
DROP TABLE EMP_1;
DROP TABLE EMP_2;
CREATE TABLE JOB(JOB_CODE CHAR (3) PRIMARY KEY, JOB_DESCRIPTION
VARCHAR (20) NOT NULL,JOB_CHG_HOUR NUMBER (5,2) NOT
NULL,JOB_LAST_UPDATE DATE NOT NULL);
INSERT INTO JOB
VALUES('500','Programmer','35.75','20-Nov-2017');
INSERT INTO JOB VALUES('501','System
Analyst','96.75','20-Nov-2017');
INSERT INTO JOB VALUES('502','Database
Designer','125.00','24-Mar-2018');
CREATE TABLE EMPLOYEE(EMP_NUM CHAR (3) PRIMARY KEY,EMP_LNAME
VARCHAR (15) NOT NULL,EMP_FNAME VARCHAR (15) NOT NULL, EMP_INITIAL
CHAR (1),EMP_HIREDATE DATE NOT NULL,JOB_CODE CHAR (3), EMP_YEARS
NUMBER (2),FOREIGN KEY (JOB_CODE) REFERENCES JOB (JOB_CODE));
INSERT...
drop table department cascade constraints; create table department ( Dname varchar2(15) not null, Dnumber int not...
drop table department cascade constraints;
create table department (
Dname varchar2(15) not null,
Dnumber int not null,
Mgr_ssn char(9) not null,
mgr_start_date Date,
primary key (Dnumber),
Unique (Dname));
insert into DEPARTMENT values ('Research', '5', '333445555',
'22-May-1988');
insert into DEPARTMENT values ('Administration', '4', '987654321',
'01-Jan-1995');
insert into DEPARTMENT values ('Headquarters', '1', '888665555',
'19-Jun-1981');
drop table employee cascade constraints;
create table employee (
Fname varchar2(15) not null,
Minit char(1),
Lname varchar2(15) not null,
Ssn char(9),
Bdate date,
Address varchar2(30),
Sex char(1),...
database and sql problme THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED...
database and sql problme
THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED BELOW CREATE TABLE Department ( DECIMAL(5) VARCHAR(30) CHAR(5) DATE NOT NULL NOT NULL NOT NULL * Department number /*Department name * Department manager number */ /Manager start date DNumber DName Manager MSDate CONSTRAINT Department_PK PRIMARY KEY(DNumber) CONSTRAINT Department_CK UNIQUE(DName) CREATE TABLE DeptLocation DECIMAL(5) VARCHAR(50) NOT NULL NOT NULL DNumber * Department number */ * Department location */ Address CONSTRAINT DeptLocation_PK PRIMARY KEY(DNumber, Address) CONSTRAINT...
Create a procedure to update the sales history table following the requirements below. A table creation...
Create a procedure to update the sales history table following the requirements below. A table creation script is provided below. a) Call the procedure: UPDATE_SALES_HISTORY (The procedure name is important for our scripts to test and grade your code; please do not rename it (otherwise our scripts will not run and your score will be 0). b) The procedure takes 2 parameters: (4-digit-year, 2-digit-month). Both parameters will be numeric, e.g., (2019, 11) will denote 2019 (year) and November (month). The...
14. An advantage to a database is that it _____. a. Reduces redundancy b. Controls the data stored in it d. Establishes...
14. An advantage to a database is that it _____. a. Reduces redundancy b. Controls the data stored in it d. Establishes data sets 15. A primary key in a table: a. Must be unique for each row in the table b. Must be numeric c. Should not be used to join tables together d. Is a constant data element across all rows 16. Which of the following variables is nominal? a. Patient gender b. Length of stay c. Severity...
After creating the table and inserting the information below, please Write SQL commands that find the...
After creating the table and inserting the information below, please Write SQL commands that find the following: a. Count the total number of records in the table.b. How many unique JOBROLE are there in the dataset. Order them by alphabetical order from A to Z. c. Find EMPLOYEENUMBER, EDUCATIONFIELD, JOBROLE for all the employees whose AGE is greater than 50 and ATTRITION is YES CREATE TABLE EMPLOYEEATTRITION ( AGE INT, ATTRITION VARCAHR2(20), BUSINESSTRAVEL VARCAHR2(20), DAILYRATE INT, DEPARTMENT VARCAHR2(20), DISTANCEFROMHOME VARCAHR2(20),...
How to write the insert, search, and remove functions for this hash table program? I'm stuck......
How to write the insert, search, and remove functions for this hash table program? I'm stuck... This program is written in C++ Hash Tables Hash Table Header File Copy and paste the following code into a header file named HashTable.h Please do not alter this file in any way or you may not receive credit for this lab For this lab, you will implement each of the hash table functions whose prototypes are in HashTable.h. Write these functions in a...
PLEASE HELP!!!! 1) CONDITIONAL FORMATTING - Add conditional formatting to the Hours Worked field ...
PLEASE HELP!!!!
1) CONDITIONAL FORMATTING - Add conditional formatting to the
Hours Worked field data so that any hours worked greater
than 8 will show in white font with a dark fill.
2) DATABASE FUNCTION - Create a database function in cell E5
that calculates the average hours worked by males in Dept. No. 2.
If criteria are needed, start in cell E1.
3) VLOOKUP - In the Department field (column D) use the
VLOOKUP function to place the appropriate...
4. If a survey question asks an open-ended question what type of data is collected? a. Quantitative b. Ratio c. Interval...
4. If a survey question asks an open-ended question what type of data is collected? a. Quantitative b. Ratio c. Interval d. Qualitative 5. What data quality characteristic ensures that data supports the reason for the collection of the data? a. Precision b. Currency c. Constancy d. Definition 6. HCUP is a family of databases maintained by: a. CMS b. HHS c. AHRQ d. CDC 7. The fact that there is missing data would be identified in _____. a. Data...
For this problem, assume salesperson data are stored in a database table named staff. Also assume the columns in the table are named name, carsSold, and totalSales Write a Python function named getSalesSortedByNames. Your function will have 2 parameters. The first parameter is a database cursor and the second parameter is a float. Your function should start by retrieving those rows in the staff table whose totalsales field is equal to the second parameter. (The next paragraph shows the Python...
DROP TABLE EMPLOYEE;
DROP TABLE JOB;
DROP TABLE EMP;
DROP TABLE EMP_1;
DROP TABLE EMP_2;
CREATE TABLE JOB(JOB_CODE CHAR (3) PRIMARY KEY, JOB_DESCRIPTION
VARCHAR (20) NOT NULL,JOB_CHG_HOUR NUMBER (5,2) NOT
NULL,JOB_LAST_UPDATE DATE NOT NULL);
INSERT INTO JOB
VALUES('500','Programmer','35.75','20-Nov-2017');
INSERT INTO JOB VALUES('501','System
Analyst','96.75','20-Nov-2017');
INSERT INTO JOB VALUES('502','Database
Designer','125.00','24-Mar-2018');
CREATE TABLE EMPLOYEE(EMP_NUM CHAR (3) PRIMARY KEY,EMP_LNAME
VARCHAR (15) NOT NULL,EMP_FNAME VARCHAR (15) NOT NULL, EMP_INITIAL
CHAR (1),EMP_HIREDATE DATE NOT NULL,JOB_CODE CHAR (3), EMP_YEARS
NUMBER (2),FOREIGN KEY (JOB_CODE) REFERENCES JOB (JOB_CODE));
INSERT...
drop table department cascade constraints;
create table department (
Dname varchar2(15) not null,
Dnumber int not null,
Mgr_ssn char(9) not null,
mgr_start_date Date,
primary key (Dnumber),
Unique (Dname));
insert into DEPARTMENT values ('Research', '5', '333445555',
'22-May-1988');
insert into DEPARTMENT values ('Administration', '4', '987654321',
'01-Jan-1995');
insert into DEPARTMENT values ('Headquarters', '1', '888665555',
'19-Jun-1981');
drop table employee cascade constraints;
create table employee (
Fname varchar2(15) not null,
Minit char(1),
Lname varchar2(15) not null,
Ssn char(9),
Bdate date,
Address varchar2(30),
Sex char(1),...
database and sql problme
THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED BELOW CREATE TABLE Department ( DECIMAL(5) VARCHAR(30) CHAR(5) DATE NOT NULL NOT NULL NOT NULL * Department number /*Department name * Department manager number */ /Manager start date DNumber DName Manager MSDate CONSTRAINT Department_PK PRIMARY KEY(DNumber) CONSTRAINT Department_CK UNIQUE(DName) CREATE TABLE DeptLocation DECIMAL(5) VARCHAR(50) NOT NULL NOT NULL DNumber * Department number */ * Department location */ Address CONSTRAINT DeptLocation_PK PRIMARY KEY(DNumber, Address) CONSTRAINT...
PLEASE HELP!!!!
1) CONDITIONAL FORMATTING - Add conditional formatting to the
Hours Worked field data so that any hours worked greater
than 8 will show in white font with a dark fill.
2) DATABASE FUNCTION - Create a database function in cell E5
that calculates the average hours worked by males in Dept. No. 2.
If criteria are needed, start in cell E1.
3) VLOOKUP - In the Department field (column D) use the
VLOOKUP function to place the appropriate...
Most questions answered within 3 hours.
-
Calculate whether loci A&B are in linkage disequilibrium
(D) using the following data. Is the haplotype...
asked 6 minutes ago -
Barrington Box Enterprises has two divisions, large and small,
that share the common costs of the...
asked 9 minutes ago -
An integer number is said to be a perfect number if it is equal
to the...
asked 21 minutes ago -
What does economies of scale often fail to measure? How would
you recommend addressing this limitation?
asked 20 minutes ago -
Joanne Quick made an investment of $18,787.14. From this
investment, she will receive $2,000 annually for...
asked 28 minutes ago -
Enter your answer in the provided box. The solubility of CO2 in
water at 25°C and...
asked 34 minutes ago -
Amazon as with other ecommerce retailers struggle with cross
border solutions and continue to be country...
asked 33 minutes ago -
A second baseman tosses the ball to the first baseman, who
catches it at the same...
asked 50 minutes ago -
An object rests flat on a tablecloth, which is on top of a
table. Suppose you...
asked 50 minutes ago -
Which of the following will most likely occur as the result of
an unanticipated increase in...
asked 47 minutes ago -
Adria Lopez, owner of Success Systems, decides to prepare a
statement of cash flows for her...
asked 1 hour ago -
The reach and involvement of the federal government, in terms of
its role in disaster relief,...
asked 1 hour ago