Can I run a linear regression in Excel?

Anyone survived a statistics course at uni without running a linear regression in SPSS? Come forward, please Joke aside, linear regression is such a basic and fundamental forecasting tool that it is being taught across a range of bachelor and master programmes. Yet, all too often, very little is explained how you could use it … Continue reading Can I run a linear regression in Excel?

6 Major Differences between Excel 2016 for Windows and Excel 2016 for MAC

1.Excel for MAC does not support PowerPivot. Consequently, any pivot table based on the Excel Data Model will be unfilterable if the spreadsheet is opened by a MAC user. So will be any pivot table, that was created via the "Import from Microsoft Access Database" option as Excel for MAC does not support OLEDB connections, either. It … Continue reading 6 Major Differences between Excel 2016 for Windows and Excel 2016 for MAC

10 differences between a PowerPivot Pivot Table and a Standard one

1) PowerPivot Pivot Tables allow you to mix and match data from different tables (provided relationships between them have been created in the data model) 2) Summary Functions: PowerPivot Pivot Tables lack the "Product" and "Count Numbers" summary functions that standard pivot tables offer. But they do have the handy "Distinct Count" 🙂 3) Subtotals: Switching … Continue reading 10 differences between a PowerPivot Pivot Table and a Standard one

Top 3 Handy Features of Excel 2016

Visualizing statistical results in Excel has just become easier as the latest version enables you to create "Histogram" and "Pareto" charts (+ a bunch others) 2.Power Pivot Add-In is integrated, which essentially means that: (a) you do not have to install it separately as it was the case with Excel 2013 and Excel 2010 (b) you will see … Continue reading Top 3 Handy Features of Excel 2016