1. For the table below, fill in the missing sections for the Mean, Median, Mode, Range, and Standard Deviation on your own. Remember to round to two decimal places.

Hint: Put it in SPSS to simplify the calculation of the standard deviation, using the “Means” test under the Analyze menu!

Then complete the five questions and transfer your answers to the quiz in Canvas

Condition 1 Scores Condition 2 Scores

4, 1, 2, 4, 2, 3, 7, 4, 3, 5, 8, 3 4, 4, 5, 3, 3, 2, 3, 6, 4, 7, 8, 10

Column Mean

Column Median

Column Mode

Standard Deviation

Column Range

1. The correct mean for Condition One is _______ while the correct mean for Condition Two is ______:

A. 4.92 and 3.83

B. 5.17 and 3.42

C. 3.50 and 4.00

D. 3.83 and 4.92

E. 2.04 and 2.39

2. The correct standard deviation for Condition One is ________ while the correct standard deviation for

Condition Two is _______

A. 4.92 and 3.83

B. 5.17 and 3.42

C. 3.50 and 4.00

D. 3.83 and 4.92

E. 2.04 and 2.39

3. Which of the following is true about the mode?

A. Condition One has one mode while Condition Two has two modes

B. Condition Two has one mode while Condition One has two modes

C. The mode(s) for Conditions One and Two are different

D. The mode(s) for Conditions One and Two are the same

4. What is the best interpretation for this t-Test?

A. It was significant,

t

(21.46) = 1.19,

p

< .05

B. It was significant,

t

(22) = 1.19,

p

< .05

C. It was significant,

t

(22) = 0.56,

p

< .001

D. It was not significant,

t

(21.46) = 1.19,

p

> .05

E. It was not significant,

t

(22) = 1.19,

p

> .05

