1) Choose six different tests and write six different questions

one-sample t, paired samples t, independent t, one-way ANOVA, Factorial ANOVA, repeated measures ANOVA, regression, correlation, or chi-square.

2) For each question, choose a different test, and write up a research scenario in which you describe the research question and some details of the study or experiment. The question that the reader has to answer is ‘which test is appropriate?’.

Example (using Z-tests):

A personality psychologist has decided to investigate claims that the younger generation of college students (born between 1995 and 2000) are different from previous generations on the dimension of narcissism. She surveyed 150 college students born between 1995 and 2000 and compared their average level of narcissism (M = 4.3, SD = .3) to that of the previous generation (? = 4.2, ? = .1). What statistical test would be appropriate to conduct in this situation?

A. paired samples t

B. z-test

C. one-way ANOVA

D. Correlation

3) across the questions, please use at least one example from developmental, cognitive, social, or clinical psychology (you can have some repeat areas)

A) DDL

For Company DB Schema, Answer the below questions:

Emp (Empno, Ename, Job, Hiredate, Sal, Comm, Deptno)

Dept (Deptno, Dname, loc)

1. Retrieve the data of all employees.

2. Retrieve the data of all Salemanemployees.

3. Retrieve the name and Salary of all employees.

4. Retrieve the name and salary of Salemanemployees.

5. Retrieve the name and salary of all employees with Salary more than 2000.

6. Retrieve the Name and Salary of all employees who work in department no 20.

7. Retrieve the name and Job of all employees with Salary more than 2000 and hiredate after 01-01-1981.

8. Retrieve the Job and Salary of all employees with Name = FORD or MARTIN.

9. Retrieve the Name and Number of all Departments.

10. Retrieve the Employee Name and Department number for all employees.

11. Retrieve the Employee Name and Department name for all employees.

12. Retrieve the Employee Name and who works in Department name = RESEARCH.

13. Retrieve the Employee names who workin one of these Departments: RESEARCHand SALES.

14. Retrieve the Employee name who works in department located in NEW YORK.

please write in computer word not on paper

A screening program for neuroblastoma (a type of cancer) was undertaken in Germany among children born between November 1, 1993, and June 30, 2000, who were between 9 and 18 months of age between May 1995 and April 2000. A total of 1,475,773 children participated in the screening program. Of whom 204 were diagnosed between 12 and 60 months of age. The researchers expected the incidence rate of neuroblastoma to be 7.3 per 100,000 children during this period in the absence of screening. We wish to test if the number of cases detected by the screening program is significantly greater than expected.

a) Write hypotheses to test this claim. Explain why you should use a one sided alternative.

b) You may assume any necessary conditions have been met. Perform your test.

c) Do you think that the number of cases detected by the screening program is significantly greater than expected? Explain.

d) Give a 95% confidence interval for the incidence rate of neuroblastoma in the screened population.

e) Express your confidence interval from part d) as (p1, p2), where p1 and p2 are in the units of number of cases per 100,000 children.

specifically need help with question e

The town of Cypress Creek is preparing to go to war against the American government. To do this, it is building a giant satellite laser! To build the laser, the government of the town will resort to taxation to fund its expenditure. The initial economy of Cypress Creek can be expressed by the following agents:

Consumers, C = 25 + 0.95(Y-T)

Output, Y = 5000

Government expenditures, G = 2000

Taxation, T = 2000

Investors, I = 750-125r

Markets are fully competitive and the equilibrium condition for markets are:

Goods and service market: Y =C + I + G

Financial market: I = S

When it builds the Satellite, government and taxation change to

Government expenditures, G = 4000

Taxation, T = 4000

Hank Scorpio makes another announcement "People of North Haverbrook! We must all work together in this to crush the American Government - I implore you to save you wages! Don't spend!"

m) [2 points] by how much would consumers need to reduce their Marginal propensity to consume

(MPC) such that the market clearing interest rate does not change?

n) [2 points] Who will end up paying the burden of this project? (consumers or investors? And by

how much?)

Consider the following database schema:

LIKE(person, sport),

PRACTICE(person, sport),

where person and sport are keys in both tables. The table LIKE gives the sports a person likes, the table PRACTICE gives the sports a person practices. We assume that a person likes at least one sport and practices at least one sport. We assume also that a person does not like a sport if the sport is not listed among the sports that person likes

