Analytics & AI for Modern Excel
In a previous post, we looked at how Copilot in Excel can help us build an ARIMA forecast with Python. That approach has some real advantages: Copilot can help generate code, explain unfamiliar …
Continue Reading about Python in Excel: How to forecast time series data with ARIMA →
For years, running a logistic regression in Excel meant relying on add-ins like XLMiner or the Analysis Toolpak. They worked in a basic sense, but they were rigid and opaque, and they didn’t give …
Continue Reading about Python in Excel: How to do logistic regression with Copilot →
Data and tech trends come and go, but linear regression has remained one of the most reliable tools in a data analyst’s toolbox. It helps you identify relationships, test hypotheses, and make …
Continue Reading about Python in Excel: How to conduct linear regression with Copilot →
K-Nearest Neighbors (KNN) is a straightforward and powerful analytical tool that helps you make predictions by looking at the most similar cases or "neighbors" in your data. It's intuitive because it …
Continue Reading about Python in Excel: How to do k-nearest neighbors with Copilot →
Decision trees are intuitive analytical tools that help us explore and predict outcomes by asking simple, branching questions about our data. They're popular because they're visual, easy to interpret, …
Continue Reading about Python in Excel: How to build decision trees with Copilot →
