statistical analysis of unknown values

[Ethos]

Hi,

When it comes to statictic's I am an absolute beginner. please help.


In my pivot table I have 4 columns and 4 rows of data.
C1 C2 C3 C4

R1 1 17 20 63

R2 0 2 3 22

R3 0 15 3 26

R4 2 159 27 331

R4 relates to Unknown values, given this how can I analysis where these unknowns are likely to be placed within rows R1 to R3?.


any idea's

Ethos.

 

[clive2002]

Just to clarify,

Do you want a formula that will express the statisical chances of a number in R4 appearing in another row or column?

why a pivot table?

 

[Ethos]

Hi & thanks for replying,

I use a pivot table because it groups the values of ages as well as all the unknown ages. and suppresses the other columns from view.
A formula would be great yet its not the method that matters its the result the counts.

Regards,

Ethos.

 

[clive2002]

Still not clear on what u want to return.

Can you manually do an example?

 

[Ethos]

Hi I have resolved the problem using examples within this forum, the answer was to create projections. simply multiplying the unknown quantity by the individual percitile of known values calculated by dividing each row total by the total known value amout and converting to a percentage.