Table activity 2: Data Entry and Organization
Download "Lab notebook page with data.pdf" which simulates a laboratory notebook page with the data for you to enter into your spreadsheet.
Use Microsoft Excel (provided by the university) to enter the data into columns with accurate column headers (an example is provided below).
Look at the data and see if there are any apparent patterns. Answer the questions below.
Make a Table which uses the formulas in excel to calculate some summary statistics about the data (see mini-lecture if you don't know how to do this already).
Questions to address (it is helpful if you make your answers a different color or font than the question):
Look at the data and see if there are any apparent patterns. What is your initial impression based on just observing the values?
What are the ranges for the count of colonies of each category of room?
How do bathrooms and classrooms appear to compare in the number of colonies cultured from swabbing each?
What kind of variable is "type of room"? Review from earlier in the semester the variable types if needed (e.g. categorical, numeric, etc.)
What kind of variable is "number of colonies"? Review from earlier in the semester the variable types if needed (e.g. categorical, numeric, etc.)
Student Lab notebook: Bathroom vs Classroom Colony Counts, June 1, 2021.
Count of bacterial colonies per plate streaked from each room. Rooms were selected at random and swabbed over different surfaces. Swab was rubbed on LB agarose plate and cultures were allowed to grow at 37°C overnight. Plate was observed at low magnification under a dissecting scope and each colony was counted.
Classrooms:
Plate number Plate C1 Plate C2 Plate C3 Plate C4 Plate C5 Plate C6 Plate C7 Plate C8 Plate C9 Plate C10 Plate C11 Plate C12 Plate C13 Plate C14 Plate C15 Plate C16 Plate C17 Plate C18 Plate C19 Plate C20 Plate C21 Plate C22 Plate C23 Plate C24 Plate C25 Plate C26 Plate C27 Plate C28
Colony Number 87 90 108 110 69 79 66 112 67 103 88 96 62 61 65 114 80
Student Lab notebook: Bathroom vs Classroom Colony Counts, June 1, 2021.
Plate B38 Plate B39 Plate B40 Plate B41 Plate B42
Colony Number 104 114 94 99 84 97 66 117 96 72 68 91
50 38 15 6 36 28
Plate number Plate C29 Plate C30 Plate C31 Plate C32 Plate C33 Plate C34 Plate C35 Plate C36 Plate C37 Plate C38 Plate C39 Plate C40 Plate C41 Plate C42 Plate C43 Plate C44 Plate C45 Plate C46 Plate C47 Plate C48 Plate C49 Plate C50
Bathrooms:
Number of Treatment 1 Colonies Plate B1 16 Plate B2 Plate B3 68 Plate B4 28 Plate B5 26 Plate B6 Plate B7 23 Plate B8 51 Plate B9 20 Plate B10 67 Plate B11 59 Plate B12 50 Plate B13 1 Plate B14 75 Plate B15 74 Plate B16 66 Plate B17 36 Plate B18 14 Plate B19 32 Plate B20 49 Plate B21 13 Plate B22 61 Plate B23 77 Plate B24 37 Plate B25 38 Plate B26 6 Plate B27 11 Plate B28 17 Plate B29 31 Plate B30 64 Plate B31 14 Plate B32 42 Plate B33 29 Plate B34 22 Plate B35 67 Plate B36 62 Plate B37 16
Plate B44 Plate B45 Plate B46 Plate B47 Plate B48 Plate B49 Plate B50
60 25 24 47
69 110 307 82
117 70 97 81 119 109 76 302 67 105
201 87
