# Lab 1 Statistical Graphs (comp)

.xlsx
Tutorial #1: Basics of Microsoft Excel AGE(YRS) 30 21 24 23 23 35 23.89474 21 29 28 23 20 19 19 26 4.420844 20 19 19 26 27 21 1st case 30 454 5th case 23 72 46 26.5 9 5 Type in column "G" the example dataset. In row 2 type in the title of the set AGE (YRS) In rows 3-21 type in the dataset: 30 21 24 23 23 25 21 29 28 23 20 19 26 20 19 19 26 27 21 In cell I8 you can compute t of the cases by typing =AVERAGE( highlight the nu wish to compute ) In cell I15 you can compute th deviation age of the cases by =STDEV( highlight the numbe to compute ) In cell I22 you can compute the subjects' ages by typing =SUM( highlight the numbers y compute ) In cell B14 you may verify the sample size of the dataset by using the count function by typing =COUNT( highlight the numbers you wish to compute ) In cell C22 you may call any given observation by simply typing an "equals to" character and selecting the observation you wish. Try this for the first and fifth cases below. e.g. if you wanted to call the 2nd case, your code will look like =G4 In cell D30 you may verify that there are 5 subjects under the age of 21 by using the countif function. Type =COUNTIF( highlight the numbers you wish to compute, condition in quotes ) Use the basic arithmitic symbols (+, -, *, to compute the following: 1. 3rd case * 3 2. 4th case + 5th case 3. The average of the 1st and 5th cases. 4. The difference between the 1st and la cases.