This site under reconstruction.
The function XLOOKUP is a great improvement over VLOOKUP, but there is a surprising quirk about it. It boggles my mind and kind of leaves me unmoored. Background This whole exercise stems from a desire to learn about how Monte Carlo simulations could be set up, so I used a book that incorporated Excel with…
A couple of weeks ago I wrote about a book EveryData and the data the author was using, specifically the relationship between amount of weekly exercise and mortality rate. The more hours a week you exercise, the lower your mortality rate is. But there was a curiosity in the data: Some people apparently were exercising…
I’m kind of on a little project that entails exploring some ideas and approaches. One day I decided I would ask CoPilot sources of data on temperature. I wanted something on historical sources of data for heat indexes because it seemed that May was unusually warm. It seemed like Texas had heat waves a little…
What if your company is not on the analytics kick or does not make enough money to afford those fancy software tools advertising predictive analytics or some kind of analytics? What if your peers simply do not have any interest in exploring how to use data and find valuable information? You might still be able…
It’s been a couple of months now since ChatGPT exploded on the scene and managed to get 100 million users within about two months – an unheard of speed of use capture. Over the past few days, I’ve been either reading or watching videos of dire job implications arising from this new AI intelligence. I’m…
A friend of mine was curious about whether ChatGPT could do budgets. By the time she asked me, I had done some minimal experimentation with ChatGPT and Excel, but I hadn’t done budgeting or forecasting. I was kind of wondering how I would even approach ChatGPT. So, we embarked on an experiment. She sent me…
You must be logged in to post a comment.