hotel built 1880s 0.3-0.8 miles park 1940s theater 0.2-0.7 miles questions

Questions

I am not able to upload a image of the question or in tables as it...

I am not able to upload a image of the question or in tables as it is formated. Any suggestions how i can do this? Thank you

Penny’s Rent A Car
Penny’s Rent a Car offers three rental plans as shown in Table 1. Please note that the fixed cost is provided in terms of months. Later, you will be asked to construct a cost table in terms of annual cost.
Table 1. Rental plan characteristics
Plan
Fixed Monthly Payment
Additional costs per annual miles
I
$200
$0.095 per mile
II
$300
$0.061 for each of the first 12,000 miles and $0.05 per mile thereafter
III
$150
$0.10 for each of the first 12,000 miles and $0.20 per mile thereafter
A customer is considering which option to take. This customer estimates the likely annual mileage as shown in Table 2.
Table 2. Estimated annual mileage probabilities
Annual Miles
10,000
15,000
20,000
25,000
30,000
Probability
0.1
0.1
0.2
0.3
0.3
Create a cost matrix for this problem using total annual cost. Show all costs as negative values (i.e. accounting format).
1) What alternative is selected using the Maximax criterion?
2) What alternative is selected using the Maximin criterion?
3) What alternative is selected using the Expected Monetary Value criterion?
4) What alternative is selected using the Minimax Regret criterion?
5) What alternative is selected using the Expected Regret (or Expected Opportunity Loss) criterion?
HINT: Be sure to answer to develop a spreadsheet that is robust and is developed in a dynamic manner. Develop formulas to make it clear which decision that would be made based on the methods described. Remember, everything that is a cost should be negative (i.e. accounting format).

Above is the question and below is what is on the excel sheet to start answering the question. Can you please show all steps (showning the excel formulas)?

	Problem Information	Values
	Months Per Year	12
	Miles in contract	12,000

	Plan	Fixed Cost Per Month	Cost Per Mile for First 12000 miles	Cost Per Mile After 12000 miles
	I	$ (200.00)	$ (0.095)	$ (0.095)
	II	$ (300.00)	$ (0.061)	$ (0.050)
	III	$ (150.00)	$ (0.100)	$ (0.200)

	STATE OF NATURE	10,000	15,000	20,000	25,000	30,000
	Probabilities	10%	10%	20%	30%	30%

Show work below

In: Finance

Fossa (a terrestrial mammal in Madagascar) experience a population decline of 20% each time a cyclone hit a particular national park on the African coast, because their prey populations also decline rapidly. Usually, one cyclone hits every 10 years

1. Fossa (a terrestrial mammal in Madagascar) experience a population decline of 20% each time a cyclone hit a particular national park on the African coast, because their prey populations also decline rapidly. Usually, one cyclone hits every 10 years. However, in one unusual year, five cyclones hit this national park and the population was reduced in quick succession to a level that was then easily wiped out by hunters. The primary causes of this population’s extinction were:

a) Over-Exploitation & Demographic Stochasticity

b) Over-Exploitation & Environmental Stochasticity

c) Demographic Stochasticity & Habitat Loss

d) Environmental Stochasticity & Habitat Loss

e) Demographic & Environmental Stochasticity

2. For a decreasing population, which of the following could be true regarding a declining population?

a) Ro= .8 and r = .2
		b) Ro = .5 and r = 0
		c) Ro = 0.8 and r = - 0.2
		d) Ro= - 0.8 and r = - 0.2
		e) Ro= - 0.2 and r = 0.8

In: Biology

The first column contains time in seconds and the second column the concentration of reactant in...

The first column contains time in seconds and the second column the concentration of reactant in molar units.

e	0.0256
0.1	0.0195
0.2	0.0143
0.3	0.0105
0.45	0.0074
0.5	0.0066
0.6	0.0060
0.7	0.0031
0.8	0.0024
0.9	0.0031
1	0.0019
1.1	0.0022
1.2	0.0005
1.3	0.0012
1.4	0.0006
1.5	0.0009

What is the rate constant of the reaction? Be sure you include units. Use "M" for molar and "s" for seconds ?

What is the rate of the reaction at t = 0.5s? Express your answer in units of M/s

What is the concentration of product at t = 0.5s?

In: Chemistry

