L

#### Luciano Paulino da Silva

I have a worksheet like the following distribution in A and B columns

where the frequency is the number of occurrences for a given class

that could be repeated:

A B

Frequency Class

38 3

11 3

2 10

53 2

33 3

19 4

16 5

15 6

2 7

2 8

13 4

53 2

39 3

15 5

For some situations I can have thousands of rows.

In this way, I first need that the frequency distribution of these

data could be organized like the following:

Class Frequency

2 106

3 121

4 32

5 16

6 15

7 2

8 2

9 0

10 2

After that, I need that the descriptive statistics of this data could

be calculated including:

Mean

Median

Mode

Minimum

First Quartile (Q1)

Second Quartile (Q2)

Third Quartile (Q3)

Maximum

R

Variance

Standard deviation

Mean deviation

Sum of squares of deviation

Skewness

Kurtosis

Normal-inverse Gaussian distribution

Confidence interval 0.05

Confidence interval 0.50

Confidence interval 0.95

Somebody could help me with a macro or other solution to this?

Thanks in advance,

Luciano