November 4, 2009
.Professor discussing getting the Swine Flu Shot - showing email of why
it may not be a good idea to get the shot.
.Professor said it would be a good idea to check out this Dr. Blaylock to
see if he is legitimate.
.He was in the military in 1976.
.Professor said maybe he is trying to scare you to get into vitamins to
avoid the Swine Flu Shot.
.It is an urban myth buster site.
.If you have something that you have heard that is circulating and it
will tell you whether it is legitimate or not.
.Professor entered Blaylock's name.
.He is also anti-aspartame which is an artificial sweetener that could
.Last class doing Nested IF statements.
.Let's suppose you want to write a nested If statement.
.Logical test =IF(B3>100,"....professor changed slides.
COUNTIF Function (for Lab 7)
.The COUNTIF Function allows us to figure out how many of a certain items
are found in a list of items.
.Suppose in your business that you funded you sell product nutrition bars
and they come in a number of flavours and at the end of each week you
need to do an inventory.
.Syntax for COUNTIF
Counts the number of cells within a range that meet the given criteria.
COUNTIF (range, criteria)
Range - is the range of cells from which you want to count cells.
Criteria-is the criteria in the form of a number, expression, or text
that defines which cells will be counted. For example, criteria can be
expressed as 32, "32", >"32", "applies".
Page 1 of4 Examples
Suppose A3 A6 contains "apples', "oranges", "peaches", "apples",
COUNTIF A3:A6"apples") equals 2
Suppose B3:B6 contain 32, 54, 75, 86, respectively:
COUNTIF (B3:B6,">55") equals 2.
.In lab 7 here is an experiment that you need to run.
.You need to toss two die one thousand times.
.In the real world this would take time.
.In excel you can do this very quickly and you can record what turns up.
.Going back to do inventory and list of products - nutrition bars.
if he did not name it as fruit then he would have to say B2:B6 - case
sensitive matters you do have to make sure that you type it properly.
.This function checks the entire column looking for the column apples.
.On an exam you would get it wrong if you selected this answer as you
cannot drag and fill it down.
.It will give you the number of apples.
Suppose he had said B2:B6 and he dragged that down - what answer will
appear? One answer will appear.
.This formula will change it will be B3:B7 and there is only one apple in
.Because it is not absolute it will change.
What can he do to fix this?
.He can use
=COUNTIF(FRUIT, D3) when he drags that formula down it becomes D4.
.If he did not use a name variable he would need to write absolute value
.Suppose you are writing a fitness centre and you want to keep track of
how many times that people come to the centre.
.You ask them to sign in on worksheet.
.You now want to count the number of times they show up for training.
.He has 5 clients and he wants to count how many times their names shows
up on that list.
.At the end of term professor has 757 students in this class the
university needs to know how many A+, B+ etc.
using the COUNTIF function.
Page 2 of4 .Name the two columns the previous slide Letter Grade.
.You want to look up each of these letters you drag and fill it down and
it instantly tells you how many students got this letter grade.
.In a previous example how would you count apples and pears