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

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: 

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?

• • Assignment status: Resolved by our Writing Team
  • Source@PrimeWritersBay.com

.

GET THIS PAPER COMPLETED FOR YOU FROM THE WRITING EXPERTS 
CLICK HERE TO ORDER 100% ORIGINAL PAPERS AT PrimeWritersBay.com

• • • • NO PLAGIARISM