School

Collin County Community College District **We aren't endorsed by this school

Course

BIOM 1100

Subject

Mathematics

Date

Nov 13, 2023

Type

Other

Pages

2

Uploaded by ProfWrenMaster516 on coursehero.com

Name: Shreya Tirumala Kumara
Section Number: 108
BMEN 1100
Excel Week 1 Worksheet
1.
The number changes as you move the active box downward
2.
The letter changes as you move the active box to the right
3.
AA
4.
By right clicking on the "sheet one" at the bottom of the Excel sheet. After
right clicking, select the "rename" option.
5.
The function automatically changes the b2 and b6 into a capital B2 and B6
and calculates the average.
6.
It calculates the sum of column C. Basically it copies the same formula as the
column next to you. Since B7 had the formula to find the sum of B2:B6, then
<Ctrl R> would copy the formula and find the sum of the values listed in
column C.
7.
1,048,576 rows by 16,384 columns
8.
There are a couple of things that are misleading with the graph.
First, there are no axis labels. If someone from outside this
investigation were to look at the graph, they would have trouble
reading the graph since there are no x or y axis labels. Second,
the time where each blood pressure was measured is not
consistent, thus this investigation could have some outliers or
misleading data. If the blood pressure was recorded at
appropriate times and consistent intervals, the results would be
more accurate. Lastly, the real lowest possible blood pressure
in reality is less than the interval that is on the graph (the
real possible blood pressure in reality is ≤ 108). Thus, the
minimum value on the y-axis should be changed to the minimum
bound of 0. The title should also be changed to "Blood Pressure
Throughout the Day" to indicate what we are doing with the blood
pressure.
9.
10.

11.
44.1 psi
12.
1.7 inches
13. 30-35 psi. My source is
https://blog.nationwide.com/recommended-tire-
pressure/
. This site teaches you where to look for tire pressure and how to
tire psi. This site also teaches you how to maintain a good tire psi.
14.
One good study that can be conducted to accurately record heart rate in a
general population is to randomly select individuals from different age
intervals to record their average heart rate. First, from a population we
should segregate everyone's ages into an interval of 5 ages, starting from 18.
(ex. 18-23. 24-29. 30-35. 36-41. 42-47. 48-52. 53-58. 59-64. 65-70 [9 age
intervals]. From this, randomly select 100 individuals to participate in the
study (within that age interval) and record their average heart rate over a day.
This can be done by recording one's heart rate every hour and averaging the
values (there should be 24 values since there are 24 hours in a day). After this,
find the mean of all of the 100 individuals' average heart rate in that age
interval and record it in a table. Repeat this with all 9 age intervals. Lastly,
chart down all of the data on a table and graph the result to compare and
determine how heart rate varies in the general population with age.
15. The independent variable would be the age interval while the dependent
variable would be the average heart rate
16. When you have the results, you should plot the age interval on the x axis ((ex.
18-23. 24-29. 20-35. 36-41. 42-47. 47-52. 53-58. 59-64. 65-70) and the average
heart rate on the y axis.
17.