5. Use the Independent Samples Test table as well as your findings for the mean and SDs (from question

#1) to determine which of the following is

t

-Test write-ups correct:

A. We ran an independent samples

t

-Test with score as the dependent variable and condition (1

versus 2) as the independent variable, which was significant,

t

(21.46) = 1.19,

p

< .05. Scores

were higher in condition 1 (

M

= 3.83,

SD

= 2.04) than in condition 2 (

M

= 4.92,

SD

= 2.39).

B. We ran an independent samples

t

-Test with score as the dependent variable and condition (1

versus 2) as the independent variable, which was significant,

t

(22) = 1.19,

p

< .05. Scores were

higher in condition 1 (

M

= 4.92,

SD

= 2.39) than in condition 2 (

M

= 3.83,

SD

= 2.04).

C. We ran an independent samples

t

-Test with score as the dependent variable and condition (1

versus 2) as the independent variable, which was significant,

t

(22) = 1.19,

p

< .05. Scores were

higher in condition 1 (

M

= 3.83,

SD

= 2.04) than in condition 2 (

M

= 4.92,

SD

= 2.39).

D. We ran an independent samples

t

-Test with score as the dependent variable and condition (1

versus 2) as the independent variable, which was not significant,

t

(21.46) = 0.56,

p

> .05. Scores

were higher in condition 1 (

M

= 3.83,

SD

= 2.04) than in condition 2 (

M

= 4.92,

SD

= 2.39).

E. We ran an independent samples

t

-Test with score as the dependent variable and condition (1

versus 2) as the independent variable, which was not significant,

t

(22) = 1.19,

p

> .05. Scores did

not differ significantly between condition 1 (

M

= 3.83,

SD

= 2.04) and condition 2 (

M

= 4.92,

SD

= 2.39).

Write CREATE TABLE and INSERT INTO statements in order to create and populate five tables in Oracle’s SQL*Plus.The information you need about the database ARE IN THE CHARTS BELOW.

Each worksheet includes the following information about its associated table:

➢ Column names (for example, the jr_order table contains the orderID, customerID, orderDate, orderStatus, and orderShippedDate columns);

➢ Column data types (for example, orderID is INT, orderStatus is VARCHAR2(2), etc.);

➢ Column constraints, if any (for example, orderID in the jr_order table is a primary key,

supplierName in the jr_supplier table is NOT NULL, etc.); and

➢ All values (i.e., the data).

Example INSERT code for each table

[Note that each of these INSERT INTO statements corresponds to the first row in its respective Excel worksheet!]

Example INSERT code for the xx_customer table

INSERT INTO jr_customer (

customerID, customerLastName, customerFirstName,

customerCity, customerState, customerZIP, customerEmail,

jr_customerPhoneNum ) VALUES (1,'Alexander','Michael',

'Highland Heights','KY','41076','[email protected]',NULL) ;

Example INSERT code for the xx_supplier table

INSERT INTO jr_supplier (

supplierID, supplierName, supplierCity, supplierState,

supplierContactName, supplierContactTitle, supplierContactEmail )

VALUES (1,'Reaper','Denton',’TX’,

'John Franklin','Product Marketing Manager','[email protected]') ;

Example INSERT code for the xx_order table

INSERT INTO jr_order (

orderID, customerID, orderDate, orderStatus, orderShippedDate )

VALUES (1,1,TO_DATE('2018-03-01','yyyy-mm-dd'),'SP',

TO_DATE('2018-03-04','yyyy-mm-dd') ) ;

Example INSERT code for the xx_product table

INSERT INTO jr_product (

productCode, supplierID, productName, suggestedPrice,

unitsInStock, unitsOnOrder, discontinued ) VALUES

('IM511',2,'Cloaked Assassin',4.95,4,1,'N') ;

Example INSERT code for the xx_orderLine table

INSERT INTO jr_orderLine (

orderLineID, orderID, productCode, quantity, unitPrice )

VALUES (1,1,'IM511',1,5.49) ;

MS EXCEL WORKBOOK INFO:

SUPPLIER:

customerID	customerLN	customerFN	customerCity	customerState	customerZIP	customerEmail	customerPhoneNum
INT	VARCHAR2(25)	VARCHAR2(20)	VARCHAR2(25)	VARCHAR2(2)	VARCHAR2(10)	VARCHAR2(25)	VARCHAR2(12)
PRIMARY KEY	NOT NULL					NOT NULL
1	Alexander	Michael	Highland Heights	KY	41706	[email protected]	NULL
2	Clark	Franklin	Amelia	OH	45102	[email protected]	513-293-4435
3	Philips	Trevor	Newtown	OH	45244	[email protected]	NULL
4	Butler	Ashley	Erlanger	KY	42017	[email protected]	859-563-8090
5	Landon	Frank	Reading	OH	45215	[email protected]	NULL
6	Herbert	Floyd	Cincinnati	OH	45211	[email protected]	NULL
7	McGee	Martin	Cincinnati	OH	45238	[email protected]	NULL

ORDER:

orderID	customerID	orderDate	orderStatus	orderShippedDate
INT	INT	DATE	VARCHAR2(2)	DATE
PRIMARY KEY	NOT NULL, foreign key	NOT NULL	NOT NULL
1	1	2018-03-01	SP	2018-03-04
2	2	2018-03-02	SP	2018-03-04
3	3	2018-03-03	SP	2018-03-05
4	4	2018-03-03	SP	2018-03-05
5	5	2018-03-05	SP	2018-03-07
6	6	2018-03-05	SP	2018-03-08
7	7	2018-03-08	SP	2018-03-10
16	2	2018-03-15	SP	2018-03-17
17	4	2018-03-16	SP	2018-03-19
20	7	2018-03-18	SP	2018-03-20
23	5	2018-03-20	SP	2018-03-22

PRODUCT:

productCode	supplierID	productName	suggestedPrice	unitsInStock	unitsOnOrder	discontinued
VARCHAR2(15)	INT	VARCHAR2(30)	NUMBER(5,2)	NUMBER(3)	NUMBER(3)	VARCHAR2(1)
PRIMARY KEY	NOT NULL, foreign key	NOT NULL
IM511	2	Cloaked Assassin	4.95	4	1	N
IM514	2	Hooded Female Thief	4.25	3	0	N
IM517	2	Cleric with Staff	4.95	5	2	N
IM519	2	Berserker	3.71	2	1	N
IM527	2	Grand Mystic	4.95	3	0	N
IM537	2	Hydra	29.95	3	0	Y
IM539	2	Umber Hulk	11.59	4	1	N
IM540	2	Wraith	5.25	6	2	N
IM556	2	Heroic Paladin	5.99	7	3	N
IM657	2	Two-Headed Troll	12.99	2	0	Y
R03495	1	Werewolf	9.99	3	0	Y
R03515	1	Dervish Warrior	4.99	4	2	N
R03527	1	Scourge Devil	11.99	1	2	N
R03581	1	Human Ranger	7.49	9	2	N
R03669	1	Dark Elf	7.99	8	0	N

OrderLine:

orderLineID	orderID	productCode	quantity	unitPrice
INT	INT	VARCHAR2(15)	NUMBER(3)	NUMBER(5,2)
PRIMARY KEY	NOT NULL, foreign key	NOT NULL, foreign key	NOT NULL	NOT NULL
1	1	IM511	1	5.49
2	1	R03495	1	10.99
3	2	IM514	1	4.99
4	3	IM517	1	4.99
5	4	R03515	1	5.99
6	5	R03669	1	8.99
7	6	IM657	1	12.99
9	7	R03527	1	11.99
8	7	R03581	2	7.49
19	16	IM527	1	4.95
18	16	IM537	1	34.95
20	16	IM540	1	5.99
21	17	IM556	1	6.99
27	20	IM519	1	4.19
31	23	IM539	1	12.49

1.Find an equation for the plane containing the two (parallel) lines v1 = (0, 1, −9) + t(4, 9, −3) and v2 = (9, −1, 0) + t(4, 9, −3).

2.Find a parametrization for the line perpendicular to (6, −1, 1),parallel to the plane 6x + y − 8z = 1,and passing through the point (1, 0, −7).(Use the parameter t. Enter your answers as a comma-separated list of equations.)

Random samples of female and male UVA undergraduates are asked to estimate the number of alcoholic drinks that each consumes on a typical weekend. The data is below:

Females (Population 1): 4, 5, 3, 6, 6, 4, 5, 3, 4, 2

Males (Population 2): 4, 6, 8, 4, 5, 6, 7, 6, 6, 7

Give a 95% confidence interval for the difference between mean female and male drink consumption. For each confidence interval, enter your answer in the form (LCL, UCL).

DEHS Data Set for Assessment Projects
INTD 5064 Applied Statistics for Health Care Practitioners
CI Subjects
Subject ID	Group	Gender	Mode of Communication	ESP-Pre	TL-Pre	AC-Pre	EC-Pre		ESP Post	CLS-Post	RLI-Post	ELI-Post	LCI-Post	LSI-Post	GF-Post
C01	1	1	1	1	86	89	95		3	95	96	99	90	88	101
C02	1	2	1	1	82	85	85		3	85	89	87	83	78	89
C03	1	1	1	1	85	78	80		3	90	92	88	88	84	85
C04	1	1	1	2	81	81	82		2	80	88	84	79	76	105
C05	1	2	1	1	92	95	100		4	100	100	95	98	104	82
C06	1	1	1	1	79	80	72		4	92	94	90	92	82	90
C07	1	1	1	1	78	80	74		3	84	88	79	86	80	80
C08	1	2	1	1	111	115	102		3	120	122	112	109	110	102
C09	1	1	1	2	87	89	79		4	88	92	87	87	82	82
C10	1	2	1	2	99	98	89		4	100	98	90	104	106	95
C11	1	1	1	1	67	69	68		3	79	84	82	70	78	77
C12	1	2	2	1	102	100	98		2	95	98	93	96	90	82
C13	1	1	2	1	74	74	70		2	70	72	70	71	68	74
C14	1	2	2	1	68	65	70		1	67	69	66	65	68	70
C15	1	1	2	1	95	90	101		2	90	92	88	85	95	87
C16	1	1	2	1	75	77	76		2	72	75	70	74	68	69
Non CI Subjects
Subject ID	Group	Gender	Mode of Communication	ESP-Pre	TL-Pre	AC-Pre	EC-Pre		ESP Post	CLS-Post	RLI-Post	ELI-Post	LCI-Post	LSI-Post	GF-Post
S01	2	2	2	1	95	89	100		2	93	89	85	100	92	82
S02	2	1	2	1	87	85	95		1	80	83	82	80	78	70
S03	2	2	2	2	76	78	80		1	78	72	70	77	80	65
S04	2	1	2	1	75	73	72		2	73	71	72	75	72	68
S05	2	1	2	1	79	78	80		1	80	70	72	85	81	63
S06	2	1	2	1	77	78	74		1	75	77	68	85	70	71
S07	2	1	2	1	78	80	72		2	72	75	70	72	69	60
S08	2	2	2	1	77	81	75		1	80	89	73	75	78	65
S09	2	1	2	1	87	88	84		1	80	84	80	75	80	68
S10	2	1	2	1	89	98	82		3	90	100	85	85	85	78
S11	2	2	2	1	90	94	92		1	85	90	82	79	87	72
S12	2	1	2	1	73	78	72		1	70	74	67	79	68	66
S13	2	2	2	1	74	74	75		1	70	72	69	67	75	67
S14	2	2	2	1	68	65	68		2	62	60	61	67	60	55
S15	2	1	2	1	75	74	72		1	71	77	67	75	71	70
S16	2	1	2	1	74	77	73		1	77	74	68	80	72	65

7. Trautwein and Ammerman are curious how the CI group compares to the norm on CLS at the end of the study.

a. What inferential test should the researchers use? Why?

b. What are the independent and dependent variables?

           

c. Using the A-B-C-D format used in class, answer Drs. Trautwein and Ammerman’s research question.

DEHS Data Set for Assessment Projects
INTD 5064 Applied Statistics for Health Care Practitioners
CI Subjects
Subject ID	Group	Gender	Mode of Communication	ESP-Pre	TL-Pre	AC-Pre	EC-Pre		ESP Post	CLS-Post	RLI-Post	ELI-Post	LCI-Post	LSI-Post	GF-Post
C01	1	1	1	1	86	89	95		3	95	96	99	90	88	101
C02	1	2	1	1	82	85	85		3	85	89	87	83	78	89
C03	1	1	1	1	85	78	80		3	90	92	88	88	84	85
C04	1	1	1	2	81	81	82		2	80	88	84	79	76	105
C05	1	2	1	1	92	95	100		4	100	100	95	98	104	82
C06	1	1	1	1	79	80	72		4	92	94	90	92	82	90
C07	1	1	1	1	78	80	74		3	84	88	79	86	80	80
C08	1	2	1	1	111	115	102		3	120	122	112	109	110	102
C09	1	1	1	2	87	89	79		4	88	92	87	87	82	82
C10	1	2	1	2	99	98	89		4	100	98	90	104	106	95
C11	1	1	1	1	67	69	68		3	79	84	82	70	78	77
C12	1	2	2	1	102	100	98		2	95	98	93	96	90	82
C13	1	1	2	1	74	74	70		2	70	72	70	71	68	74
C14	1	2	2	1	68	65	70		1	67	69	66	65	68	70
C15	1	1	2	1	95	90	101		2	90	92	88	85	95	87
C16	1	1	2	1	75	77	76		2	72	75	70	74	68	69
Non CI Subjects
Subject ID	Group	Gender	Mode of Communication	ESP-Pre	TL-Pre	AC-Pre	EC-Pre		ESP Post	CLS-Post	RLI-Post	ELI-Post	LCI-Post	LSI-Post	GF-Post
S01	2	2	2	1	95	89	100		2	93	89	85	100	92	82
S02	2	1	2	1	87	85	95		1	80	83	82	80	78	70
S03	2	2	2	2	76	78	80		1	78	72	70	77	80	65
S04	2	1	2	1	75	73	72		2	73	71	72	75	72	68
S05	2	1	2	1	79	78	80		1	80	70	72	85	81	63
S06	2	1	2	1	77	78	74		1	75	77	68	85	70	71
S07	2	1	2	1	78	80	72		2	72	75	70	72	69	60
S08	2	2	2	1	77	81	75		1	80	89	73	75	78	65
S09	2	1	2	1	87	88	84		1	80	84	80	75	80	68
S10	2	1	2	1	89	98	82		3	90	100	85	85	85	78
S11	2	2	2	1	90	94	92		1	85	90	82	79	87	72
S12	2	1	2	1	73	78	72		1	70	74	67	79	68	66
S13	2	2	2	1	74	74	75		1	70	72	69	67	75	67
S14	2	2	2	1	68	65	68		2	62	60	61	67	60	55
S15	2	1	2	1	75	74	72		1	71	77	67	75	71	70
S16	2	1	2	1	74	77	73		1	77	74	68	80	72	65

7. Trautwein and Ammerman are curious how the CI group compares to the norm on CLS at the end of the study.

a. What inferential test should the researchers use? Why?

b. What are the independent and dependent variables?

           

c. Using the A-B-C-D format used in class, answer Drs. Trautwein and Ammerman’s research question.

11. Drs. Trautwein and Ammerman are curious if receptive language changed in the non-CI group (from the beginning to the end of the study).

What type of inferential test should be used to test the hypothesis? Why?

If they found significance, what would their conclusions be?

DEHS Data Set for Assessment Projects
INTD 5064 Applied Statistics for Health Care Practitioners
CI Subjects
Subject ID	Group	Gender	Mode of Communication	ESP-Pre	TL-Pre	AC-Pre	EC-Pre		ESP Post	CLS-Post	RLI-Post	ELI-Post	LCI-Post	LSI-Post	GF-Post
C01	1	1	1	1	86	89	95		3	95	96	99	90	88	101
C02	1	2	1	1	82	85	85		3	85	89	87	83	78	89
C03	1	1	1	1	85	78	80		3	90	92	88	88	84	85
C04	1	1	1	2	81	81	82		2	80	88	84	79	76	105
C05	1	2	1	1	92	95	100		4	100	100	95	98	104	82
C06	1	1	1	1	79	80	72		4	92	94	90	92	82	90
C07	1	1	1	1	78	80	74		3	84	88	79	86	80	80
C08	1	2	1	1	111	115	102		3	120	122	112	109	110	102
C09	1	1	1	2	87	89	79		4	88	92	87	87	82	82
C10	1	2	1	2	99	98	89		4	100	98	90	104	106	95
C11	1	1	1	1	67	69	68		3	79	84	82	70	78	77
C12	1	2	2	1	102	100	98		2	95	98	93	96	90	82
C13	1	1	2	1	74	74	70		2	70	72	70	71	68	74
C14	1	2	2	1	68	65	70		1	67	69	66	65	68	70
C15	1	1	2	1	95	90	101		2	90	92	88	85	95	87
C16	1	1	2	1	75	77	76		2	72	75	70	74	68	69
Non CI Subjects
Subject ID	Group	Gender	Mode of Communication	ESP-Pre	TL-Pre	AC-Pre	EC-Pre		ESP Post	CLS-Post	RLI-Post	ELI-Post	LCI-Post	LSI-Post	GF-Post
S01	2	2	2	1	95	89	100		2	93	89	85	100	92	82
S02	2	1	2	1	87	85	95		1	80	83	82	80	78	70
S03	2	2	2	2	76	78	80		1	78	72	70	77	80	65
S04	2	1	2	1	75	73	72		2	73	71	72	75	72	68
S05	2	1	2	1	79	78	80		1	80	70	72	85	81	63
S06	2	1	2	1	77	78	74		1	75	77	68	85	70	71
S07	2	1	2	1	78	80	72		2	72	75	70	72	69	60
S08	2	2	2	1	77	81	75		1	80	89	73	75	78	65
S09	2	1	2	1	87	88	84		1	80	84	80	75	80	68
S10	2	1	2	1	89	98	82		3	90	100	85	85	85	78
S11	2	2	2	1	90	94	92		1	85	90	82	79	87	72
S12	2	1	2	1	73	78	72		1	70	74	67	79	68	66
S13	2	2	2	1	74	74	75		1	70	72	69	67	75	67
S14	2	2	2	1	68	65	68		2	62	60	61	67	60	55
S15	2	1	2	1	75	74	72		1	71	77	67	75	71	70
S16	2	1	2	1	74	77	73		1	77	74	68	80	72	65

The diner and the waiter play a sequential game. The waiter decides whether to give good service or not: the diner then decides, in each case, whether to leave a $4 tip. If there is bad service and no tip, each gets a payoff of 0. Good service is worth $6 to the diner and costs the waiter $2. So if there is good service and a tip, the diner gets a payoff of 6-4 = 2 and the waiter a payoff of 4-2 = 2, for example.

a) What is the unique sub-game perfect equilibrium of this game. Why?

