10 Statistical Functions in Excel every Analytics Professional Should Know

Overview Microsoft Excel is an excellent tool for learning and executing statistical functions Here are 12 statistical functions in Excel that you should master for a successful analytics career Let’s Excel in Statistics! “Statistics is the grammar of Science.” – Karl Pearson Let’s make that a bit more relevant for us – Statistics is the grammar of “Data” Science. You’ll notice that almost every successful data science professional or analytics professional has a solid understanding of statistics – but […]

Time Series in Excel! Learn Exponential Smoothing Models for Time Series Forecasting in Excel

Overview Excel is the perfect fit for building your time series forecasting models We’ll discuss exponential smoothing models for time series forecasting, including the math behind them We’ll also implement these exponential smoothing models in MS Excel Introduction Time series in Excel – just seems like a natural fit, right? We see and design line charts in Excel all the time – from sales forecasts to revenue reviews – it all fits into how we think about using Excel […]