Question

PART B: DESCRIPTIVE STATISTICS (75 points) Note: Please round your results to 2 decimals; When the 3rd decimal is 5 or more you round up, otherwise you round down. For example: 0.398 I rounded to 0.40; 0.3923 is rounded to 0.39 For two of the below problems, COMPUTE ALL DESCRIPTIVE STATISTICS (WITHOUT using the excel's tool "descriptive statistics") - mean, median, mode, quartiles, range, inter-quartile range, variance, standard deviation, coefficient of variation. An example of solution is given in problem 1 solution. Remember two important things about typing in Excel: (1) to start typing, just click on the desired cell; (2) if what you type starts with "=", it tells Excel to compute something instead of just displaying a value. When you want to enter a formula type "=" first. If you use an excel function, don't type "="; just click on the cell and next choose the excel function from the list of functions. For the rest of the problems COMPUTE ALL DESCRIPTIVE STATISTICS using the tool of your choice. If you use the excel tool "descriptive statistics" be sure you complete your solution by given the missing descriptive statistics (inter-quartiles, coefficient of variation). Double check the mode value(s). The excel tool gives only one mode value even if the set is multimode. Show the Excel output. For only one of the problems (of your choice) convert the data to Z-scores.

          PART B: DESCRIPTIVE STATISTICS (75
points)
Note: Please round your results to 2 decimals; When the
3rd decimal is 5 or more you round up, otherwise you
round down.
For example: 0.398 I rounded to 0.40; 0.3923 is rounded
to 0.39
For two of the below problems, COMPUTE ALL
DESCRIPTIVE STATISTICS (WITHOUT using the excel's
tool "descriptive statistics") - mean, median, mode,
quartiles, range, inter-quartile range, variance,
standard deviation, coefficient of variation.
An example of solution is given in problem 1 solution.
Remember two important things about typing in Excel: (1) to
start typing, just click on the desired cell; (2) if what you type
starts with "=", it tells Excel to compute something instead of
just displaying a value. When you want to enter a formula type
"=" first. If you use an excel function, don't type "="; just click
on the cell and next choose the excel function from the list of
functions.
For the rest of the problems COMPUTE ALL
DESCRIPTIVE STATISTICS using the tool of your choice.
If you use the excel tool "descriptive statistics" be
sure you complete your solution by given the missing
descriptive statistics (inter-quartiles, coefficient of
variation). Double check the mode value(s). The excel
tool gives only one mode value even if the set is
multimode. Show the Excel output.
For only one of the problems (of your choice) convert the
data to Z-scores.

PART B: DESCRIPTIVE STATISTICS (75
points)
Note: Please round your results to 2 decimals; When the
3rd decimal is 5 or more you round up, otherwise you
round down.
For example: 0.398 I rounded to 0.40; 0.3923 is rounded
to 0.39
For two of the below problems, COMPUTE ALL
DESCRIPTIVE STATISTICS (WITHOUT using the excel's
tool "descriptive statistics") - mean, median, mode,
quartiles, range, inter-quartile range, variance,
standard deviation, coefficient of variation.
An example of solution is given in problem 1 solution.
Remember two important things about typing in Excel: (1) to
start typing, just click on the desired cell; (2) if what you type
starts with "=", it tells Excel to compute something instead of
just displaying a value. When you want to enter a formula type
"=" first. If you use an excel function, don't type "="; just click
on the cell and next choose the excel function from the list of
functions.
For the rest of the problems COMPUTE ALL
DESCRIPTIVE STATISTICS using the tool of your choice.
If you use the excel tool "descriptive statistics" be
sure you complete your solution by given the missing
descriptive statistics (inter-quartiles, coefficient of
variation). Double check the mode value(s). The excel
tool gives only one mode value even if the set is
multimode. Show the Excel output.
For only one of the problems (of your choice) convert the
data to Z-scores.

Added by Adam B.

Question

Please give Ace some feedback