b) Explain how infinite repetition makes it impossible for tipping to occur. Construct an equilibrium where this happens.

c) Use an analogue of the Grim Trigger and find what conditions on d( =1/(1+r)) allow such an equilibrium to work. Explain your work.

d) Now suppose that with probability 1-p in each period the game will end after this period - the waiter will get a job as an actor. Now? what conditions on d are necessary.

ANOVA BY HAND (DF BETWEEN AND WITHIN)

Does a woman’s chance of suffering from postpartum depression vary depending on the number of children she already has? To find out, a researcher collected random samples form four groups of women: the first group having just given birth to their first child, the second group having just given birth to their second child, and so on. He then rated their amount of postpartum depression on a scale from 1 to 5. Test the null hypothesis that the chances of developing postpartum depression do not differ with the number of children to which a woman has previously given birth. Test at .05 LOS. Please give an extensive interpretation. Please provide summary table.

First                            Second                        Third                           Fourth

Child                           Child                           Child                           Child

3                                  3                                  5                                  4

2                                  5                                  5                                  3

4                                  1                                  3                                  2

3                                  3                                  5                                  1

2                                  4                                  2                                  5

Java

Write a program that reads 4 integer numbers from the user combine it into a single number. You need to ask the user to first specify how to combine the numbers (forward or backward). Note that for the backward option you need to check that the last digits should be 0, also for the forward option you need to check that the fist digit is not 0. Use for loops and switch for the menu.                       4. Write an application that prompts the user to enter an integer limit and then print the numbers from 1 to this limit in the following format. The number read should not be greater than 10 and should not be negative.        Enter a number: 3 Enter a number: 6 Enter a number: 2 Enter a number: 0 1.Forward 2.Backward Choose an option: 1 The number is 3620 Enter a number: 3 Enter a number: 6 Enter a number: 2 Enter a number: 0 3.Forward 4.Backward Choose an option: 2 Error!