Class Notes (806,581)
Canada (492,334)
York University (33,488)
KINE 2049 (75)

KINE 2049 1104 2009.doc

4 Pages
Unlock Document

York University
Kinesiology & Health Science
KINE 2049
Merv Mosher

November 4, 2009 KINE 2049 .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 cause cancer. .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. Syntax 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", respectively. 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. =COUNTIF(fruit,"apples") 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 that. .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 $B$2$B$6. .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. =COUNTIF(Sign_In,Name). .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. =COUNTIF(Letter_Grade,Letters) 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
More Less

Related notes for KINE 2049

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.