From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Interpret linear regression results

Interpret linear regression results - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Interpret linear regression results

“

- [Instructor] In the previous movie, we used the Analysis Toolpak's regression feature to perform linear regression on a set of variables. We had an independent variable of the number of customers that came into a store and a dependent variable on the sales from those customers. In this movie, I'll show you how to interpret the output. My sample file is 08_04_interpret, and you can find it in the chapter 8 folder of the Exercise Files collection. We put the output for our linear regression onto a new worksheet. The original data is still on Sheet1, which you can see here, and the results of the analysis are on Sheet2. At the top, we have our regression statistics. The first is multiple R, that's in cell B4. Multiple R is the correlation between our two sets of data, so we have the number of customers and the sales. And it turns out that there is a fairly high correlation, basically 0.71, between our two variables. So, it does appear that the number of customers has a significant…

Contents