When in my videos I talk about the importance of data documentation and/or process, of the code, I’m not saying that EVERYONE can potentially make this mistake. In this article I deal in an extremely concise manner another point of failure of the vertical lookup formula, =VLOOKUP which, in the case of Google spreadsheet documentation …
Yet another time you will see me say that in statistics 80% of the time is used for obtaining and cleaning data and 20% for the fun parts like data dashboards and models. If we want to make descriptive statistics thanks to an aggregation of the vertical lookup, =VLOOKUP both on Excel and on Google …
How dirty data doesn’t make the vertical lookup work Read More »
Each profession has its points of reference in order to work according to good practices. Navigators used the compass, the polar star. Poets the inspiration, the muse. The saints the faith. And entrepreneurs? Not everyone has a Beatrice (ref. Dante) but all entrepreneurs and managers, while working, leave physical or digital traces. Data …
One of the first words we associate with the word future results uncertainty. In the past we relied on vicars of deities, oracles, drugs, or a mixture, to get some answers about the future. Today, finding ourselves in the scientific age, closing the Comtian reference, we have various and different ways of measuring uncertainty, in …
Knowing the future: from magic to tarot cards, from astrology to calculators Read More »
You know those bad stories you hear about designers and architects, for example? They deliver the project to the clients. They say “nice!” only to then discover that they have completely changed the site, the logo, the architecture and much more even though they paid for it. In the world of statistics, it can …
The costs of not listening to the statistician, data scientist Read More »
Today I write about doctors, but not about those who have this label because they “know”, so dotti. As Giovanni also says in a famous sketch by Aldo Giovanni and Giacomo, the doctor is interested in the symptoms, not the diagnosis. Many patients go to the doctor and tell them”I have x,y,z, searching on Google …
Primary care physicians and statisticians, things in common. Read More »
Does statistics, or in this case data science, expire like pasteurized milk or does it have an expiration date similar to that of long-life milk? Or does statistics have the problems of electronic devices that improve every year? Does statistics have a programmed obsolescence, even if that of milk is an expiration made in good …
Does statistics have obsolescence, planned obsolescence, or senescence? Read More »
Introduction One of the objectives of statistics is to explain the variability of a phenomenon of interest, through a mathematical expression, i.e. an equation called a model, made up of an objective (dependent) variable and explaining (explanatory, independent) variables. . If the target variable has no variability, then we do not have a variable but …
How to recognize a computer scientist doing statistics and why you need to be careful Read More »
