Using excel to solve the following two probelms

/in /by

Using excel to solve the following two probelms

1. For five distributions below generate a random sample with 50 elements. Construct 5-number summary for each sample. Provide a box-plot.

The distributions: 1) any uniform (discrete or continuous), 2) any symmetric unimodal, 3) any unimodal that is left-skewed, 4) any U-shaped, 5) any symmetric bimodal.

If you use calculators, Excel, MATLAB, or any special statistical software (R, SAS) to do calculations, please provide the supporting materials for your answers. For example, if you do this with Excel, print out the worksheet with formulae. If you use calculators, write done manually how you calculate the characteristics.

The box-plot can be done manually.

2. Read about the Cavendish experiment (by Henry Cavendish, performed in 1797–1798). It is known as the first experiment to yield accurate values for the gravitational constant and to measure the density of Earth.

The data is in the file attached (see under ResourcesData files). Write a brief summary of the experiment and its results (4-5 sentences).
Compute the 5-number summary and provide a box-plot.

If you use calculators, Excel, MATLAB, or any special statistical software (R, SAS) to do calculations, please provide the supporting materials for your answers. For example, if you do this with Excel, print out the worksheet with formulae. If you use calculators, write done manually how you calculate the characteristics.

The box-plot should be done manually.