Category: Microsoft Office

Don’t get me wrong. Excel PivotTables are one of the best things since pizza and beer. (And considering how much I enjoy that particular combination of snack and beverage, that’s really saying something.) Nevertheless, there are times when you want to take full control, write your own DAX query, and display the results in a […]

Linear Regression using Microsoft Excel – Part 3 Interpreting the Results of a Linear Regression At first glance, the summary report for an Excel Linear Regression might seem to be a hodgepodge of cryptic numbers. In fact, the basic Excel summary report is pretty typical. The first thing we might take a look at is […]

Linear Regression using Microsoft Excel – Part 2. Don’t be fooled by the “Part 2”. Since we took a moment to review loading an Excel add-in, Part 2 is actually the beginning! How to do Linear Regression Analysis in Excel The first concern is locating the data that you want to analyze. It’s generally easy […]

Part I: Linear Regression in Microsoft Excel: How to Load the Excel Analysis Toolpak Add-In Most readers will be familiar with loading an Excel add-in. For those who don’t, or might be rusty, here’s a quick precis of what you need to do to perform easily linear regressions in Excel. The rest of you can […]

A look at STDEV, STDEVP, VAR and VARP- Amy M., from Developing SQL Queries for SQL Server, writes… “I know there are two functions for standard deviation and for variance in Transact-SQL, but I can never remember when to use which.” You are so right, Amy. It is hard to know when to use STDEV […]