The following data have been collected for a dry food: Water Activity Moisture Content (g H2O...

The following data have been collected for a dry food:
Water Activity Moisture Content
(g H2O / g product)
0.1 0.060
0.2 0.085
0.3 0.110
0.4 0.122
0.5 0.125
0.6 0.148
0.7 0.173
0.8 0.232
(4 Point) This product was stored in an environment where after 30 days of storage the
moisture content of the product (in dry basis), as measured in the laboratory, was 25%. If
you were responsible for the warehouse and the quality of this product, would you be
concerned about the product quality based on its water activity? If you were, what would
you be concerned about?

In: Chemistry

Part 2: T-tests and Correlation For each question, conduct the appropriate statistical analysis. If some sort...

Part 2: T-tests and Correlation

For each question, conduct the appropriate statistical analysis. If some sort of t-test is appropriate for the question, determine which type of t-test is appropriate. If you are going to conduct an independent samples t-test, determine whether you need to do the version of the test for equal variances or the version for unequal variances. For each test, state the null hypothesis, state the alternative hypothesis, state the type of test that you conducted, and report and interpret the results. If ANOVA is the appropriate analysis, follow-up with the appropriate post-hoc tests if you reject the null hypothesis for your ANOVA. The data for each question can be found in the Excel file entitled “Data for Project 3.” Show your work in your spreadsheet just as you did for the practice exercise. Each question is worth 7 points.

A group of 12 welfare recipients participated in a job training program. Before- and after-abilities were measured through a standardized test. The data can be found in the sheet entitled “Part 2 Question 1.” Is there evidence of improvement?

Before	After
5	7
4	5
6	6
4	5
5	5
4	5
3	4
6	5
5	5
4	5
4	4
5	6

An important function of a firm’s human resources manager is to track worker turnover. As a general rule, companies prefer to retain workers. New workers frequently need to be trained and it often takes time for new workers to learn how to perform their jobs. To investigate nationwide results, a human resources manager organized a survey wherein a random sample of men and women was asked how many years they had worked for their current employers. The data can be found in the sheet entitled “Part 2 Question 2”. Can we infer that men and women have different job tenures?

Men	Women
3.2	0.7
15.7	0.9
1.3	0.8
0.7	0.3
8.6	5.8
10.4	2.3
3.2	1.4
1.3	9.3
23.9	5.7
0.2	12.1
0.8	2.8
11.1	0.4
1.5	1.4
3.7	1
14.9	0.8
3	11.9
2.3	4.8
18.2	1.3
12.9	21.5
2.5	10.8
3.8	6.3
3.4	20.7
5.5	1.8
3.8	16.4
7.3	4.1
3.7	2.7
9.7	1.4
10.3	20.7
4.3	4.5
9	4
15.8	0.6
9.9	3
4.1	1.1
5.6	7
1.4	1.4
0.1	2.3
1.2	17
5.1	6
5.8	3.7
6.8	6.8
13.7	6.1
6.1	0.4
6.4	4.9
2.5	3.3
2.2	10.6
4.4	4.9
18.1	0.3
0.4	4.7
2.8	3.7
13.9	1.4
7.9	2.8
5.4	1.3
6.2	18.6
2.5	4
1.3	7.1
10	2.5
2	30.8
1.5	5.8
4.3	8.9
1.3	7.6
5.8	11.2
2.8	3.2
1.5	9.4
0.6	5.6
5.8	8.2
4.8	0.1
2.7	2.5
5.7	11.1
17	2.8
11.3	1.1
9.6	13.5
1.9	2.2
15.8	10.3
2.4	1.6
5.6	6.6
0.9	1.9
0.6	1.3
11.2	1.7
0.6	7.8
1.2	5.3
0.7	3.1
3.1	5.2
0.2	7.6
0.5	0.6
3.7	5.6
7.1	2.2
1.6	10.5
0.1	2.8
3.8	8.5
3.6	6.2
1.8	18.3
1.4	3.4
11.3	8.9
10.2	20.2
1.6	0.6
1	2.5
5.3	3
10.1	0.7
3.4	10.7
3.7	0.3
6.4	4.1
14.2	35.9
2.2	7.1
2.6	4.2
18.9	3.2
6.4	1.4
12	2
6.6	2
7.3	20.9
5.3	25.2
10.3	1.4
16.7	5.2
12.6	2.9
1.9	3
7.1	2.5
6.6	6.1
1.6	12.4
3.2	3
1.6	8.4
0.9	0.8
0.5	13
1.5	1.5
1.9	1.1
4.8	5.9
18	8.4
1	10.6
0.8	4.2
16.5	0.6
1.6	17.6
3.1	1.4
0.6	4.7
10.8	15.4
1.2	8.6
3.1	2.6
3.3	0.6
3.1	8.8
3.7	5.6
0.7	10.3
2.5	6.5
2.3	1.6
5	0.6
0.3	0.8
4.1	7.9
3.4	3.5
6.2	7.5
8	6.5
7.8	3.3
1.8	3.2
0.3	2.4
0.7	3.3
14.1	3.6
5.1	8.1
2.5	3.9
3.3	1
1.5	2
19.5	27.9
3	15.4
1.8	0.5
3	0.5
14.7	3.2
21.4	2
11.8	18.5
8	2.9
0.9	1.2
23.5	5
4.7	1.4
4	11.5
3.3	10.8
3.3	0.9
16.6	0.5
1.6	2.2
0.6	14.9
6.3	0.4
13.4	5.4
1.1	4.5
2.6	0.8
11.2	0.1
5	7.2
17.3	3.2
0.2	6.3
4	7.3
5.2	3
8	17.9
12.2	0.1
0.7	8.9
3.4	0.1
0.4	2.3
1.3	12
0.8	3.5
3.2	1.4
1.2	2.7
1.6	9.9
15	0.9
11.7	2.4
6.6	3.1
5.3	2.2
9.5	10.7
1.4	10.7
5.9	15.7
9.1	4.5
2.1	3.5
0.6	4.9
1.6	5.9
1	4.6
1.8	7.6
29.3	2
6	4.1
16.4	0.5
8	12
2.6	1.4
13.6	16.2
1.1	0.8
4.5	5.4
1.6	0.1
5.8	1.1
0.2	8.6
3	1.7
0.1	3.4
2.8	1.3
11	2.8
4.9	1.7
24.1	5.3
15	0.2
6.1	2.6
9.3	1.1
1	7.1
1.5	5.3
1	2.5
2.5	20.3
0.5	7
0.2	0.4
2.3	2.2
0.4	3.1
10.9	7.5
8.3	1.2
5.3	6.6
1.4	10.1
2.5	2.8
2.5	1.7
2	18.8
1.2	3
3.3	1.6
2.9	1.5
1.8	1
4.4	5.7
4.5	2.7
6.2	3
0.9	1.2
0.8	4.6
0.2	4
0.9	0.6
1.3	6.8
2.6	0.4
2.6	1.2
1.2	3.7
2.7	0.3
6.3	8
4.3	11.5
1	4.2
12.2	7.6
11.9	4.3
6.5	5.3
1.2	4.3
6.1	2.4
16	1.4
0.5	4
9.8	10.7
4.3	10
5.1	2.6
3.7	1.1
17.3	9.1
0.7	5.8
2.2	11.9
1.5	0.3
1	1.3
18.6	1.8
2	3.7
1.5	2.6
3.2	1.8
4.1	1.2
16.4	3
7.2	2.3
8.2	2.1
15.2	3.2
0.1	3.6
1.2	3
7.7	9.2
2.2	6.9
9.7	12.7
4	2.5
6.5
3.5
4.7
5.8
8.7
0.4
3.2
2.5
0.4
16.6
2
9.8
12.8
4.8
2.2
5.4

In: Statistics and Probability

Ross Co., Westerfield, Inc., and Jordan Company announced a new agreement to market their respective products...

Ross Co., Westerfield, Inc., and Jordan Company announced a new agreement to market their respective products in China on July 18 (7/18), February 12 (2/12), and October 7 (10/7), respectively. Given the information below, calculate the cumulative abnormal return (CAR) for these stocks as a group. Assume all companies have an expected return equal to the market return. (A negative value should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 1 decimal place.)

Ross Co.			Westerfield, Inc.			Jordan Company
Date	Market Return	Company Return	Date	Market Return	Company Return	Date	Market Return	Company Return
7/12	-0.6	-0.3	2/8	-0.6	-0.3	10/1	1.4	0.6
7/13	1.2	0.3	2/9	-0.7	-0.3	10/2	1.3	0.6
7/16	0.4	0.3	2/10	0.4	0.6	10/3	0.7	1.3
7/17	-0.6	-0.2	2/11	0.6	2.1	10/6	-0.1	-0.7
7/18	-0.8	1.3	2/12	-0.1	0.1	10/7	-2.2	-0.7
7/19	-1.9	-0.1	2/15	1.2	1.9	10/8	1.2	0.6
7/20	-0.9	-0.3	2/16	0.7	0.5	10/9	-0.5	-0.6
7/23	0.6	0.4	2/17	-0.1	0	10/10	0.1	-0.1
7/24	1.2	0	2/18	1.6	0.4	10/13	-0.1	-0.6

	Abnormal returns (Ri – RM)
Days from announcement	Ross	W’field	Jordan	Sum	Average abnormal return	Cumulative average residual
−4
−3
−2
−1
0
1
2
3
4

In: Finance

The data in the table below are the changes in the amount of space available to...

The data in the table below are the changes in the amount of space available to standing passengers at the 19 stops between 1987 and 1988.

Changes AM	Changes PM
-0.4	-5.1
-1.1	-1.5
0	0.3
4.6	8.1
-0.7	3.3
0	0.5
3	-1.2
-1.8	-1.2
1	-3.2
0.8	-0.4
-3	5.3
-3	16.9
-0.9	-0.1
-0.3	-0.5
-0.5	0.6
0.2	-0.2
-0.3	-0.4
-0.3	-1.1
0.4	0.6

In the table below, summary information is presented for these data.

time	lower quartile	median	upper quartile
AM	-0.9	-0.3	0.4
PM	-1.2	-0.2	0.6

time	mean	standard deviation
AM	-0.121	1.766
PM	1.089	4.784

(a) Using the raw data and summary information presented in the tables above, construct modified box plots to compare the changes in available space the morning and afternoon. (Reminder: Don't forget to check for outliers!)
(b) The Transit System wishes to know if their efforts to improve the standing space were successful. (Remember, more space is better!) Their engineers had suggested that the changes in the system would, on average, be more successful at increasing the available space in the morning than in the afternoon. Does the data support this initial belief? What specific aspects of the plot in part (a) support your answer?
(c) Using your box plots in part (a), write a short paragraph for the New York Times describing the success the Transit System had in increasing the available space per passenger. Note any differences in success between the morning rush and the afternoon rush.

In: Statistics and Probability

A researcher claims that the average wind speed in his city is 10 miles per hour....

A researcher claims that the average wind speed in his city is 10 miles per hour. In a random sample of 36 days, you found the average speed of wind is 10.2 with a standard deviation of 0.8 miles per hour. At α=0.05 is there enough evidence to say that the average is greater than the researcher’s claim. Show your work by using hypothesis testing.

In: Statistics and Probability

The maintenance manager at a trucking company wants to build a regression model to forecast the...

The maintenance manager at a trucking company wants to build a regression model to forecast the time (in years) until the first engine overhaul based on four explanatory variables: (1) annual miles driven (in 1,000s of miles), (2) average load weight (in tons), (3) average driving speed (in mph), and (4) oil change interval (in 1,000s of miles). Based on driver logs and onboard computers, data have been obtained for a sample of 25 trucks. A portion of the data is shown in the accompanying table.

Time until First Engine Overhaul	Annual Miles Driven	Average Load Weight	Average Driving Speed	Oil Change Interval
7.7	43.0	15.0	46.0	18.0
0.7	98.2	20.0	51.0	33.0
⋮	⋮	⋮	⋮	⋮
6.1	60.8	28.0	56.0	22.0

a. For each explanatory variable, discuss whether it is likely to have a positive or negative causal effect on time until the first engine overhaul.

b. Estimate the regression model. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.)

TimeˆTime^ = + Miles + Load + Speed + Oil

c. Based on part (a), are the signs of the regression coefficients logical?

d. What is the predicted time before the first engine overhaul for a particular truck driven 55,000 miles per year with an average load of 22 tons, an average driving speed of 55 mph, and 15,000 miles between oil changes. (Round coefficient estimates to at least 4 decimal places and final answer to 2 decimal places.)

Time Until First Engine Overhaul	Annual Miles Driven	Average Load Weight	Average Driving Speed	Oil Change Interval
7.7	43	15	46	18
0.7	98.2	20	51	33
8.8	43.1	22	67	11
1.3	110.6	29	65	21
1.5	102.5	27	47	14
2	97.2	24	58	21
2.5	92.6	24	60	20
7.2	53.7	21	63	8
8.2	51.7	27	52	21
4.2	84.8	21	52	25
0.3	120.8	27	54	20
5.1	78	24	53	28
5	68.8	17	48	22
5	54.7	24	59	24
5.4	66.7	15	55	25
8.7	39	16	54	12
5.7	52.9	17	55	27
5.7	54.5	21	44	14
4.1	74.6	25	64	21
6.5	58.5	24	59	12
6.4	52.5	17	49	24
6.8	68.4	20	47	17
4.3	94.3	27	54	20
7.4	46.2	12	56	19
6.1	60.8	28	56	22

In: Statistics and Probability

13. Calculate the expected loss EL if k = $22,000, sigma = 0.7 and D =...

13. Calculate the expected loss EL if k = $22,000, sigma = 0.7 and D = 0.5.

14. A total of 10 units were tested over a 500-hour period. A total of 4 units failed after 10, 20, 70, and 400 hours. The other 6 did not fail during the 500-hour test. Calculate the failure rate.

15. The mean life of a diesel is 250,000 miles, with a standard deviation of 2,500 miles. What is the probability that it will wear out before 248,000 miles.

16. A component has a reliability of 0.99 for 600 hours of normal use. Determine the failure rate.

In: Statistics and Probability