Excel functions

Keyboard Shortcuts

Joe Schumueller introduces the use of Excel as a teaching tool to explore statistical concepts. Specifically he shows how to use sum, sum of squares, and sum of products. These functions form the basis for statistical computation. Joe demonstrates the use of menus to insert functions, manually entering functions, dragging, autofilling, and how to use array functions.

- [Instructor] Let's learn how to work with Excel functions.…We'll use Excel as a tool to help illustrate…and understand statistical concepts.…Before we turn to Excel's statistical capabilities,…let's look at some simple Excel functions.…Here in this spreadsheet column E is labeled X,…column F is labeled Y, and column G is labeled X minus Y.…The third column will hold the difference…between the numbers in each X Y pair.…Let's start with the sum of the X's.…Click in cell E13 and here's where we'll insert…the sum of all the X numbers.…

We can do this in a couple of ways.…Here's the first way.…Click on the Formulas tab and then on…the Math and Trig icon.…Scroll down until you find the function S-U-M.…And that opens the Sum dialog box.…In the numbers box, Excel has guessed the numbers to add.…Now we have to correct because we want to add…numbers in cells E2 through E11.…After those numbers in the Number one box, click Okay.…

And there's the sum in cell E13.…The formula bar shows equals sum and in parentheses…the numbers we added.…

Resume Transcript Auto-Scroll

Author

Updated

6/2/2016

Released

12/23/2015

Understanding statistics is more important than ever. Statistical operations are the basis for decision making in fields from business to academia. However, many statistics courses are taught in cookbook fashion, with an emphasis on a bewildering array of tests, techniques, and software applications. In this course, part one of a series, Joseph Schmuller teaches the fundamental concepts of descriptive and inferential statistics and shows you how to apply them using Microsoft Excel.

He explains how to organize and present data and how to draw conclusions from data using Excel's functions, calculations, and charts, as well as the free and powerful Excel Analysis ToolPak. The objective is for the learner to fully understand and apply statistical concepts—not to just blindly use a specific statistical test for a particular type of data set. Joseph uses Excel as a teaching tool to illustrate the concepts and increase understanding, but all you need is a basic understanding of algebra to follow along.