Question: Please solve using Microsoft Excel Conduct goodness-of-fit tests for the following set of data. a)Test whether the data are exponentially distributed. b)Test whether the data
Please solve using Microsoft Excel
Conduct goodness-of-fit tests for the following set of data.
a)Test whether the data are exponentially distributed.
b)Test whether the data are normally distributed.
Note: For each goodness-of-fit test, you should experiment with a few histograms with varying numbers of bins and select at least two that best reveal the dispersion of the data.

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
