Who can do better than this as the further
Posted: Mon Dec 23, 2024 4:17 am
Data grid
In question 1 for example, we are looking for the highest value in the full cross-tab above across all the possible teams. We use the Maximum function across the 2D cube of Scoreline v Season and then we can return each of the possible values (the numeric, the scoreline or the season)
For question 1, 2 teams have had 15 occurrences of the same result in a given season:
Table with info in
For question 2 we are interested croatia phone number example in the ‘maximum distinct count’ of scorelines in any season using the following settings:
Table with details in
For question 2, there are 5 teams that have had 27 different scorelines in the same season:
Table with details in
If we look earlier than WW2 we find several teams we go back the more ‘outlier’ scores we find:
Table with details in
For question 3 we want to make use of the InRange function across the dimensions of scoreline and season. Again, we need to group by match scoreline and return the frequency of matches in every season. We then need to have 1 instance of a scoreline in every season for at least 73 seasons (i.e all of the completed seasons since WW2).
In question 1 for example, we are looking for the highest value in the full cross-tab above across all the possible teams. We use the Maximum function across the 2D cube of Scoreline v Season and then we can return each of the possible values (the numeric, the scoreline or the season)
For question 1, 2 teams have had 15 occurrences of the same result in a given season:
Table with info in
For question 2 we are interested croatia phone number example in the ‘maximum distinct count’ of scorelines in any season using the following settings:
Table with details in
For question 2, there are 5 teams that have had 27 different scorelines in the same season:
Table with details in
If we look earlier than WW2 we find several teams we go back the more ‘outlier’ scores we find:
Table with details in
For question 3 we want to make use of the InRange function across the dimensions of scoreline and season. Again, we need to group by match scoreline and return the frequency of matches in every season. We then need to have 1 instance of a scoreline in every season for at least 73 seasons (i.e all of the completed seasons since WW2).