Publications by Numbers around us

PowerQuery Puzzle solved with R

26.02.2024

#157–158PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #157We are getting long table of logs, and don’t really know what is going on here. But our manager wants to know when data in certain groups and variables changes. And nothing else should stay in ta...

1615 sym R (1403 sym/6 pcs) 8 img

The Analyst’s Odyssey: Transforming Data into Narratives

22.02.2024

In the digital age, where data proliferates like stars in the night sky, the role of an analyst transcends mere number-crunching. They are the modern-day storytellers, whose quill is the cursor, and parchment, the screen. Each report crafted is not just a document; it’s a distilled potion of wisdom extracted from the chaotic cauldron of raw data....

19718 sym R (635 sym/1 pcs) 6 img

R Solution for Excel Puzzles

19.02.2024

Puzzles no. 389–393PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #389Today’s task is again making graphic with numbers. We already made christmas trees, diamonds and similar things, so today we have to make so called quadrant. But I see it as crosshair...

3464 sym R (4654 sym/15 pcs) 16 img

PowerQuery Puzzle solved with R

13.02.2024

#153–156PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Similarly to the Excel Puzzles we have doubled episode today because of my winter holidays. Do not worry. Puzzles are still hot, although two weeks old. Lets go then.Puzzle #153This time we have four riddles...

2738 sym R (4077 sym/11 pcs) 12 img

R Solution for Excel Puzzles

12.02.2024

Puzzles no. 379–388PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Last week I were on my winter holiday and with refreshed mind, it is time to get back to work, to everyday routines, to our puzzles and challenges. I owe you my solutions for challenges for two we...

5407 sym R (8813 sym/28 pcs) 24 img

Navigating the Bayesian Landscape: From Concepts to Application

08.02.2024

In the diverse universe of statistical analysis, Bayesian statistics stands as a beacon of a distinct approach to understanding and interpreting the world through data. Unlike the classical, or frequentist, approach to statistics that many are familiar with, Bayesian statistics offers a different perspective, one rooted in the principles of probabi...

16579 sym 6 img

Shadow and Substance: Unveiling the Twin Mysteries of Correlation and Covariance

01.02.2024

In the grand tapestry of statistical analysis, the threads of correlation and covariance weave a complex narrative, telling stories hidden within data. Like twin stars in a vast galaxy of numbers, these concepts illuminate the relationships and patterns that guide us in understanding the world around us.Correlation and covariance are fundamental t...

21595 sym R (4293 sym/4 pcs) 6 img

PowerQuery Puzzle solved with R

30.01.2024

#151–152PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #151Today we simplified log of people work. They just written down date and time of start and end. Not really helpful, but fortunatelly their manager gave us certain rules: there are no overtime or wee...

1556 sym R (2511 sym/6 pcs) 8 img

R Solution for Excel Puzzles

29.01.2024

Puzzles no. 374–378PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #374Palindromes are pretty common topic in our puzzles, but always there is little twist, and today is not exception. We have “polluted” palindromes, and I want to say that way that if ...

3321 sym R (4119 sym/14 pcs) 14 img

The Art of Estimation in R: Confidence Intervals Demystified

25.01.2024

IntroductionIn the intricate world of data analysis, understanding and accurately interpreting confidence intervals is akin to mastering a crucial language. These statistical tools offer more than just a range of numbers; they provide a window into the reliability and precision of our estimates. Especially in R, a programming language celebrated fo...

11782 sym R (2263 sym/3 pcs) 6 img