Find likelihood of making profit from the drilling contract

Assignment Help Basic Statistics
Reference no: EM131312509

Question:

A mining company has gained the drilling rights at two sites A and B. Each cost €100,000 each. Based on past experience they have estimated the chances of a successful drill as follows:

P(A) = 0.6, P(B) = 0.5

If successful, the predicted revenues from each site follow a Normal Distribution with the following parameters

Site A: Mean = 910,000, Std Dev = 370,000*

Site B: Mean = 960,000, Std Dev = 330,000

They know that the average number of accidents on this type of mining site is .5 and follows a Poisson distribution. They estimate that an accident will cost €500,000. Each site will have fixed costs of €400,000.

Using MS EXCEL estimate the

(i) The likelihood of making a profit from the drilling contracts

(ii) Expected value of the drilling contracts to the company. Justify your answer statistically and identify any assumptions you made.

All these values will be supplied in the Assessment Details File.

Reference no: EM131312509

Questions Cloud

Calculate the contribution margin for one case : Calculate contribution margin for one case with the following costs for this period, per case: a. materials/supplies: $2270 b. Wages: $2000 c. Utility, building, usage exp: $1125 d. Insurances (malpractice, business etc.): $175
Determine company value according to the methods : Determine the companys value according to the following methods. Identify the methods. Determine the value relative to the industry. Determine the intrinsic value assuming a 5% growth rate for infinity.
How this global societal issue impacts a specific population : Identify the global societal issue you have chosen to research for your Final Argumentative Essay and explain why further research on this topic is important.Provide a clear and concise thesis statement that includes a solution to the global societ..
Behind the trait theory of leadership : What is the underlying premise behind the Trait Theory of Leadership?
Find likelihood of making profit from the drilling contract : Using MS EXCEL estimate the likelihood of making a profit from the drilling contracts and Expected value of the drilling contracts to the company. Justify your answer statistically and identify any assumptions you made
Earnings for the firm with the cash flow : Calculate the value of the following two firms using the appropriate methodology. Identify the method. Earnings for the firm with the cash flow for the next 5 years at $500, $700, $1000, $1200 and $500. The firm then dissolves (that is its cash flow ..
What does your analysis indicate about the firms capacity : What does your analysis indicate about the firm's capacity to pay preferred stock dividends? Hint...this will require you to compute net earnings.
Describe a system that will permit reconstruction : Show that this is indeed the case. Describe a system that will permit reconstruction (within a constant factor) of this sinusoid from its samples taken uniformly at a sampling rate approaching zero.
Strategy consulting organization products and services : Study a strategy consulting organization's products and services as presented on its website. Then, see if you can map the consulting organization's products or services to key concepts covered in this course.

Reviews

len1312509

12/15/2016 12:32:03 AM

In this assignment Results should be exported to and presented in MS Word. The completed EXCEL file should also be loaded on Moodle. Marks will be awarded for presentation and use of MS EXCEL functions. The workings will be displayed on MS EXCEL.

Write a Review

Basic Statistics Questions & Answers

  State the decision rule

State the decision rule? (Negative amount should be indicated by a minus sign. Round your answers to 3 decimal places.)

  Confidence interval for mean-known standard deviation

Construct and interpret 90 percent on confidence interval for the mean. Be sure to interpret the meaning of this interval.

  Information about compute the probability

A certain disease occurs in 35% of the population. A test for the disease is fairly accurate: it misclassifies people with the disease as healthy 6% of the time and reports that a healthy person is diseased just 7% of the time.

  After a military campaign sample of 59 soldiers were

after a military campaign sample of 59 soldiers were examined it was determined that 32 of them suffered from lifetime

  Provides a visual display of in this instance

As a variant of the histogram, the 'tree map' provides a visual display of, in this instance, the UK finances. Like a histogram, the area of each box is proportional to the amounts spent or received. This version of a tree map represents UK Govern..

  A sample of size 100 has a sample standard deviation of 25

a sample of size 100 has a sample standard deviation of 25. what is the standard error of the sample mean? give your

  Life expectancy in germany and usa

According to the historical data, the life expectancy in the United States is equal to the life expectancy in Germany. A new study has been made to see whether this has changed. Records of 225 individuals from the United States who died recently a..

  Discuss the given survey with the nonparametric test

Strongly support, support, no opinion, do not support, strongly do not support. The number of people in each category was recorded.

  Information provided for development of a catalog

Given the information provided for development of a catalog product return process for periods 1 through 5, assign the PV values (using the rules) to develop a baseline for the project.

  Estimating the combined mean values for the given dataone

estimating the combined mean values for the given data.one sample of n 4 scores has a mean of m 10 and a second

  Find the simple linear regression equation

Historical tuition and fees. You can find data on past tuition and fees at several colleges by doing a Google search on "historical tuition and fees." Select one of the colleges you find and determine whether the data show the same pattern as you ..

  A certain game the probability of winning

A gambler believes that a strategy called "doubling up" is an effective way to gamble. The method requires the gambler to double the stake after each loss. Thus, if the initial bet is $1, after losing he will double the bet until he wins. After a ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd