Part B: Counting heart beats The worksheet Hear__Beat contains 2 columns of data obtained tom a puise oxmeter sensoc. Co

[answerhappygod]

Part B Counting Heart Beats The Worksheet Hear Beat Contains 2 Columns Of Data Obtained Tom A Puise Oxmeter Sensoc Co 1 (50.94 KiB) Viewed 13 times

please help me completing these questions using the excel spreadsheet

Part B Counting Heart Beats The Worksheet Hear Beat Contains 2 Columns Of Data Obtained Tom A Puise Oxmeter Sensoc Co 2 (50.94 KiB) Viewed 13 times

Part B Counting Heart Beats The Worksheet Hear Beat Contains 2 Columns Of Data Obtained Tom A Puise Oxmeter Sensoc Co 3 (50.94 KiB) Viewed 13 times

Part B Counting Heart Beats The Worksheet Hear Beat Contains 2 Columns Of Data Obtained Tom A Puise Oxmeter Sensoc Co 4 (29.19 KiB) Viewed 13 times

Part B Counting Heart Beats The Worksheet Hear Beat Contains 2 Columns Of Data Obtained Tom A Puise Oxmeter Sensoc Co 5 (50.94 KiB) Viewed 13 times

Part B Counting Heart Beats The Worksheet Hear Beat Contains 2 Columns Of Data Obtained Tom A Puise Oxmeter Sensoc Co 6 (50.94 KiB) Viewed 13 times

Part B Counting Heart Beats The Worksheet Hear Beat Contains 2 Columns Of Data Obtained Tom A Puise Oxmeter Sensoc Co 7 (29.19 KiB) Viewed 13 times

Part B: Counting heart beats The worksheet Hear__Beat contains 2 columns of data obtained tom a puise oxmeter sensoc. Column A contains the times (in seconds) at which the meassrements were taken. Column 8 is the volage (in Volts) measured at the corresponding time in Colurn A. For example, at Row number 16, the data were collected at time 1.45 (Cell A16) with a measured voltage of 1.74 V (Cell B16) In Online Video 6, we counted the number of beass by countring the number of peaks whose value exceeds a threshold In this erercise, you will use a different mefiod to determine the number of heart beats: The first step of data analysis is very chten to plot the dath. Plot the voltage (y-axis) versus time (x-20es) Choose a lne type so that you can see the oscilatory pattern of the heart beats. After plotting the graph, you can see that number of heart beats is fairly large. You can manualy count them (ff you really want to but it is easy to make a mistake. What you realy wart to is to get the conputer to count thern for you Task 1 We will be using a threshold voltage of 3N. We have spectied this value in Cell Hi in this task, you should define a named constant caled Thveshold for Cell H1 in Task 2 you should use the named constant "Threshoid" instead of the value of 3 . This will make the context clearet. Task 2 In this exercise, we will use the downward crossing of a trreshold as the critenon of a heartbeat. Specifically, we whil use - Number of heart beats a number of times the voltage crosses the 3 V threshold and is decreasing In addition. We say a data point is a heart beat it it a the data pont pust before the dowrward erossing of a threshold For example, the following plot shows the voltage from 6 is 595 . The red squares indicate where the heart beats are. For example, the voltages at times 6 is and 66 s are respectively, 3.18 V and 2.14 V. The dowrward crossing of the threshold occurs some time between 655 and 6.65, 50 we say the data point at 655 is a threshold. Smilarly, in the plot beiow, downward crussings of the sreshold occur at 7.25,8.15, 8 9 s and 9.75. For this exercise. you can assume fart a dota poirt will not have the exact value of 3 N The first job that you need to do s to transiate the crhenon 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 exarmple. - For the Cell B67 (wtich corresponds to time 5.55 ) is a heartbeat, so you should fill in E67 with a 1 (number 1, not string 1) - For the Cell B6s (Which corresponds to tete 66s) is not a heartbeat so you should tal in E68 with a 0 (number 0 , not string 0 ) Note that the criterion for determing whether a data point is a heart beat requres two data points, so you will need to pay attention to the last point of the data series. You may find the Excei function isblaric) useful. After you have derived the logical condion, implement in in the worksheet. Note that you may need to put some intermediate calculations in some columns it is atways a good practice to check what you have derived is correct. Please do so. You are asked to provide the followng answers in the spreadsheet. - In Cells E2 to E 601, you should indicate whether the conesponding data point in Column B is a heart beat or not.
E12 in N f
Part B: Counting heart beats The worksheet Hear_Beat contains 2 columns of data obtained tom a puise oxmeter sensoc. Column A contains the times (in seconds) at which the meassrements were taken. Column 8 is the volage (in Volts) measured at the corresponding time in Colurn A. For example, at Row number 16, the data were collected at time 1.45 (Cell A16) with a measured voltage of 1.74 V (Cell B16) In Online Video 6, we counted the number of beass by countring the number of peaks whose value exceeds a threshold In this erercise, you will use a different mefiod to determine the number of heart beats: The first step of data analysis is very chten to plot the dath. Plot the voltage (y-axis) versus time (x-20es) Choose a lne type so that you can see the oscilatory pattern of the heart beats. Afer plotting the graph, you can see that number of heart beats is fairly large. You can manualy count them (ff you really want to but it is easy to make a mistake. What you realy wart to is to get the conputer to count thern for you Task 1 We will be using a threshold voltage of 3N. We have spectied this value in Cell Hi in this task, you should define a named constant caled Thveshold for Cell H1 in Task 2 you should use the named constant "Threshoid" instead of the value of 3 . This will make the context clearet. Task 2 In this exercise, we will use the downward crossing of a trreshold as the critenon of a heartbeat. Specifically, we whil use - Number of heart beats a number of times the voltage crosses the 3 V threshold and is decreasing In addition. We say a data point is a heart beat it it a the data pont pust before the dowrward erossing of a threshold For example, the following plot shows the voltage from 6 is 595 . The red squares indicate where the heart beats are. For example, the voltages at times 6 is and 66 s are respectively, 3.18 V and 2.14 V. The dowrward crossing of the threshold occurs some time between 655 and 6.65, 50 we say the data point at 655 is a threshold. Smilarly, in the plot beiow, downward crussings of the sreshold occur at 7.25,8.15, 8 9 s and 9.75. For this exercise. you can assume fart a dota poirt will not have the exact value of 3 N The first job that you need to do s to transiate the crhenon 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 exarmple. - For the Cell B67 (wtich corresponds to time 5.55 ) is a heartbeat, so you should fill in E67 with a 1 (number 1, not string 1) - For the Cell B6s (Which corresponds to tete 66s) is not a heartbeat so you should tal in E68 with a 0 (number 0 , not string 0 ) Note that the criterion for determing whether a data point is a heart beat requres two data points, so you will need to pay attention to the last point of the data series. You may find the Excei function isblaric) useful. After you have derived the logical condion, implement in in the worksheet. Note that you may need to put some intermediate calculations in some columns it is atways a good practice to check what you have derived is correct. Please do so. You are asked to provide the followng answers in the spreadsheet. - In Cells E2 to E 601, you should indicate whether the conesponding data point in Column B is a heart beat or not.
E12 in N f