Icon

WordleScoresOnAverage

Wordle Scores on Average

Description: The challenge requires you to recreate the Wordle bar chart for three players. If you have never played Wordle, check this brief introduction to the game. In this challenge, you are expected to do the following:

For the bar chart, each possible number of guesses (1 through 6) must be represented, as well as the number of victories by each player. Check this example with just a single player's data.
Transform the number of guesses [1, 6] into a score [1,10], but remember that a higher number of guesses should result in a lower score. A missing guess means that the player did not manage to guess the word and therefore should receive a 0 score.
Next, calculate the average of the three players. Who has the best average?
Now consider the difficulty of the words. Assign a weight W to the words in the list of the 306 most difficult words in the English language (file “difficult words.txt”), and recalculate the average of the three players for W=2 and for W=0. Has the player with the best score changed?

wordle-weeklychallengesdifficult wordsNode 3Node 4Node 5Node 6Node 7set diffWordW=0StatisticsPlayedAverageNode 12Node 13StatisticsWin %guesses => scoreNode 39set diffWordW=2Node 41Node 42Node 43unweightedweighted W0weighted W2Node 45Node 46Node 47missing guessesNode 49guessesguesses by playerNode 54Excel Reader Line Reader Cell Splitter Column Filter String Manipulation Joiner String Manipulation Rule Engine Statistics Row Filter Column Filter Math Formula Table Creator Cell Replacer Rule Engine Unpivoting Math Formula(Multi Column) Missing Value GroupBy Unpivoting GroupBy Row Filter Table Creator Concatenate GroupBy Pivoting Number To String ScoreBoard wordle-weeklychallengesdifficult wordsNode 3Node 4Node 5Node 6Node 7set diffWordW=0StatisticsPlayedAverageNode 12Node 13StatisticsWin %guesses => scoreNode 39set diffWordW=2Node 41Node 42Node 43unweightedweighted W0weighted W2Node 45Node 46Node 47missing guessesNode 49guessesguesses by playerNode 54Excel Reader Line Reader Cell Splitter Column Filter String Manipulation Joiner String Manipulation Rule Engine Statistics Row Filter Column Filter Math Formula Table Creator Cell Replacer Rule Engine Unpivoting Math Formula(Multi Column) Missing Value GroupBy Unpivoting GroupBy Row Filter Table Creator Concatenate GroupBy Pivoting Number To String ScoreBoard

Nodes

Extensions

Links