Linear Regression in Microsoft Excel: Part 2 – How to Perform the Analysis

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 […]
Read More ›

Linear Regression in Microsoft Excel: Part I – How to Load the Excel Analysis Toolpak

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 […]
Read More ›

Is MONEY Bad? How to Use the MONEY Datatype in SQL Server

Jamal K, from Developing High-Performance SQL Server® Databases inquires… “A colleague at work said the MONEY datatype in SQL Server is bad and shouldn’t be used. Are there good reasons behind this or is it just hearsay?” Excellent question, Jamal. Before dealing with the question itself let’s consider some historical background. There’s nothing that can […]
Read More ›

Which Standard Deviation & Variance to use in Excel (and SQL!).

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 […]
Read More ›

How to Make a Histogram in Excel Using the Frequency Function

The Importance of Histograms and Descriptive Statistics The word “statistics” comes from the German word “stadt”. Stadt means “city” but in the 18th century each city was a state in its own right. And the people who ran those states needed to have the facts. What is the population? What is the food production? How […]
Read More ›

Type to search

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.