You would like to study the height of students at your university. Suppose the average for all university students is 67 inches with a SD of 18 inches, and that you take a sample of 19 students from your university.

a) What is the probability that the sample has a mean of 61 or less inches?
probability =  

b) What is the probability that the sample has a mean between 68 and 71 inches?
probability =  

Note: Do NOT input probability responses as percentages; e.g., do NOT input 0.9194 as 91.94.

A. Project 1 case: DDL’s and Business Rules - The SQL queries for this project are based on the business rules from PROJECT 1. Thus, the SQL queries will run against the tables from Project 1 (see section B below). The following is a list of the business rules derived from the Project 1 assignment:

- A university is identified by its name and located in a particular city.

- A university has many researchers, each of whom can only be associated with only one university.

- A researcher is identified by an identification number, and has a name, phone, and email address.

- A researcher can attend many conferences.

- A conference is identified by an identification number; it also has a name, a location, and a date.

- For each conference, a researcher may or may not present a scientific research paper.

- For each conference, one university is in-charge of its logistic, while another university is in-charge of its marketing.

- A university can be involved in either role with any conference.

B. Run the following DDL’s and add your own data rows to the tables

CREATE TABLE `university` (

`UNIVERSITY_ID` int(11) NOT NULL,

`UNIVERSITY_NAME` varchar(45) DEFAULT NULL,

`UNIVERSITY_CITY` varchar(45) DEFAULT NULL,

`UNIVERSITY_STATE` varchar(2) DEFAULT NULL,

PRIMARY KEY (`UNIVERSITY_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `conference` (

`CONFERENCE_ID` int(11) NOT NULL,

`CONFERENCE_NAME` varchar(45) DEFAULT NULL,

`CONFERENCE_CITY` varchar(45) DEFAULT NULL,

`CONFERENCE_DATE` date DEFAULT NULL,

`UNIVERSITY_ID_LOGISTICS` int(11) NOT NULL,

`UNIVERSITY_ID_MARKETING` int(11) NOT NULL,

`CONFERENCE_STATE` varchar(2) DEFAULT NULL,

PRIMARY KEY (`CONFERENCE_ID`,`UNIVERSITY_ID_LOGISTICS`,`UNIVERSITY_ID_MARKETING`),

KEY `fk_CONFERENCE_UNIVERSITY1_idx` (`UNIVERSITY_ID_LOGISTICS`),

KEY `fk_CONFERENCE_UNIVERSITY2_idx` (`UNIVERSITY_ID_MARKETING`),

CONSTRAINT `fk_CONFERENCE_UNIVERSITY1` FOREIGN KEY (`UNIVERSITY_ID_LOGISTICS`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `fk_CONFERENCE_UNIVERSITY2` FOREIGN KEY (`UNIVERSITY_ID_MARKETING`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `researcher` (

`researcher_id` int(11) NOT NULL,

`res_lname` varchar(45) DEFAULT NULL,

`res_fname` varchar(45) DEFAULT NULL,

`res_title` varchar(45) DEFAULT NULL,

`university_UNIVERSITY_ID` int(11) NOT NULL,

PRIMARY KEY (`researcher_id`,`university_UNIVERSITY_ID`),

KEY `fk_researcher_university1_idx` (`university_UNIVERSITY_ID`),

CONSTRAINT `fk_researcher_university1` FOREIGN KEY (`university_UNIVERSITY_ID`) REFERENCES `university` (`UNIVERSITY_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `conference_has_researcher` (

`CONFERENCE_CONFERENCE_ID` int(11) NOT NULL,

`RESEARCHER_RESEARCHER_ID` int(11) NOT NULL,

PRIMARY KEY (`CONFERENCE_CONFERENCE_ID`,`RESEARCHER_RESEARCHER_ID`),

KEY `fk_CONFERENCE_has_RESEARCHER_RESEARCHER1_idx` (`RESEARCHER_RESEARCHER_ID`),

KEY `fk_CONFERENCE_has_RESEARCHER_CONFERENCE_idx` (`CONFERENCE_CONFERENCE_ID`),

CONSTRAINT `fk_CONFERENCE_has_RESEARCHER_CONFERENCE` FOREIGN KEY (`CONFERENCE_CONFERENCE_ID`) REFERENCES `conference` (`CONFERENCE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `fk_CONFERENCE_has_RESEARCHER_RESEARCHER1` FOREIGN KEY (`RESEARCHER_RESEARCHER_ID`) REFERENCES `researcher` (`researcher_id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

C. Data Queries   “Good questions to ask of your data” – The business rules from section A above were used to derive the following 10 query descriptions below. Read each description and write the equivalent SQL query.

1. List the universities sorted by city.

2. List the Researchers sorted by last name.

3. List the researchers and their corresponding universities sorted by the university city. You must use an INNER JOIN with RESEARCHER and UNIVERSITY tables.

4. List the university and “count” of researchers at each university sorted by the university name.

You CANNOT use an inner join. You must use a subquery with RESEARCHER.

5. List the university and “count” of researchers at each university where there is more than 1 researcher. Also, sort this query by the university name. You must user an INNER JOIN (NOT A SUBQUERY)

6. List all conferences in the state of georgia. Include the city and state with the query.

7. List the conference and researcher count for conferences in georgia. You CANNOT use an inner join. You must use “two” subqueries that are nested.

8. List the researcher, university and conferences where the conference is in California. You must user an INNER JOIN (NOT A SUBQUERY).

9. List the university and count of researchers that are planning to present at a conference in 2021. You CANNOT use an inner join. You must use a subquery.

10. List the Universities in the database table. If the university appears in a conference that is in charge of its marketing. Each university can only be listed once. You must user an OUTER JOIN (NO INNER JOIN OR SUBQUERY).

I have part A completed. I am stuck on part C mostly, but help on part B would be greatly appreciated.

1. There are two career fairs held at a Catholic Chicago University.

1. Fill in the not-hired counts for each fair.

2. Do the samples meet the Success-Failure Conditions?

3. What are the proportions of hired students for each fair?

4. What are the individual standard errors for hired students?

5. What is the difference of proportions of hired students between the two fairs?

6. What is the joint standard error of the two fairs?

7. What is the z-score associated with 90 confidence interval?

8. Compute the confidence interval for this difference of proportions.

1. Which fair should a student attend?

The scores of high school seniors on the ACT college entrance examination in a recent year had mean μ = 20.8 and standard deviation σ = 4.8. The distribution of scores is only roughly Normal.

(a) What is the approximate probability that a single student randomly chosen from all those taking the test scores 21 or higher? (Round your answer to four decimal places.)


(b) Now take an SRS of 25 students who took the test. What are the mean and standard deviation of the sample mean score x of these 25 students? (Round your answers to two decimal places.)

(c) What is the approximate probability that the mean score

x

of these students is 21 or higher? (Round your answer to four decimal places.)


(d) Which of your two Normal probability calculations in (a) and (c) is more accurate? Why?

The answer to (a) is more accurate because an individual score should have a distribution farther from Normal.The answer to (a) is more accurate because an individual score should have a distribution that is exactly Normal.    The answer to (a) is more accurate because an individual score should have a distribution closer to Normal.The answer to (c) is more accurate because x should have a distribution closer to Normal.The answer to (c) is more accurate because x should have a distribution that is farther from Normal.

THESE ARE MY IT AUDIT QUESTIONS CAN YOU SOLVE THEM IN DETAILS PLEASE...

1. Mr. John Doe is an IT auditor who works for DUMMY Auditing firm. JANE BANK is a financial company. Mr. Doe audits JANE BANK’s IT system. What type of audit does Mr. Doe conduct? Why?

2. During an IT audit, auditor audits a series of “CONTROLS” and wants to be sure that controls are in place and effectively implemented. Assume that, as an auditor, you are auditing the media transportation, storage, reuse and disposal. Company makes backups using backup tapes. Forthe backup activity, list and briefly explain three issues you can address in your audit.

3. In a typical IT risk calculation we multiply the value of threat probability by value of impact. For the data center of Kadir Has University, take one possible threat of your choice and the associated impact. Estimate the information security risk.

1) If a company wants to implement an enterprise application, it had better do its homework. Discuss 3 implications of this statement with examples.

2) Many colleges and universities use Banner, a higher education software ERP system. Describe the ERP system at your university. How does your school's ERP compare to others, give 2 comparisons to other systems from Web searches? What are the challenges of implementing the ERP system?

2. Identify the type of sampling used: self-response, random, systematic, convenience,

stratified, or cluster.

a. DTE survey 20 households in every city in

the County to learn about the costumer

satisfying level.

b. A sample consists of students with even

number Student’s ID.

c. A market researcher selects 100 people

from each state in the USA.

d. A pollster uses a computer to generate 500

random numbers, then interviews the voters

corresponding to those numbers.

e. To check the alcohol level of drivers,

police officers stopped every seventh car

passing through a side street near a

famous bar.

f. A University committee wants to know the

percentage of students who drive and text.

They survey all students majoring in History

and English.

g. A restaurant decided to give free

dessert for every 50th costumer dining

there.

h. A reporter writes the name of each US

senator on a separate card, shuffles the

cards, and then draws five names.

i. There are 4 bags of M&M in a box. One

consists of blue M&M, another bag has

red only M&M, the other two consists of

chocolate and yellow M&M respectively.

Lisa takes out 5 M&M from each bag to

create a sample of M&M.

j. A researcher conducts a survey by asking

100 randomly selected workers from each

category: no high school degree, high school

degree, more than high school degree.

k. A researcher wants to determine the

percentage of first grader still believe in

Santa Claus. He uses the first graders in

his son’s school as his sample.

l. A polling on Twitter asks its follower to rank

the work ethic of the congress from 1 to 5,

with 1 as the lowest and 5 as the highest

Provide the current Valuation Ratios for the company United Parcel Service (UPS) and explain what they mean and what the number tells us. Also, why is this ratio important to the company? Compare these ratios to the industry financial ratios. Lastly, look at trends within United Parcel Service (UPS) company over time and explain if they are doing better, worse or holding steady, and how is the company doing and where can the company perform better?  

Please cite where the information comes from.