One of the biggest advantages of Python in Excel is that it brings more advanced analytical tools directly into the workbook environment where so much business data already lives. Time series analysis …
Python in Excel: How to forecast time series data with ARIMA
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 →
Python in Excel: How to do principal component analysis
In a previous post, I showed you how to use Copilot in Excel to perform principal component analysis, or PCA. This time, we're going to strip things down, dial the AI back a bit, and work through the …
Continue Reading about Python in Excel: How to do principal component analysis →
Python in Excel: How to conduct linear 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 →
How to understand the initialization environment in Python for Excel
Note: The Python in Excel initialization environment is now editable! Check out this post from Microsoft for more. The availability of Python integration within Excel has made Python an accessible …
Continue Reading about How to understand the initialization environment in Python for Excel →