Compare data with a 33% increase

[FreakyGirl]

Hello.

I need help in the final step of comparing 2 sets of data to check for consistency.

In each dataset there are only 20 possible combination that can happen.
Columns A, B, C for 2016
Columns K, L, M for 2017

For each combination, it shows how many times that combination came up for either S(singles) or P(pards)

for example... in 2016 out of 337 games...
the combination of 4333 came up 8 times for S & 11 times for P
the combination of 4332 came up 7 times for S & 13 times for P etc..

but in 2017 out of 501 games...
the combination of 4333 came up 9 times for S & 26 times for P
the combination of 4332 came up 9 times for S & 28 times for P etc..

I further broke this down into a percentage (which I'm not sure is entirely helpful)...

Columns U, V, W
for S with the combination of 4333 came up: 2.374% in 2016 & 1.796% in 2017

Since approx. 33% more games were played in 2017 how can I check to see if the combination results are being consistent from year to year?

Thanks,
FreakyGirl

 

[vletm]

@FreakyGirl
Like this way ... follow red and blue spots

 

[FreakyGirl]

Hello.

Thanks for the reply but I cant open that file.

Can you please make it a .xls extension instead.

Thanks & have a GREAT day!
FreakyGirl

 

[vletm]

FreakyGirl - ooooops!
Do You (really) mean that You can open ONLY .xls -files?
If really so .. then I gotta figure something later
... but here is a layout of that file.

... follow red and blue spots!
... I tried to do .xls-format too - check this file.

 

[FreakyGirl]

Hello.

This is great, thanks!

Yes, I really cant open anything other than .xls.

I don't use this for a business so & its always been sufficient for my needs.

Thanks for taking the time to convert the file for me.

Have a great day!
FreakyGirl