0	3.37
0.1	2.39
0.2	2.24
0.3	1.83
0.4	1.62
0.5	1.74
0.6	1.78
0.7	4.06
0.8	4.26
0.9	2.52
1	2.29
1.1	2.04
1.2	1.72
1.3	1.75
1.4	1.74
1.5	3.46
1.6	4.26
1.7	2.62
1.8	2.13
1.9	2.05
2	1.77

threshold = 3

how to show if it's a heartbeat or not?

need to use if function in excel to calculate the number of heartbeats.

Task 2 In this exercise, we will use the downward crossing of a threshold as the criterion of a heartbeat. Specifically, we will use: Number of heart beats = number of times the voltage crosses the 3V threshold and is decreasing In addition, we say a data point is a heart beat if it is the data point just before the downward crossing of a threshold. For example, the following plot shows the voltage from 6s to 9.9s. The red squares indicate where the heart beats are. For example, the voltages at times 6.5s and 6.65 are, respectively, 3.18V and 2.14V. The downward crossing of the threshold occurs some time between 6.55 and 6.65, so we say the data point at 6.5s is a threshold. Similarly, in the plot below, downward crossings of the threshold occur at 7.25, 8.Is, 8.98 and 9.7s. For this exercise, you can assume that a data point will not have the exact value of 3V. Pulse oximeter Time The first job that you need to do is to translate the criterion of determining whether a data point is a heart beat into a logical condition. You are asked to indicate whether is data point is a heart beat in the corresponding row in Column E. For example, . For the Cell B67 (which corresponds to time 6.5s) is a heartbeat, so you should fill in E67 with a 1 (number 1, not string 1). For the Cell B68 (which corresponds to time 6.65) is not a heartbeat, so you should fill in E68 with a 0 (number 0, not string 0). Note that the criterion for determining whether a data point is a heart beat requires two data points, so you will need to pay attention to the last point of the data series. You may find the Excel function isblank() useful. After you have derived the logical condition, implement it in the worksheet. Note that you may need to put some intermediate calculations in some columns. It is always a good practice to check what you have derived is correct. Please do so. You are asked to provide the following answers in the spreadsheet: In Cells E2 to E 601, you should indicate whether the corresponding data point in Column B is a heart beat or not. In Cell H3, you should provide the number of heart beats. Task 2 In this exercise, we will use the downward crossing of a threshold as the criterion of a heartbeat. Specifically, we will use: Number of heart beats = number of times the voltage crosses the 3V threshold and is decreasing In addition, we say a data point is a heart beat if it is the data point just before the downward crossing of a threshold. For example, the following plot shows the voltage from 6s to 9.9s. The red squares indicate where the heart beats are. For example, the voltages at times 6.5s and 6.65 are, respectively, 3.18V and 2.14V. The downward crossing of the threshold occurs some time between 6.55 and 6.65, so we say the data point at 6.5s is a threshold. Similarly, in the plot below, downward crossings of the threshold occur at 7.25, 8.Is, 8.98 and 9.7s. For this exercise, you can assume that a data point will not have the exact value of 3V. Pulse oximeter Time The first job that you need to do is to translate the criterion of determining whether a data point is a heart beat into a logical condition. You are asked to indicate whether is data point is a heart beat in the corresponding row in Column E. For example, . For the Cell B67 (which corresponds to time 6.5s) is a heartbeat, so you should fill in E67 with a 1 (number 1, not string 1). For the Cell B68 (which corresponds to time 6.65) is not a heartbeat, so you should fill in E68 with a 0 (number 0, not string 0). Note that the criterion for determining whether a data point is a heart beat requires two data points, so you will need to pay attention to the last point of the data series. You may find the Excel function isblank() useful. After you have derived the logical condition, implement it in the worksheet. Note that you may need to put some intermediate calculations in some columns. It is always a good practice to check what you have derived is correct. Please do so. You are asked to provide the following answers in the spreadsheet: In Cells E2 to E 601, you should indicate whether the corresponding data point in Column B is a heart beat or not. In Cell H3, you should provide the number of heart beats