Excel Graphing
.docx
keyboard_arrow_up
School
Xavier University *
*We aren’t endorsed by this school
Course
160
Subject
Biology
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by DeaconGuanaco3910
Excel Graphing Basics & Statistical
Analysis Name: Grace Heringer
Section:
Instructions: Use Excel to make appropriate graphs for the following sets of data. Copy and paste your completed graphs back in this document. Remember: You need to select the appropriate type of graph, make
sure the Y and X axis are properly labeled, give a graph title and a figure legend (if needed). Then complete the questions around statistical analyses. (18 pts total)
Reading Assignment: Read sections 5.2 - 5.5 in Writing in The Biological Sciences.
Watch this video tutorial (
https://app.vidgrid.com/view/q5HYeWdhW1bJ/?sr=LRBR757qqS6V
) before beginning.
DATA SET 1: This lab conducted a research project to compare how air pollution in 2020 compared to 2019. The purpose is to see if the global pandemic affected pollution. Pollution is measured as the number of pollutant molecules suspend in the air per million molecules sampled or (ppm). The data below is looking at the monthly average.
Jan 2019 = 10ppm Jan 2020 = 11ppm
Feb 2019 = 8ppm Feb 2020 = 10ppm
March 2019 = 14ppm March 2020 = 11ppm
April 2019 = 16ppm April 2020 = 12ppm
May 2019 = 30ppm May 2020 = 16ppm June 2019 = 89ppm June 2020 = 20ppm
July 2019=102ppm July 2020 = 45ppm
DATA SET 2: A research group has developed a new disinfectant called Ridex. To test the efficiency of the chemical they measure how many live bacteria they recovered after treating a bacteria laced surface with the chemical for 2 minutes. Ridex was tested against 2 different bacteria species, E. coli and S. epidermidis
. For comparison the also repeated the experiment by treating the bacteria with Clorox (positive control) or with water (negative control). E. coli treated with water = 2400 live bacteria E. coli treated with Clorox = 400 live bacteria
E. coli treated with Ridex = 300 live bacteria
S. epidermidis treated with water = 2400 live bacteria
S. epidermidis treated with Clorox = 200 live bacteria
S. epidermidis treated with Ridex = 40 live bacteria
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
i need help with how to write out the formulas and how to get the exact graph here's the photo. please help
arrow_forward
Horizontal sequence :VIRL
Vertical sequence:MKF
Scoring rules: g/o = -3, g/e = -1, match or mismatch - from PAM250 substitution matrix below.
SW algorithm.
1. Complete the scoring matrix.
Scoring matrix with PAM250 scores:
V
I
R
L
M
K
F
2. Set up, initialize and complete the SW matrix.
3. Retrace, align and score alignment(s).
Use the arrows and circles for the matrix and path(s).
V
I
R
L
M
K
F
Align and score all optimal alignments here.
PLZ the arrows and circles for the matrix and path(s) AND SHOW ALL possible Alignment
arrow_forward
Horizontal sequence :VIRL
Vertical sequence:MKF
Scoring rules: g/o = -3, g/e = -1, match or mismatch - from PAM250 substitution matrix below.
SW algorithm.
1. Complete the scoring matrix.
Scoring matrix with PAM250 scores:
V
I
R
L
M
K
F
2. Set up, initialize and complete the SW matrix.
3. Retrace, align and score alignment(s).
Use the arrows and circles for the matrix and path(s).
V
I
R
L
M
K
F
Align and score all optimal alignments here.
arrow_forward
In paragraph form, you should describe what you found. This is not the place to interpret results, save that for the conclusion.
your narrative explanation of your results should refer to the figures. These figures should be numbered(even if there's only one) and display summary data(mean and error), not raw data. The figure caption should be in the text under each figure and briefly describe what you're showing.
THANK YOU!
arrow_forward
Discuss about Fluorescencemicroscopy
arrow_forward
Is it possible to determine Km and Vmax without using excel? Because we are not allowed to use computer during exam, so I dont understand how its done without using excel?
arrow_forward
Recyc
FOR
7
Forg
Emp
Micro
Ed
← C
Mc
Graw
Hill
60°F
Clear
Piedmont Technical College
Multiple Choice Question
https://learning.mheducation.com/static/awd/index.html?_t=1680067
0000000000000000000000000000 0000000000000 of 41 Concepts completed
X
The nervous system directly controls
O blood cells and hair growth
O bone growth
O muscles and glands
M Question Mode: Multiple Choice X
EE Read About the Concent
Need help? Review these concept resources.
Rate your confidence to submit your answer. High
i
Medium
+
O Search
2023 McGraw Hill All Dighte Doceniod
LC
arrow_forward
Use Dimensional Analysis
arrow_forward
Lifespan development science has two primary research designs – longitudinal and cross-sectional. Explain each of them, discussing the strengths and limitations of each. Explain how these two designs can be combined for a third research strategy – cross-sequential design.
arrow_forward
I am struggling with drawing and annotating of dissected sheep's heart. I would like to see how experts draw and annotate sheep heart and answer the questions.
arrow_forward
Do the whole question. Please they are attached an image.
arrow_forward
Name:
Instructor:
0
Measurements with a Meter Stick
0 cm
Read and Record the length in centimeters and in meters in the blanks provided.
اساساً
Online Lab: Measurement
0 cm
0 cm
10 Made in Chicago 20
Zoomed In Edges of Block
10 Made in Chicago 20
Zoomed In Edges of Block
10 Made in Chicag 20
Date:
Zoomed In Edges of Block
Developed by Melissa Butner, ETSU
30 Prof North and 40
31
Section:
30 Property of North G40
28
30 Property of North Grand H 40
37
32
29
Record cm here:
Record m here:
Record cm here:
Record m here:
Record cm here:
Record m here:
11
11
1
arrow_forward
match with reason
arrow_forward
Tools Overview: Provide a brief summary of the key company-approved tools, represented by those used in the lab exercises. In your summary, identify the importance of and rationale for selecting these tools.
arrow_forward
please help, these ARE NOT GRADED SO DONT REJECT THEM, they are practice problems.
arrow_forward
Each of you will need to read "What is Plyometrics'
1.Can you use plyometrics with an aging adult? Why or why
not
2. What is plyometrics a synonym for? (hint not jump training-
not all plyometrics involves jumping)
3. What is one benefit you (yourself) could use from plyometric
training?
4. What are at least 2 important factor an individual must
possess before incorporating plyometric drills?
5. What are the 3 distinct phases utilized in plyometric training?
6.Name one lower body plyometric exercise and one upper
body exercise.
arrow_forward
Bio Mechanics & Ergonomics - II
Qno1) A 45 years old patient comes to you with chief complain of neck pain along with stiffness and the pain radiate to the right shoulder and arm. The patient also complained of headaches at the back of the head just above the neck and travel over the top to the forehead. On Further examination it was noticed that the frequency of the pain increased by cervical movement but the severity of the pain is increasing more by looking up to the ceiling the pain is not relieved by any kind of Rest. The previous history of the patient showed that 3 years back he was involved in major car accident.
3)What major changes in cervical spine can be visible on Xray or RMI?
arrow_forward
37.
The presence of too many ____ retrieval cues can negatively impact test performance; whereas the presence of many ____ retrieval cues can only positively impact test performance.
Group of answer choices
External; recognition
Internal; external
External; internal
Disorganized; organized
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Case Studies In Health Information Management
Biology
ISBN:9781337676908
Author:SCHNERING
Publisher:Cengage
Understanding Health Insurance: A Guide to Billin...
Health & Nutrition
ISBN:9781337679480
Author:GREEN
Publisher:Cengage
Related Questions
- i need help with how to write out the formulas and how to get the exact graph here's the photo. please helparrow_forwardHorizontal sequence :VIRL Vertical sequence:MKF Scoring rules: g/o = -3, g/e = -1, match or mismatch - from PAM250 substitution matrix below. SW algorithm. 1. Complete the scoring matrix. Scoring matrix with PAM250 scores: V I R L M K F 2. Set up, initialize and complete the SW matrix. 3. Retrace, align and score alignment(s). Use the arrows and circles for the matrix and path(s). V I R L M K F Align and score all optimal alignments here. PLZ the arrows and circles for the matrix and path(s) AND SHOW ALL possible Alignmentarrow_forwardHorizontal sequence :VIRL Vertical sequence:MKF Scoring rules: g/o = -3, g/e = -1, match or mismatch - from PAM250 substitution matrix below. SW algorithm. 1. Complete the scoring matrix. Scoring matrix with PAM250 scores: V I R L M K F 2. Set up, initialize and complete the SW matrix. 3. Retrace, align and score alignment(s). Use the arrows and circles for the matrix and path(s). V I R L M K F Align and score all optimal alignments here.arrow_forward
- In paragraph form, you should describe what you found. This is not the place to interpret results, save that for the conclusion. your narrative explanation of your results should refer to the figures. These figures should be numbered(even if there's only one) and display summary data(mean and error), not raw data. The figure caption should be in the text under each figure and briefly describe what you're showing. THANK YOU!arrow_forwardDiscuss about Fluorescencemicroscopyarrow_forwardIs it possible to determine Km and Vmax without using excel? Because we are not allowed to use computer during exam, so I dont understand how its done without using excel?arrow_forward
- Recyc FOR 7 Forg Emp Micro Ed ← C Mc Graw Hill 60°F Clear Piedmont Technical College Multiple Choice Question https://learning.mheducation.com/static/awd/index.html?_t=1680067 0000000000000000000000000000 0000000000000 of 41 Concepts completed X The nervous system directly controls O blood cells and hair growth O bone growth O muscles and glands M Question Mode: Multiple Choice X EE Read About the Concent Need help? Review these concept resources. Rate your confidence to submit your answer. High i Medium + O Search 2023 McGraw Hill All Dighte Doceniod LCarrow_forwardUse Dimensional Analysisarrow_forwardLifespan development science has two primary research designs – longitudinal and cross-sectional. Explain each of them, discussing the strengths and limitations of each. Explain how these two designs can be combined for a third research strategy – cross-sequential design.arrow_forward
- I am struggling with drawing and annotating of dissected sheep's heart. I would like to see how experts draw and annotate sheep heart and answer the questions.arrow_forwardDo the whole question. Please they are attached an image.arrow_forwardName: Instructor: 0 Measurements with a Meter Stick 0 cm Read and Record the length in centimeters and in meters in the blanks provided. اساساً Online Lab: Measurement 0 cm 0 cm 10 Made in Chicago 20 Zoomed In Edges of Block 10 Made in Chicago 20 Zoomed In Edges of Block 10 Made in Chicag 20 Date: Zoomed In Edges of Block Developed by Melissa Butner, ETSU 30 Prof North and 40 31 Section: 30 Property of North G40 28 30 Property of North Grand H 40 37 32 29 Record cm here: Record m here: Record cm here: Record m here: Record cm here: Record m here: 11 11 1arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Case Studies In Health Information ManagementBiologyISBN:9781337676908Author:SCHNERINGPublisher:Cengage
- Understanding Health Insurance: A Guide to Billin...Health & NutritionISBN:9781337679480Author:GREENPublisher:Cengage
Case Studies In Health Information Management
Biology
ISBN:9781337676908
Author:SCHNERING
Publisher:Cengage
Understanding Health Insurance: A Guide to Billin...
Health & Nutrition
ISBN:9781337679480
Author:GREEN
Publisher:Cengage