using excel to solve the following two probelms

QUALITYWRITERS.ORG is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.


Order a Similar Paper Order a Different Paper

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.

"Is this question part of your assignment? We can help"

ORDER NOW
Writerbay.net

Got stuck with a writing task? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order


Order a Similar Paper Order a Different Paper
Writerbay.net