How can I create a normal distribution in excel when the only data I have is...

How can I create a normal distribution in excel when the only data I have is mean and standard deviation?

Expert Solution

The above algorithm has the following result:

x	P(X=x)
1.9	0.003267
2	0.004432
2.1	0.005953
2.2	0.007915
2.3	0.010421
2.4	0.013583
2.5	0.017528
2.6	0.022395
2.7	0.028327
2.8	0.035475
2.9	0.043984
3	0.053991
3.1	0.065616
3.2	0.07895
3.3	0.094049
3.4	0.110921
3.5	0.129518
3.6	0.149727
3.7	0.171369
3.8	0.194186
3.9	0.217852
4	0.241971
4.1	0.266085
4.2	0.289692
4.3	0.312254
4.4	0.333225
4.5	0.352065
4.6	0.36827
4.7	0.381388
4.8	0.391043
4.9	0.396953
5	0.398942
5.1	0.396953
5.2	0.391043
5.3	0.381388
5.4	0.36827
5.5	0.352065
5.6	0.333225
5.7	0.312254
5.8	0.289692
5.9	0.266085
6	0.241971
6.1	0.217852
6.2	0.194186
6.3	0.171369
6.4	0.149727
6.5	0.129518
6.6	0.110921
6.7	0.094049
6.8	0.07895
6.9	0.065616
7	0.053991
7.1	0.043984
7.2	0.035475
7.3	0.028327
7.4	0.022395
7.5	0.017528
7.6	0.013583
7.7	0.010421
7.8	0.007915
7.9	0.005953
8	0.004432
8.1	0.003267

The graph for this sample is

Hope this was helpful. Please leave back any comment.

orchestra answered 2 years ago

Please answer in excel only. How do I create the graphs in excel and show the...

Please answer in excel only. How do I create the graphs in excel and show the data. Discuss the following two cost functions: TC=20+4Q TC=20+2Q+0.5Q^2 a) Calculate all cost curves and plot these curves on graphs. Total Cost Total Fixed Cost Total Variable Cost Average Total Cost Average Fixed Cost Average Variable Cost Marginal Cost b) In each case, indicate the point at which diminishing returns occur. (For question a), compute the required costs and plot the curves for quantities...

how can i apply the concept of normal distribution in civil engineering?

n general, when we have a normal distribution, we change it to the standard normal distribution....

n general, when we have a normal distribution, we change it to the standard normal distribution. What is the reason for that?

How the heavily the tails and skewness of distribution and the normal distribution can be measured?

Normal Distribution Create an example of each of the three types of normal distribution problems. The...

Normal Distribution Create an example of each of the three types of normal distribution problems. The project will be graded on: (3 points each) Each example of one of the problem types. (1 point) Clear writing style and examples

4- In general, when we have a normal distribution, we change it to the standard normal...

4- In general, when we have a normal distribution, we change it to the standard normal distribution. What is the reason for that?

How can I solve this in Excel? Please show how to solve it in excel step...

How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...

what steps can I take if my data is not a normal distributed? Not sure how...

what steps can I take if my data is not a normal distributed? Not sure how to ask. If the my data is not a normal distribution what steps can I take to make it a normal distribution.

The flow in a river can be modeled as a log-normal distribution. From the data, it...

The flow in a river can be modeled as a log-normal distribution. From the data, it was estimated that, the probability that the flow exceeds 1100 cfs is 50% and the probability that it exceeds 100 cfs is 90%. Let X denote the flow in cfs in the river. Flood conditions occur when flow is 5000 cfs or above. To compute the percentage of time flood conditions occur for this river, we have to find, P(X≥5000)=1-P(Z<a). What is the value...

a) The flow in a river can be modeled as a log-normal distribution. From the data,...

a) The flow in a river can be modeled as a log-normal distribution. From the data, it was estimated that, the probability that the flow exceeds 855 cfs is 50% and the probability that it exceeds 100 cfs is 90%. Let X denote the flow in cfs in the river. Flood conditions occur when flow is 5000 cfs or above. To compute the percentage of time flood conditions occur for this river, we have to find, P(X≥5000)=1-P(Z<a). What is the...

Question