# Excel Week 1 Worksheet

.docx
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.