+ Reply to Thread
Results 1 to 2 of 2

Ranking and probabilities about games and league table

  1. #1
    Registered User
    Join Date
    01-13-2022
    Location
    London
    MS-Off Ver
    Latest ENG
    Posts
    1

    Post Ranking and probabilities about games and league table

    Hello everyone,

    I need your help to answer these questions on which I have spent a lot of time but am not making any progress...

    Construct the current League Table - ordered by points (3 for a win, 1 for a draw), goal difference and then goals scored.

    Produce prices for the upcoming fixtures, replacing the ?s with probabilities

    Calculate the probability of each team winning the league, finishing in the top 4 and being relegated (bottom 3). Every team plays everyone else, home and away.

    I work with Excel 2019 in English
    Many thanks in advance, for further details and discuss it do not hesitate to dm me or post a comment !!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,971

    Re: Ranking and probabilities about games and league table

    I feel that we need more information on the data.
    For example what do the values in columns D:F mean?
    Are the times in column G supposed to be scores as in should cell F2 display 1:1?
    Could the data in the upcoming fixtures file be placed at the bottom of the data in the sample data file?
    I suggest manually filling in at least a few of the rows of data in the upcoming fixtures file so that we have a better idea of what our proposed formulas/code should yield.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] League Table Ranking
    By tryingtoexcelatexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2018, 03:42 AM
  2. ranking problem with league table.
    By stevelad12 in forum Excel General
    Replies: 3
    Last Post: 09-20-2014, 07:34 AM
  3. League table ranking with 3 criteria
    By darkblueblood in forum Excel General
    Replies: 2
    Last Post: 06-12-2014, 06:13 AM
  4. [SOLVED] League Table Ranking
    By Zipmeister in forum Excel General
    Replies: 2
    Last Post: 01-20-2014, 07:03 AM
  5. League Table with previous week ranking
    By malveiro in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-15-2013, 09:22 AM
  6. [SOLVED] Help ranking in league table
    By SChapman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-24-2013, 03:29 AM
  7. League Table Ranking
    By okopo in forum Excel General
    Replies: 9
    Last Post: 01-10-2012, 08:51 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1