Questions:
f=0.39
- Go to (https://www.eia.gov/dnav/ng/hist/rngwhhdm.htm) and use the monthly natural gas
prices since 2010 to today. 1. Draw its plot versus time using excel. 2. Find mean, standard deviation,
range, first quartile, median, and third quartile of the data, interquartile range. (Use excel) 3. Can
you tell from the plot if the prices are independent from each other? Why? Why not? What kind of
plot do you expect if every month price is independent of the previous price? - Drawing a Normal distribution:
For the normal distribution with mean=f150 and standard deviation=(1-f)40, Draw x values versus
cumulative probabilities. X axis; from (mean-3xStandart dev.) to (mean+3xStandart dev.), increasing
by 10. Y axis; Cumulative probabilities (Relevant Excel functions, norm.dist, scatter diagram, label the
X axis with values). - Drawing the percentiles for a Normal distribution:
For the normal distribution with mean=f150 and standard deviation=(1-f)40, draw percentile plot.
X axis; Probabilities from 0.05 to 1.00 increasing by 0.05, Y axis; Corresponding percentiles. (Relevant
Excel function norm.inv) - Drawing binomial distribution.
For a binomial distribution with p = 0.5 and n=f25 (round), plot the probability mass function (PMF) and the cumulative distribution function (CDF). Calculate for x=0,1,2,.. f25, the probabilities from
the binomial distribution, Calculate Cumulative distribution function values and Plot these two sets
of values, preferable on the same plot. X axis; x values Y axis; PMF and CDF values (Relevant excel
function binom.dist, label the X axis with values)
For this distribution, find the 90% quantile (Relevant excel function binom.inv) - Drawing Poisson distribution
For a Poisson distribution with 𝜆=f10, draw probability mass function (PMF). X axis; 0,1,2,…….40. Y axis; Corresponding probabilities. Use excel. For a Poisson distribution with 𝜆=1-f10, draw probability mass function (PMF).
X axis; 0,1,2,…….40. Y axis; Corresponding probabilities. (Relevant excel function poisson.dist)