When you add a trendline to a chart, you have the option to display the line's…equation and R-squared value.…If you'd like more information, including the data set's variance and standard…deviation, you can display those values in your workbook by using the Regression…tool in the Analysis ToolPak.…I've already created a chart that has the equation and the R-squared value for this dataset.…So in this case, a y value is equal to 1.7394 times X, which are the values along here,…or the values in the left-hand Impressions column, and you add a value of .7333…to generate the y value.…

If you want more information, you can use Excel's Regression tool.…To do that, you go on to the Data tab of the Ribbon and then in the Analysis…group, click Data Analysis.…If you don't see the Data Analysis button or the Analysis group on the Data…tab of the Ribbon, that means that you might not have installed the Analysis ToolPak add-in.…I show you how to do that in a movie earlier on in this course.…But now let's assume that it has been installed and click Data Analysis, and then…

Resume Transcript Auto-Scroll

Author

Released

12/8/2010

Excel 2007: Business Statistics with Curtis Frye shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques. The course covers important statistical terms and definitions, and then dives into techniques using the tools in Excel: formulas and functions for calculating averages and standard deviations, charts and graphs for summarizing data, and the Analysis ToolPak add-in for even greater insights into data. Exercise files are included with the course.