Question

..l HayatEve Sigar 02:28 @ 7%26 O Х ÖDEV-istatistik M 6.4 4.6 4.6 4.7 5.2 5.2 4.2 4.2 4.2 4.2 4.3 6.4 5.2 6.7 4.7 5.6 5.6 5.7 5.7 5.7 5.8 6.0 6.7 4.8 4.8 4.8 5.4 5.4 5.5 5.5 5.5 5.5 6.8 6.8 7.1 5.1 6.1 4.4 4.4 4.4 4.4 4.5 5.1 5.1 5.2 6.3 6.3 7.2 7.2 7.3 7.4 5.5 5.6 6.3

n the table below, earthquake magnitudes are given for any region for the last 100 years. Convert each value in this table to your own values ​​to get a new table.

your new values

1. A) frequency table and create histogram find

B)standard deviation, find values

C) ,%variation coefficients find values

D) mode and median find values

use the formula below for conversion

Mnew=M-log10(N)

N=33

please show which item you solved when solving

Sample (A B C D)

single digit after comma

Answer 1

The values are converted first, as follows:

press F2= to enter the formula after selecting 5x11 cells for accomodating the new values

press Ctrl+Shift+Enter to get the updated values

A)

Use the data analysis option and select 'Histogram' to get the given dialog box.

check the three boxes

Select the input range by selecting the complete data

Select some blank cells to accommodate the output data in the Output Range option

B) Use STDEV.S function to find the standard deviation as shown below:

C) To find the coefficient of variation, we have to find the mean of the data using average function since,

CV=SD/mean

D) The 'MEDIAN' function is used to find the median as shown:

'MODE' function is used to find the mode of the given data as shown below:

FINAL RESULTS: