Determine initial values for X: To do this first generate equally spaced numbers between 0 and 10 (or more if you prefer).

Best Available Writers

1. In excel, plot the PMF/PDFand CDF of Poisson, Exponential, and Normal distributions as a function of their parameters (Lambda for Poisson and Exponential – mean and variance for Normal).

a. Determine initial values for X: To do this first generate equally spaced numbers between 0 and 10 (or more if you prefer).

b. Define initial values for parameters: Then use a separate cell with proper name to enter the initial value for parameters:

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

i. Lambda=1 for Poisson and Exponential(choose arbitrary initial values if you have more than one parameter; more than one parameter is possible depending on the formula you use).

ii. Mean=1 & variance=2 for Normal

c. Create three sheets: Copy the worksheet twice so you can plot each distribution separately. Name the resulting three worksheets according to the distribution you are plotting inside them.

d. Calculate using excel formulas: Then, in each of the three sheets, calculate the requested values(PDF, PMF, CDF) using excel formulas (you must use excel formulas, instead of calculating things outside).

e. Plot: Use a scatter plot (or other plotting methods that you prefer) to plot two-dimensional graphs for PDF, PMF, and CDFs. Give your graphs and its axes proper names. You should now have 6 graphs – two for each distribution.

f. Now make a copy of each worksheet, and increase the lambda value (first play with different values but ultimately set Lambda to 4). Explain how the distribution changes as lambda increases?

Best Available Writers