Histogram + Frequency + Statistical Analysis

**NoPuck4You** · 08-28-2007, 04:34 PM

I have a collection of data points that look something like this:

0.123 5
0.235 7
0.245 3
0.456 6
1.109 4

Column 1 = label (load time)
Column 2 = frequency

I have up to 50,000 Rows of Data!

I'm able to do a generic Histogram chart, but what I am looking for is to obtain the standard statistical data set off of this data: mean, median, mode, standard deviation...etc.

The issue I'm having is that all the formulas want raw data (no frequency calculations). Is there an easy way to get the statistical analysis either by using the frequency numbers or by using some kind of VBA code or other function to convert the frequency back into the original data elements?

The report I receive is auto aggregated into frequency counts and I have no way of receiving the original raw data points.

Thanks for the help in advance!

**Dav** · 08-29-2007, 08:39 AM

I started going down the formula route, bur decided a macro would be quicker, just as long as you do not run out of rows

See the attached workbook

Regards

Dav

**NoPuck4You** · 08-30-2007, 08:53 PM

Thanks for the help. That did the trick. I've expanded the macro to go to the next column after 65000 entries. I think my largest data set was 65000x8 (approx).

**janef1160** · 04-22-2015, 10:17 AM

I need to do a similar thing but with car names...is this possible?

Ford 356
Volkswagen 273
Vauxhall 205
Toyota 157
Peugeot 140
BMW 135
Nissan 132
Honda 130
Audi 124
Citroen 103
BMW Mini 101
Mercedes Benz 97
Renault 96
Fiat 88
Mazda 83
Hyundai 74
Skoda 72
Volvo 64
Land Rover 55
Kia Motors UK 54
Seat 42
Suzuki 42
Other 29
Saab 24
Jaguar 20
Mitsubishi 20
(Chevrolet) Jeep 17
Alfa Romeo 15
Smart Car 14
Lexus 13
Rover 11
Subaru 10
Porsche 9
Chrysler 2
Daewoo 2
Daihatsu 2
Bentley 0

**newdoverman** · 04-22-2015, 11:21 AM

You will very likely get a better response to your question if you start a new thread instead of adding yours to an already existing thread. Adding your question to that of another person is called "Hijacking" and is against the rules.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.