A randomized experimental study was conducted to evaluate the effectiveness of a new cancer vaccine. One-thousand healthy adults were randomized to receive either the new vaccine (500 adults) or the old vaccine (500 adults). The adults were followed for 10 years to monitor the incidence of colon cancer. At the end of the study, the risk ratio for developing colon cancer was 0.5 among the adults who received the new vaccine compared to adults who received the old vaccine. The 95% confidence interval for this relative risk was 0.2-0.8 and the p value was 0.01.

a. ) State in words your interpretation of the risk ratio. Be as descriptive as possible.

b.) State in words your interpretation of the p value. Be as descriptive as possible.

c.) State in words your interpretation of the 95% confidence interval. Be as descriptive as possible, and do not simply repeat the interpretation given in part b.

d.) Suppose that the same experimental study was conducted and that the same risk ratio was observed (RR=0.5) using a much larger population - -1,000 adults in each group instead of 500 in each group. Would the 95% confidence interval be narrower or wider in the study with 2,000 adults as compared to the study with 1,000 adults?

Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $6.3 million. The equipment will be depreciated straight-line over 6 years, but, in fact, it can be sold after 6 years for $695,000. The firm believes that working capital at each date must be maintained at a level of 10% of next year’s forecast sales. The firm estimates production costs equal to $1.80 per trap and believes that the traps can be sold for $7 each. Sales forecasts are given in the following table. The project will come to an end in 6 years, when the trap becomes technologically obsolete. The firm’s tax bracket is 40%, and the required rate of return on the project is 11%. Year: 0 1 2 3 4 5 6 Thereafter Sales (millions of traps) 0 0.6 0.8 0.9 0.9 0.5 0.2 0 Suppose the firm can cut its requirements for working capital in half by using better inventory control systems. By how much will this increase project NPV? (Do not round your intermediate calculations. Enter your answer in millions rounded to 4 decimal places.)

Better Mousetraps has developed a new trap. It can go into production for an initial investment in equipment of $6.3 million. The equipment will be depreciated straight - line over 6 years to a value of zero, but, in fact, it can be sold after 6 years for $695,000. The firm believes that working capital at each date must be maintained at a level of 10% of next year’s forecast sales. The firm estimates production costs equal to $1.80 per trap and believes that the traps can be sold for $7 each. Sales forecasts are given in the following table. The project will come to an end in 6 years, when the trap becomes technologically obsolete. The firm’s tax bracket is 35%, and the required rate of return on the project is 11%.

Year:	0	1	2	3	4	5	6	Thereafter
Sales (millions of traps)	0	0.6	0.8	0.9	0.9	0.5	0.2	0

Suppose the firm can cut its requirements for working capital in half by using better inventory control systems. By how much will this increase project NPV? (Enter your answer in millions rounded to 4 decimal places.)

Cynthia​ Knott's oyster bar buys fresh Louisiana oysters for ​$4 per pound and sells them for ​$8 per pound. Any oysters not sold that day are sold to her​ cousin, who has a nearby grocery​ store, for ​$2 per pound. Cynthia believes that demand follows the normal​ distribution, with a mean of 120 pounds and a standard deviation of 10 pounds. How many pounds should she order each​ day? Refer to the standard normal table for​ z-values.

Cynthia should order nothing_______________pounds of oysters each day ​(round your response to one decimal​ place).

Z

0.00

0.01

0.02

0.03

0.04

0.05

0.06

0.07

0.08

0.09

0.0

0.5000

0.5040

0.5080

0.5120

0.5160

0.5199

0.5239

0.5279

0.5319

0.5359

0.1

0.5398

0.5438

0.5478

0.5517

0.5557

0.5596

0.5636

0.5675

0.5714

0.5754

0.2

0.5793

0.5832

0.5871

0.5910

0.5948

0.5987

0.6026

0.6064

0.6103

0.6141

0.3

0.6179

0.6217

0.6255

0.6293

0.6331

0.6368

0.6406

0.6443

0.6480

0.6517

0.4

0.6554

0.6591

0.6628

0.6664

0.6700

0.6736

0.6772

0.6808

0.6844

0.6879

0.5

0.6915

0.6950

0.6985

0.7019

0.7054

