Formated as table and now to the interpret results

(this may be in the wrong category, apologies couldn't find the "Non-excel general queries")

Hi there,

I'm now using tables in Excel more often but now I need help interpreting results from my table. For example, my Excel table lists home and away team percentages for each game. For example, if Team A has a home winning % of 50% and Team B has an away winning percentage of 30% then Team A has a 20% overall winning advantage (50% - 30% = 20%).

My problem is where do I place a "range" on my data so to get an accurate prediction? Using the example above of 20% winning advantage (Team A over Team B), do I create a range of 20% to 25% or 20% to 30% or 15% to 20% etc ??

My problem is how do I interpret this data? Let's say there are 15 games over a specific period (i.e. week), and let's say in every 15 games the home team has a 20% winning advantage over the away team what should the 'start value' and 'end value' range be? How do I group the results? Normally the higher the winning advantage % the more likely a team will win and vice versa.

Do I analyse data ranges between:

15% to 20% ?
15% to 25% ?
20% to 25% ?
20% to 30% ?

Thank you for your help. I will group the results using 5% increments (i.e. 10% to 14.99%, 15% to 19.99%, 20% to 24.99% etc...

I've been doing my own analytics but I need "additional eyes" to view my data.

Please view my spreadsheet and write a formula/algorithm (optional) or just interpret the results using any angle. Please note the 'solid green bars' under "Your Team
Won?" are home team wins and the 'solid red bars' under "Your Team Won?" are home team losses.

From my own analytics, the greater the difference % (particularly over 25% difference) the home team has 83% winning chance over the away team. This is taken from
5 wins out of 6 games over 25% under the "Your Team Won" column. That's the very basic analytics I deduced from this data. *Please see "Your Team Won?" column* for
what I mean. I'm hoping someone else can see "extra data" or something I'm not seeing.

One part of the data is hard for me to analyse. All the results below 25% can be a minefield. Sometimes a top team that has 10% winning chance and is playing at home
will win 9/10 home games compared with a poor/average team who has a 10% winning chance and is playing at home. The top team in this instance simply has a better team, coach
, skills than the poor/average team that lacks the aforementioned criteria.

I know this spreadsheet isn't the be-all-and-end-all but I want to analyse it a little bit more.....and get others to analyze it too.....