Tutorial-3-Sheets-Standard-Error-Confidence-Interval * @ @ File Edit View Insert Format Data Tools Extensions Help Y- 100% @ View only - G21 D G H K L M N 0 1 Petri Dishes Dark (x1) (mm) Light (x2) (mm) 2 1 and 2 12 18 3 3 and 4 22 4 5 and 6 15 17 7 and 8 13 23 Calculate the mean of the light data 9 and 10 6 16 (C2:09) in C13. 11 and 12 4 18 Calculate the standard deviation of 8 13 and 14 13 22 9 15 and 16 14 12 the light data (C2:09) in C14. 10 Calculate the sample size for the 11 light data using the =COUNT 12 function in C15. Use the formula 13 Mean 10.625 for the standard error found in B16 14 Standard Deviation 4.068608046 to calculate the standard error of 15 Sample Size the light data. 16 dard Error of the Mean 1.43847017 Use the formula for in B17 to 17 Confidence Interval 2.819401532 calculate the confidence interval 18 19 20 21 22 23 Standard Error of the Mean is calculated 24 by: 25 ( Standard deviation / Vn) 26 27 95% confidence interval is calculated by: 28 (1.96 * Standard Error of the Mean). To 29 obtain the actual interval, add or subtract 30 this number to the mean. 31 32 33 Click on B13 through B17 to see the 34 formulas that should be used to calculate 35 these essential descriptive statistics. Read This First - Standard Error and Cl Bar Graph Bar Graph 2 Error Bars Error Bars 2 Exercisevbg/edit#gid=211 Tutorial-3-Sheets-Standard-Error-Confidence-Interval # @ @ File Edit View Insert Format Data Tools Extensions Help $ Y - 100% View only 22 E F G H 1977 Beak Depth (mm1978 Beak Depth (mm) 8.30 9.80 Directions to Complete Google Sheets Tutorial 3 Quiz, Part 2 7.50 8.50 8.00 10.30 1. Columns G and H contain data for beak depth from ground finches sampled in 1977 and 10.60 9.90 1978. Calculate the mean, the standard deviation, the sample size (count), the standard 11.20 8.80 error of the mean and the 95% confidence interval for each sample, showing the values 9.10 10.10 in D30:E34. 9.50 3.20 2. Create a column graph comparing the 1977 data and 1978 data using the skills that you 10.50 13.00 10 learned in this Tutorial. To start the graph, highlight the information in cells D31, D32, 8.40 8.90 E31 and E32. Then under Insert, select Chart. 8.60 9.10 3. Check that only the box shown below is checked under Setup, or you may have the 9.20 9.80 wrong graph or may not be able to see your legend. 8.80 10.10 Switch rows / columns 8.50 8.55 8.00 9.30 Use row 29 as headers 9.70 10.00 0 Use column D as labels 8.40 10.70 7.90 9.10 9.30 8.80 4. Add error bars showing the confidence interval for each sample. Make sure that your 7.70 10.40 graph includes a figure legend with each treatment identified (for example, 1977 Beak 8.50 10.70 Depth and 1978 Beak Depth). Also, your graph needs to include a vertical axis title. 8.20 9.15 5. To make a PDF of this page that you can upload to Blackboard, click on "File" at the top 9.70 11.20 of the page and select "Download" and "PDF Document". A new page will then open. 10.30 10.50 Make sure that under Export it says "current sheet" and then click "Export". Save the 10.20 9.70 PDF file that you created. 8.90 8.90 6. Go to Prelab assignments on the Blackboard page and click on "Google Sheets Tutorial 3, 9.60 10.10 part 2" to upload the PDF that you created. 9.20 12.00 9.60 9.60 9.80 8.50 1977 Beak Depth (mm) 1978 Beak Depth (mm) 8.80 10.08 32 9.00 9.45 Mean 8.31 33 9.10 Standard Deviation 34 Sample Size 9.20 9.80 35 8.80 9.70 Standard Error of the Mean 36 9.20 10.38 Confidence Interval Read This First Standard Error and Ci Bar Graph Bar Graph 2 Error Bars Error Bars 2 - Exercise