Best Available Writers
№ 1 In global rating
278 finished papers
147 customer reviews
98% success rate
COMPETENCES: Nursing, Sociology, Creative Writing, Marketing
№ 2 In global rating
184 finished papers
120 customer reviews
97% success rate
COMPETENCES: Financial Analysis, Political Science, Marketing
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 deadlinesOrder 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?