Skip main navigation

Sigma Notation Part 4

Now I want to walk through another example of the principle I’ve just been saying, which is that we apply order of operations within those parentheses for your sigma notation. So I have two examples here that are very similar but are, in fact, a little bit different. On the top, I have the sum of 2x squared. On the bottom, I have the sum of 2x, in parentheses, squared. So let’s walk through how we would apply order of operations for these two examples. For the sum of 2x squared, I have to follow my order of operations within that parenthesis, so exponents then multiplication. So in other words, I have to square every age first and then multiply by 2.
And then I can sum. So it would look like this– 2 times 30 squared, 2 times 21 squared, et cetera. I have to do that, because I have to exponent before I can multiply. So that’s going to then turn into this, which will then sum to 13,694. This is a basic application of the order of operations within sigma notation. But let’s see what happens if I nest some other parentheses inside my parentheses. In this example, I have 2x parentheses squared. I’ve added those inner parentheses to tell you, you have to do the 2x first. So I’m forcing you to multiply every age by 2 first. And then you can apply that exponent.
So now I’m going to say you have to do 2 times 30. And then whatever that is, square it. And I’m going to do that for all of my ages. So keep in mind, we can have nested parentheses. And again, it might look intimidating. But those nested parentheses are just an instruction to do whatever that thing is first. So in this case, now I’m going to multiply everything times 2 and square it and add it up. It gives you a different result, which is exactly the point. I’m going to give you specific instructions to do whatever it is I need you to do.
From here, we have the basic things we need to do to build our statistical formulas with sigma notation. So let’s go ahead and see how we might apply this for some statistical formulas.

Lab: Sigma Notation

Sigma notation is the basic building block for creating a lot of different analytics formulas. In this lab, we’ll practice using our new favorite Greek letter to build simple formulas by hand and with Excel.

The lab instructions can be downloaded as a PDF file here.

The data set for this lab can be viewed here. From the link, copy and paste all the data into a new worksheet in Excel Online.

Lab Check Once you have completed the Sigma Notation Lab, answer the following question. Capture73

This article is from the free online

Essential Mathematics for Data Analysis in Microsoft Excel

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education