Help on best function to use for abnormal statistics/results.

**scottadam** · 05-13-2014, 12:53 AM

Best I explain a little, this is a very simple version of my problem.

Lets say I have a dice/die

the die is loaded, lets say its loaded to (6)

So we will see more (6s) than expected after say 1000 throws.

lets say the recorded throws are as follows.
150,150,150,150,150,250 FOR 1,2,3,4,5,6,

How can I analyze "150,150,150,150,150,250" with an excel function that will tell me the severity of the loading.?

I was looking at bell curves and just got lost so Im starting again (WITH NO IDEAS AT ALL) any pointers ?

**Kaper** · 05-13-2014, 01:26 AM

In my opinion it is less excel and more statistics here, so not necesserilly the best forum to ask.
The way to check would be for instance chi-square test.
with your data in A1:A6 you write array formula (the one commited with Ctrl+Shift+Enter, not just Enter) in some cell:

Please Login or Register  to view this content.

critical value for the above would be:
=CHISQ.INV.RT(0.05,5)
if the result of array formula is more then 11.07
(and for sample data it is 50, so by far more) you shall drop hypotesis that your input data came from uniform distribution population.

Nothing to do with bell curve here in my opinion.