Lab 1 Statistical Graphs (comp)

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.

Tutorial #2: Building Graphs for Categorical Data case # BEWERY 1 Anchor 2 Anheuser Busch 3 Anheuser Busch 4 Adolph Coors 5 Pabst 6 Adolph Coors 7 Anheuser Busch 8 Anheuser Busch 9 Anheuser Busch 10 Anheuser Busch 11 Anheuser Busch 12 Anheuser Busch BEWERY COUNT 13 Anheuser Busch Adolph Coors 8 Other 28 14 Anheuser Busch Anheuser Busch 19 Miller 20 15 Anheuser Busch Boston Beer 4 Anheuser 19 16 G. Heileman Miller 20 Adolph Coo 8 17 G. Heileman Pabst 7 Pabst 7 18 Adolph Coors Other 28 Boston Bee 4 19 Adolph Coors TOTAL 86 20 High Falls Brewing 21 High Falls Brewing 22 High Falls Brewing 23 High Falls Brewing 24 Adolph Coors 25 Miller 26 Miller 27 Miller 28 Miller 29 Adolph Coors 30 Adolph Coors 31 Adolph Coors 32 Leinenkugel 33 Leinenkugel 34 Leinenkugel 35 Leinenkugel 36 Leinenkugel 37 Leinenkugel 38 Leinenkugel 39 Miller 40 High Falls Brewing 41 Anheuser Busch 42 Anheuser Busch 43 Anheuser Busch 44 Anheuser Busch 45 Anheuser Busch 46 Anheuser Busch 47 Anheuser Busch 48 Miller 49 Miller 50 Miller 51 Miller 52 Miller 53 Miller 54 Miller 55 Miller 56 Miller 57 Anheuser Busch 58 Stroh 59 Stroh 60 Miller 61 Pabst 62 Pabst 63 Red Hook 64 Red Hook 65 Latrobe 66 Boston Beer 67 Boston Beer 68 Boston Beer 69 Boston Beer 70 Pabst 71 Pabst 72 Sierra Nevada 73 Sierra Nevada 74 Sierra Nevada 75 Pabst DIRECTIONS: According to an online resource, a focus group identified Coors, Busch, Boston, Miller, and Pabst as the "most popular beer brand in the U.S." Note that the "Other" value is simply the the bewerys not listed above. Below, generate (1) a bar graph (in counts) and (2) a pie chart (in percentages) for the above distribution. Format using the APA guidelines discussed in class. Title your graphs "Most Popular Beer Brand". HINT: For the counts, I recommend using the COUNTIF function. For the "Other" count, try subtracting the sample size from the sum of the above counts. APA Guidelines Reminders Bar Graph - Values must be ordered in decending order from left to right on the graph. You need a title, x-axis lables, y-axis lables. Y-axis must start at zero. Pie Chart - Sectors must be ordered in decending order of size clockwise starting at 12 O'clock. You need a legend, title and percentage labels for each sector. Other Miller Anheuser Busch Adolp h C oors Pabst Boston Beer 0 5 10 15 20 25 30 Most Popular Beer Brands Brewery Count 32.56% 23.26% 22.09% 9.30% 8.14% 4.65% Most Popular Beer Brand Other Miller Anheuser Busch Adolph Coors Pabst Boston Beer

76 Pabst 77 Miller 78 Miller 79 Miller 80 Miller 81 Miller 82 D. G. Yuengling 83 D. G. Yuengling 84 D. G. Yuengling 85 D. G. Yuengling 86 D. G. Yuengling

Tutorial #3: Building a Histogram for Quantitative Data case # CO2 1 2.3 6.5850833905617 2 3.9 3 17.0 4 0.2 5 1.8 6 16.0 7 2.5 8 1.4 9 0.0 10 1.7 11 0.0 12 6.1 13 10.0 14 0.2 15 0.9 16 1.2 17 7.3 18 3.8 19 3.6 20 9.1 21 0.3 22 9.7 23 8.8 24 4.6 25 3.7 26 1.0 27 0.2 28 0.1 29 0.3 30 0.7 31 0.8 32 0.9 33 8.0 34 3.9 35 10.2 36 11.0 37 8.1 38 6.8 39 0.2 40 0.1 41 2.5 42 2.8 43 9.0 44 19.9 45 7.6 46 4.8 47 5.1 48 0.5 Directions: Build a histogram using the CO2 data set provided. The units of the values are "parts per million (ppm)" Use the below worksheet to set up and then create a histogram for the CO_2 levels (units are ppm). Title the histogram "Emissions by Product". Reminder: Use Sturge's rule to determine the number of needed bins. APA Guidelines Reminders You need a title, x-axis lables (w. units), y-axis lables. Y-axis must start at zero. There should be no gaps in the bars. This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.