Use Excel to generate a column of x values from 0 to 2.5 in steps of...

Use Excel to generate a column of x values from 0 to 2.5 in steps of 0.05 (that means your column must have numbers like 0, 0.05, 0.1, 0.15, . . . , 2.5).

Plot the PDF f(x) on your computer screen for the different values of x mentioned above for the following distributions.

(a) Uniform (use A = 0 and B = 2.5)

(b) Exponential (use mean = 2)

(d) Normal (use µ = 1.25 and σ = 0.4)

Please attach the PDF curves you plot. Under each plot, write down the name of the distribution

Solutions

Expert Solution

Here first column is points from 0 to 2.5 at steps 0.05.

2nd,3rd,4th,5th column represents probability of x under distribution of (a),(b),(c),(d).

For uniform =1/(2.5-0) then drag down

For exponential =EXP(-A2*0.5)/2 then drag down A2 is firs value of X.

For gamma =GAMMA.DIST(A2,1.7,1.2,FALSE) here cdf is false .

For normal =NORM.DIST(A2,1.25,0.4,FALSE)

orchestra answered 1 year ago

Next > < Previous

Related Solutions

7) Use Excel to generate a series of 100 random values from the exponential distribution with...

7) Use Excel to generate a series of 100 random values from the exponential distribution with a mean of 25? USING EXCEL SHOW ALL WORK

Use Excel to generate 100 N (10,5) distributed random values (that is 100 values of a...

Use Excel to generate 100 N (10,5) distributed random values (that is 100 values of a Normally distributed random variable with mean 10 and standard deviation 5). Plot histogram for your data. See Appendix on how to generate these values.

Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5....

Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5. Construct a histogram for them [Note: first generate 100 uniformly distributed random values from [0,1]; then use them as the first input for NORMINV( ) function, two other inputs are mean and standard deviation of given Normal distribution]

For all of the graphs below use a vector x ranging from 0 to 10 in steps of 0.1.

For all of the graphs below use a vector x ranging from 0 to 10 in steps of 0.1. Create two additional vectors using the following formulas: yp=x.^2.5 and ym=x.^(-2.5);[1;2] Create the formula for the derivative of yp (apply the rules of calculus to the formula for yp). Plot yp versus x. Add a straight line at 3 points (at x = 3, 5, 8) with the slope of the line (determined from the derivative) showing that the derivative is...

Collect the Data: Use a random number generator to generate 50 values between 0 and 1...

Collect the Data: Use a random number generator to generate 50 values between 0 and 1 (inclusive). Theoretical Distribution In words, X = The theoretical distribution of X is X ~ U(0, 1). In theory, based upon the distribution X ~ U(0, 1), find μ = __________ σ = __________ 1st quartile = __________ 3rd quartile = __________ median = __________ Construct a box plot of the data. Be sure to use a ruler to scale accurately and draw straight...

Integrate the following values of y from x = 0 to x = 130 using (a)...

Integrate the following values of y from x = 0 to x = 130 using (a) The midpoint rule using intervals of [0 10], [10 30], [30 70], and [70 130] (b) The trapezoid rule using the same intervals (c) Simpson’s rule using the same intervals x y 0 6 5 12 10 18 20 30 30 42 50 36 70 24 100 18 130 6 Integrate the differential equation dydt = y from t = 0 to t =...

Use the Rejection Method to generate n = 1000 values for a random variable X distributed...

Use the Rejection Method to generate n = 1000 values for a random variable X distributed as Exponential (lambda=5). Create a density histogram for your generated values and superimpose the probability density function of the target distribution to the histogram. Use the generated values to estimate the mean, standard deviation, and the probability that X < 2. Compare them with the theoretic values which are 0.2, 0.2, and 0.97725, respectively. Report the rejection rate. Write in R code

In excel, list the values of your bill for the last 12 months on one column....

In excel, list the values of your bill for the last 12 months on one column. Find the sample mean and sample standard deviation of your data. Pick three bills from the last 12 months and change the values into z-scores. What does the z-score tell you about that particular month? Between what two values would be considered a normal bill? Remember, being within 2 Standard Deviations is considered normal. Are any of your bills in the last 12 months...

In excel, list the values of your bill for the last 12 months on one column....

In excel, list the values of your bill for the last 12 months on one column. Find the sample mean and sample standard deviation of your data. Pick three bills from the last 12 months and change the values into z-scores. What does the z-score tell you about that particular month? Analysis Between what two values would be considered a normal bill? Remember, being within 2 Standard Deviations is considered normal. Are any of your bills in the last 12...

III. Use Table to generate a list of ordered pairs (x,sin x) for x=0, \[Pi]/12, 2\[Pi]/12,...

III. Use Table to generate a list of ordered pairs (x,sin x) for x=0, \[Pi]/12, 2\[Pi]/12, 3\[Pi]/12, ..., 2\[Pi]. You should end up with a list of lists. Then do it again but without using Table. Mathematica assignment, any ideas?

Subjects