0.7088

0.7123

0.7157

0.7190

0.7224

0.6

0.7258

0.7291

0.7324

0.7357

0.7389

0.7422

0.7454

0.7486

0.7518

0.7549

0.7

0.7580

0.7612

0.7642

0.7673

0.7704

0.7734

0.7764

0.7794

0.7823

0.7852

0.8

0.7881

0.7910

0.7939

0.7967

0.7996

0.8023

0.8051

0.8079

0.8106

0.8133

0.9

0.8159

0.8186

0.8212

0.8238

0.8264

0.8289

0.8315

0.8340

0.8365

0.8389

1.0

0.8413

0.8438

0.8461

0.8485

0.8508

0.8531

0.8554

0.8577

0.8599

0.8621

1.1

0.8643

0.8665

0.8686

0.8708

0.8729

0.8749

0.8770

0.8790

0.8810

0.8830

1.2

0.8849

0.8869

0.8888

0.8907

0.8925

0.8944

0.8962

0.8980

0.8997

0.9015

1.3

0.9032

0.9049

0.9066

0.9082

0.9099

0.9115

0.9131

0.9147

0.9162

0.9177

1.4

0.9192

0.9207

0.9222

0.9236

0.9251

0.9265

0.9279

0.9292

0.9306

0.9319

1.5

0.9332

0.9345

0.9357

0.9370

0.9382

0.9394

0.9406

0.9418

0.9430

0.9441

1.6

0.9452

0.9463

0.9474

0.9485

0.9495

0.9505

0.9515

0.9525

0.9535

0.9545

1.7

0.9554

0.9564

0.9573

0.9582

0.9591

0.9599

0.9608

0.9616

0.9625

0.9633

1.8

0.9641

0.9649

0.9656

0.9664

0.9671

0.9678

0.9686

0.9693

0.9700

0.9706

1.9

0.9713

0.9719

0.9726

0.9732

0.9738

0.9744

0.9750

0.9756

0.9762

0.9767

2.0

0.9773

0.9778

0.9783

0.9788

0.9793

0.9798

0.9803

0.9808

0.9812

0.9817

2.1

0.9821

0.9826

0.9830

0.9834

0.9838

0.9842

0.9846

0.9850

0.9854

0.9857

2.2

0.9861

0.9865

0.9868

0.9871

0.9875

0.9878

0.9881

0.9884

0.9887

0.9890

2.3

0.9893

0.9896

0.9898

0.9901

0.9904

0.9906

0.9909

0.9911

0.9913

0.9916

2.4

0.9918

0.9920

0.9922

0.9925

0.9927

0.9929

0.9931

0.9932

0.9934

0.9936

2.5

0.9938

0.9940

0.9941

0.9943

0.9945

0.9946

0.9948

0.9949

0.9951

0.9952

2.6

0.9953

0.9955

0.9956

0.9957

0.9959

0.9960

0.9961

0.9962

0.9963

0.9964

2.7

0.9965

0.9966

0.9967

0.9968

0.9969

0.9970

0.9971

0.9972

0.9973

0.9974

2.8

0.9974

0.9975

0.9976

0.9977

0.9977

0.9978

0.9979

0.9980

0.9980

0.9981

2.9

0.9981

0.9982

0.9983

0.9983

0.9984

0.9984

0.9985

0.9985

0.9986

0.9986

3.0

0.9987

0.9987

0.9987

0.9988

0.9988

0.9989

0.9990

0.9989

0.9990

0.9990

An assistant in the district sales office of a national cosmetics firm obtained data on advertising expenditures and sales last year in the district’s 44 territories.

X1: expenditures for point-of-sale displays in beauty salons and department stores (X$1000).

X2: expenditures for local media advertising.

X3: expenditures for prorated share of national media advertising.

Y: Sales (X$1000).

y	x1	x2	x3
12.85	5.6	5.6	3.8
11.55	4.1	4.8	4.8
12.78	3.7	3.5	3.6
11.19	4.8	4.5	5.2
9	3.4	3.7	2.9
9.34	6.1	5.8	3.4
13.8	7.7	7.2	3.8
8.79	4	4	3.8
8.54	2.8	2.3	2.9
6.23	3.2	3	2.8
11.77	4.2	4.5	5.1
8.04	2.7	2.1	4.3
5.8	1.8	2.5	2.3
11.57	5	4.6	3.6
7.03	2.9	3.2	4
0.27	0	0.2	2.7
5.1	1.4	2.2	3.8
9.91	4.2	4.3	4.3
6.56	2.4	2.2	3.7
14.17	4.7	4.7	3.4
8.32	4.5	4.4	2.7
7.32	3.6	2.9	2.8
3.45	0.6	0.8	3.4
13.73	5.6	4.7	5.3
8.06	3.2	3.3	3.6
9.94	3.7	3.5	4.3
11.54	5.5	4.9	3.2
10.8	3	3.6	4.6
12.33	5.8	5	4.5
2.96	3.5	3.1	3
7.38	2.3	2	2.2
8.68	2	1.8	2.5
11.51	4.9	5.3	3.8
1.6	0.1	0.3	2.7
10.93	3.6	3.8	3.8
11.61	4.9	4.4	2.5
17.99	8.4	8.2	3.9
9.58	2.1	2.3	3.9
7.05	1.9	1.8	3.8
8.85	2.4	2	2.4
7.53	3.6	3.5	2.4
10.47	3.6	3.7	4.4
11.03	3.9	3.6	2.9
12.31	5.5	5	5.5

1. Test the regression relation between sales and the three predictor variables. State the hypotheses, test statistic and degrees of freedom, the p-value, the conclusion in words.

2. Determine whether the linear regression model is appropriate by using the “usual” plots (scatterplot, residual plots, histogram/QQ plot). Explain in detail whether or not each assumption appears to be substantially violated.

An assistant in the district sales office of a national cosmetics firm obtained data on advertising expenditures and sales last year in the district’s 44 territories. Data is consmetics.csv. Use R. I don't want answers in Excel or SAS :)

X1: expenditures for point-of-sale displays in beauty salons and department stores (X$1000).

X2: expenditures for local media advertising.

X3: expenditures for prorated share of national media advertising.

Y: Sales (X$1000).

6. (4) Are there any influential points?

7. Is there a serious multicollinearity problem?

(3) Include an appropriate scatterplot and correlation values between the explanatory variables.

(3) Judge by VIF, do you think there is a problem with multicollinearity? (Hint: VIP or tolerance)

(3) Compare your answers in parts i and ii. Are your conclusions the same or different? Please explain your answer.

Data:

y	x1	x2	x3
12.85	5.6	5.6	3.8
11.55	4.1	4.8	4.8
12.78	3.7	3.5	3.6
11.19	4.8	4.5	5.2
9	3.4	3.7	2.9
9.34	6.1	5.8	3.4
13.8	7.7	7.2	3.8
8.79	4	4	3.8
8.54	2.8	2.3	2.9
6.23	3.2	3	2.8
11.77	4.2	4.5	5.1
8.04	2.7	2.1	4.3
5.8	1.8	2.5	2.3
11.57	5	4.6	3.6
7.03	2.9	3.2	4
0.27	0	0.2	2.7
5.1	1.4	2.2	3.8
9.91	4.2	4.3	4.3
6.56	2.4	2.2	3.7
14.17	4.7	4.7	3.4
8.32	4.5	4.4	2.7
7.32	3.6	2.9	2.8
3.45	0.6	0.8	3.4
13.73	5.6	4.7	5.3
8.06	3.2	3.3	3.6
9.94	3.7	3.5	4.3
11.54	5.5	4.9	3.2
10.8	3	3.6	4.6
12.33	5.8	5	4.5
2.96	3.5	3.1	3
7.38	2.3	2	2.2
8.68	2	1.8	2.5
11.51	4.9	5.3	3.8
1.6	0.1	0.3	2.7
10.93	3.6	3.8	3.8
11.61	4.9	4.4	2.5
17.99	8.4	8.2	3.9
9.58	2.1	2.3	3.9
7.05	1.9	1.8	3.8
8.85	2.4	2	2.4
7.53	3.6	3.5	2.4
10.47	3.6	3.7	4.4
11.03	3.9	3.6	2.9
12.31	5.5	5	5.5

On January 1, Park Corporation and Strand Corporation had condensed balance sheets as follows:

	Park				Strand
Current assets	$	70,000			$	20,000
Noncurrent assets		90,000				40,000
Total assets	$	160,000			$	60,000
Current liabilities	$	30,000			$	10,000
Long-term debt		50,000				0
Stockholders’ equity		80,000				50,000
Total liabilities and equities	$	160,000			$	60,000

On January 2, Park borrowed $60,000 and used the proceeds to obtain 80 percent of the outstanding common shares of Strand. The acquisition price was considered proportionate to Strand’s total fair value. The $60,000 debt is payable in 10 equal annual principal payments, plus interest, beginning December 31. The excess fair value of the investment over the underlying book value of the acquired net assets is allocated to inventory (60 percent) and to goodwill (40 percent).

On a consolidated balance sheet as of January 2, what should be the amount for current assets?

On a consolidated balance sheet as of January 2, what should be the amount for noncurrent assets?

Teton Village, Wyoming, near Grand Teton Park and Yellowstone Park, contains shops, restaurants, and motels. The village has two peak seasons---winter, for skiing on the 10,000-foot slopes, and summer, for tourists visiting the parks. The number of visitors(in thousands) by quarter for five years can be found in Data Table Two below

1.Develop the typical seasonal pattern for Teton Village

2. Determine the seasonally adjusted number of visitors for winter 2011.

Data Table Two

Year	Quarter	Number of Visitors(in thousands)
2005	Winter	117
	Spring	80.7
	Summer	129.6
	Fall	76.1
2006	Winter	118.6
	Spring	82.5
	Summer	121.4
	Fall	77
2007	Winter	114
	Spring	84.3
	Summer	119.9
	Fall	75
2008	Winter	120.7
	Spring	79.6
	Summer	130.7
	Fall	69.6
2009	Winter	125.2
	Spring	80.2
	Summer	127.6
	Fall	72

Please post the answer with the work performed in excel and not just the answer, need to show work as I don't understand how to do this and would like the steps so that I can also learn it and it shows all work. You can add screenshots of the steps to find the answer in excel.

Park Rangers in a Yellowstone National Park have determined that fawns less than 6 months old have a body weight that is approximately normally distributed with a mean µ = 26.1 kg and standard deviation σ = 4.2 kg. Let x be the weight of a fawn in kilograms. Complete each of the following steps for the word problems below:  Rewrite each of the following word problems into a probability expression, such as P(x>30).  Convert each of the probability expressions involving x into probability expressions involving z, using the information from the scenario.  Sketch a normal curve for each z probability expression with the appropriate probability area shaded.  Solve the problem.

1. What is the probability of selecting a fawn less than 6 months old in Yellowstone that weighs less than 25 kilograms?

2. What is the probability of selecting a fawn less than 6 months old in Yellowstone that weighs more than 19 kilograms?

3. What is the probability of selecting a fawn less than 6 months old in Yellowstone that weighs between 30 and 38 kilograms?

4. If a fawn less than 6 months old weighs 16 pounds, would you say that it is an unusually small animal? Explain and verify your answer mathematically.

5. What is the weight of a fawn less than 6 months old that corresponds with a 20% probability of being randomly selected? Explain and verify your answer mathematically.

On January 1, Park Corporation and Strand Corporation had condensed balance sheets as follows:

	Park				Strand
Current assets	$	74,500			$	16,050
Noncurrent assets		92,250				46,200
Total assets	$	166,750			$	62,250
Current liabilities	$	32,000			$	12,250
Long-term debt		51,750
Stockholders' equity		83,000				50,000
Total liabilities and equities	$	166,750			$	62,250

On January 2, Park borrowed $66,000 and used the proceeds to obtain 80 percent of the outstanding common shares of Strand. The acquisition price was considered proportionate to Strand’s total fair value. The $66,000 debt is payable in 10 equal annual principal payments, plus interest, beginning December 31. The excess fair value of the investment over the underlying book value of the acquired net assets is allocated to inventory (60 percent) and to goodwill (40 percent).

(1) On a consolidated balance sheet as of January 2, what should be the amount for current assets?

(2) On a consolidated balance sheet as of January 2, what should be the amount for non current assets?