Question

In: Statistics and Probability

Create 4 Weibull distributions using the data below. Distribution Alpha Beta 1 1 0.5 2 &nbsp

Create 4 Weibull distributions using the data below.

Distribution Alpha Beta

1 1 0.5

2 1 1

3 1 2

4 4.5 6.2

Please show how to plot the four graphs and all excel commands

Thank you!

Solutions

Expert Solution

Distribution 1:

i) Enter t value 0.1, 0.2, 0.3,...0.8 in column B

ii) Calculate Weibull probabilities by using Excel function WEIBULL.DIST

iii) Draw Area Diagram from Insert Tool

Distribution 2:

i) Enter t value 0.1, 0.2, 0.3,...0.8 in column B

ii) Calculate Weibull probabilities by using Excel function WEIBULL.DIST

iii) Draw Area Diagram from Insert Tool

Distribution 3:

i) Enter t value 0.1, 0.2, 0.3,...0.8 in column B

ii) Calculate Weibull probabilities by using Excel function WEIBULL.DIST

iii) Draw Area Diagram from Insert Tool

Distribution 4:

i) Enter t value 0.1, 0.2, 0.3,...0.8 in column B

ii) Calculate Weibull probabilities by using Excel function WEIBULL.DIST

iii) Draw Area Diagram from Insert Tool

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Estimation of the parameters for the Exponential and Weibull distributions. DATA SET A: 2, 14, 23,...

Estimation of the parameters for the Exponential and Weibull distributions. DATA SET A: 2, 14, 23, 45, 67, 75, 89, 99, 101, 123, 138, 159, 188, 201, 203 DATA SET B: 13, 24, 35+, 65, 86, 99, 109, 118+, 131, 159, 189, 207 DATA SET C: 5, 13, 34+, 46+, 55, 74, 89, 93, 104, 112+, 126, 134, 145, 159, 167+, 173, 198, 203, 226, 241 DATA SET D: 9, 14, 85, 99, 126, 155, 169+, 199, 201+, 224+, 229,...

Determine whether the distributions below are probability distributions. If not, what characteristic of the distribution is...

Determine whether the distributions below are probability distributions. If not, what characteristic of the distribution is the reason? Bulleye Hit Darts X P(X = x) 0 0.64 1 0.26 2 0.18 3 0.04 4 -0.12 Bullseye's Hit in Darts X P(X = x) 0 0.69 1 0.16 2 0.12 3 0.08 4 0.03 Bullseye's Hit in Darts X P(X = x) 0 0.57 1 0.26 2 0.11 3 0.04 4 0.02 Bullseye's Hit in Darts X P(X = x) 0...

Using the cash flows given in the table below for mutually exclusive projects Alpha and Beta,...

Using the cash flows given in the table below for mutually exclusive projects Alpha and Beta, assist the Chief Financial Officer in finding the breakeven rate (the crossover point or the rate of indifference). Which project do you recommend if using a cost of capital of 9% and Why? YEAR PROJECT ALPHA PROJECT BETA 0 -175 000 -82 500 1 40 000 30 000 2 60 000 10 500 3 85 000 40 000 4 92 000 75 000 5...

Homework Please create a Paper of WEIBULL DISTRIBUTION in a cohesive and concise way; •Introduction •Content...

Homework Please create a Paper of WEIBULL DISTRIBUTION in a cohesive and concise way; •Introduction •Content •Conclusion •References NOTES: •Four to Five Authors/Editors •Paper should have 4 pages minimum (including the references)

For the data below, create a frequency distribution, a cumulative frequencydistribution, a cumulative frequency distribution, and...

For the data below, create a frequency distribution, a cumulative frequencydistribution, a cumulative frequency distribution, and a percentage distribution. Then, calculate and report the mean and mode. Submit a photo of your work. 20, 19, 18, 18, 18, 17, 16, 16, 15, 14, 13, 13, 11

Q1 (100%): Using data below, do the following: 1) Create the efficient frontier; 2) Calculate the...

Q1 (100%): Using data below, do the following: 1) Create the efficient frontier; 2) Calculate the optimal portfolio; 3) Draw the Capital Market Line. Note the line must be based on data, not your fine art skills. Security A Security B Portfolio Mean 0.09 0.15 Standard Deviation 0.20 0.33 Variance 0.04 0.11 Covariance 0.0095 Risk-free rate 5.20% please attach the exal work so i can downlond it

The strength Y of a product has the Weibull distribution with pdf; ?(?) = {????−1?(−???), ...

The strength Y of a product has the Weibull distribution with pdf; ?(?) = {????−1?(−???), ??? ? > 0, ? > 0 0, ?????ℎ??? If ? is unknown and ? is known. The strength of a random sample of n products are, ?1,?2,…,??. a) Find the form of the most powerful test of the null hypothesis ? = 0.5 against the alternative hypothesis ? = 1.0. b) Show that ? ? ? has an exponential distribution. c) Use ?2...

1. TRUE OR FALSE: In general, the sum of alpha and beta should equal 1. 2....

1. TRUE OR FALSE: In general, the sum of alpha and beta should equal 1. 2. TRUE OR FALSE: The most common power level is .05. 3. Which hypothesis states that there will be an effect, difference or association? A. the null B. the alternative C. the alternate D. the nil 4. Which is true of one-tailed tests? A. larger CV B. larger alpha C. less power D. smaller CV 5. TRUE OR FALSE: Failing to find an effect that...

Artificial Intelligence Assignment question 3 Using Alpha Beta pruning, reduce the search space provided below and...

Artificial Intelligence Assignment question 3 Using Alpha Beta pruning, reduce the search space provided below and the necessary information.

x y fxy(x,y) -1 -2 1/8 -0.5 -1 1/4 0.5 1 1/2 1 2 1/8 Show...

x y fxy(x,y) -1 -2 1/8 -0.5 -1 1/4 0.5 1 1/2 1 2 1/8 Show that the function above satisfies the probabilities of a joint probability mass function. Find E(X), E(Y), V(X), V(Y) Find marginal probability distribution of X Find the covariance and correlation.

Subjects