Tutor profile: Sam N.

You have a table with lots of data that you want to sort and be able to look at in different ways. What tool in Excel would you use to summarize this data?

A pivot table allows you to summarize data quickly as well as quickly change the dimension of the data you are looking at.

If your grandma bakes you a pie, and your brother eats half (1/2) of the pie. How many quarters of the pie are left?

We know that we started with a whole pie (1) and that there are 2 halves in a pie. There are also 4 quarters in a whole pie. Next we need to find how many quarters your brother ate. There are 2 quarters in a half so your brother ate 2 quarters of the pie. This means that there are 4-2=2 quarters of the pie left! One for you and one for grandma.

Assuming that height is normally distributed and that the average height for males in the US is 5 feet 10 inches with a standard deviation of 4 inches, how likely is it that if you picked a random man in the US that he would be taller than 6 feet 2 inches?

We know that the average male in the US is 70 inches tall (5 feet X 12 inches/foot + 10 inches) and that the cutoff in question is 74 inches tall (6 feet X 12 inches/foot +2 inches). To answer this sort of question we are going to use a standard normal distribution table (or calculator, but I got my answer using a table). First we need to find the Z-Score, to do this we take (Observation-Average)/Standard Deviation, so (74 inches-70 inches)/(4 inches). This works out to 1.00. Next, we go to the normal distribution table and find the number associated with a Z-Score of 1.00, this is 0.84134. We're not quite done yet though because the question is asking what the probability is that the randomly selected man is TALLER than 6 feet 2 inches. The number we found from the table is the probability that a randomly selected man is shorter than 6 feet 2 inches. So to find our answer, we take 1-0.84134. This gives us our answer of 0.15866 or 15.87%