Express the following queries in mySQL preferred

1. List the people who practice at least one sport they do not like

2. List the people who like all the sports they practice

(DO NOT COPY ANSWER FROM PREVIOUS QUESTION LIKE THIS THEY ARE NOT WORKING/WRONG)

Consider the following database schema:

LIKE(person, sport),

PRACTICE(person, sport),

where person and sport are keys in both tables. The table LIKE gives the sports a person likes, the table PRACTICE gives the sports a person practices. We assume that a person likes at least one sport and practices at least one sport. We assume also that a person does not like a sport if the sport is not listed among the sports that a person likes


Express the following queries in Calculus

List the people who practice at list one sport they like
List the people who practice at least one sport they do not like
List pairs of people who practice at least one common sport
List the people who like all the sports they practice
List the people who practice all the sports they like
List the people who practice all the sports John likes

Consider the following database schema:

LIKE(person, sport),

PRACTICE(person, sport),

where person and sport are keys in both tables. The table LIKE gives the sports a person likes, the table PRACTICE gives the sports a person practices. We assume that a person likes at least one sport and practices at least one sport. We assume also that a person does not like a sport if the sport is not listed among the sports that person likes.

Express the following queries in relational algebra

1. List the people who practice at list one sport they like
2. List the people who practice at least one sport they do not like
3. List pairs of people who practice at least one common sport
4. List the people who like all the sports they practice
5. List the people who practice all the sports they
6. List the people who practice all the sports John

Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database​ information, he has determined the daily requirements for​ part-time loading dock personnel. The distribution center operates 7 days a​ week, and the daily​ part-time staffing requirements are                                                                                                                      Day M T W Th F S Su Requirements 5 5 3 3 7 2 4 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the​ S-Su pair in case of a tie. ​(Note: If there is a tie that cannot be broken by following the preference to the​ S-Su pair, choose the pair closest to the beginning of the considered​ week.) The minimum number of workers is 7 workers. ​(Enter your response as a whole​ number.) Specify the workforce schedule for each employee by indicating the day offs​ (other days are considered to be work​ days.) Make sure to give preference to the​ S-Su pair in case of a tie. ​(Note: If there is a tie that cannot be broken by following the preference to the​ S-Su pair, choose the pair closest to the beginning of the considered​ week, with Monday being considered as the first day of the​ week.)

Consider the following database schema:

LIKE(person, sport),

PRACTICE(person, sport),

where person and sport are keys in both tables. The table LIKE gives the sports a person likes, the table PRACTICE gives the sports a person practices. We assume that a person likes at least one sport and practices at least one sport. We assume also that a person does not like a sport if the sport is not listed among the sports that person likes

1. List the people who practice at least one sport they do not like
2. List pairs of people who practice at least one common sport
3. List the people who like all the sports they practice
4. List the people who practice all the sports they like
5. List the people who practice all the sports John likes
6. Who practices the largest number of sport (SQL only)?

PROBLEM 3: Given the following relational database table: Patients(ID, name, symptom, days_in_hospital) The following insertions are performed on the table Patients: Insert record <20, Johnson, cough, 3> Insert record <10, Black, fever, 5> Insert record <30, Miller, fever, 10> Insert record <70, Brown, fatigue, 2> Insert record <60, Grant, headache, 4> Insert record <50, Miller, nausea, 15> Insert record <90, Brown, cough, 8 > Assume each block in the Patients file can store up to 2 patient records. Do the following: 1. Assuming that Patients is organized as a heap file, show the contents of the file after the last insertion. 2. Assuming that Patients is organized as a sequential file with days_in_hospital as the ordering field, show the contents (i.e. the data values as well as the associated block/bucket/record addresses) of the file after the last insertion. 3. Assuming that Patients is organized as an index-sequential file on the search key days_in_hospital and assuming that the primary index, the secondary index on ID, and the secondary index on name have been created, show the contents of Patients, the primary index, and the two secondary indices after the last insertion. 4. Given the index-sequential file organization as described in (3), explain step-by-step how the DBMS would conduct search on this file organization to answer the following SQL query: select name from Patients where ID between 30 and 60