Thus, I thought my heart rate within six weeks should not change significantly. Kenneth Cooper, the aerobic training effect could be achieved within six weeks. I measured my heart rate upon waking up (measuring at this time ensures that I am well rested) during each of my three-times a week aerobics sessions.Īccording to Dr. I will use the Student’s t-test to analyze 18 readings taken eight months ago and the last six weeks as data for comparison.
Statistical Question: Is there a significant difference in heart rate eight months ago and last six weeks’ record? Now, I would like to answer the statistical research question I formulated below: I did not test whether there is a significant difference in my heart rate, from the time I started measuring my heart rate compared to the last six weeks’ data. In that article, I used the graphical method to plot a trend line. Thus many athletes have lower resting heart beats per minute than non-athletes.
In my earlier post titled How to Slow Down Your Heart Rate Through Aerobics, I mentioned that my heart rate is getting slower over time because of aerobics training. This statistical analysis aims to test whether there is a significant difference in my heart rate eight months ago and last week. Using the Data Analysis ToolPak to Analyze Heart Rate Data
Instruction on how to install the MS Excel Analysis ToolPak. You should now see the Data Analysis function at the extreme right of your Data menu in your spreadsheet. Choose Excel Add-in in the Manage field below left, then hit Go,.Look for the Excel Options menu at the bottom right of the box and click it,.Click on the Office Button (that round thing at the uppermost left of the spreadsheet),.You can activate the Data Analysis ToolPak by following the procedure below (this could vary between versions of MS Excel this one’s for MS Office 2007) or view the video tutorial detailing the steps on how to install it. It will automatically install if the necessary files come with the computer. You may also try activating the Analysis Toolpak of MS Excel if your windows computer comes as a package upon laptop or desktop purchase. Ensure that you have placed your original MS Office DVD in your DVD drive upon doing the next steps. To make use of this nifty tool that the not-so-discerning fail to discover, you will need to install it as an Add-in to your existing MS Excel installation. The Data Analysis Toolpak in MS Excel sits right there for your disposal when faced with an assignment in statistics, data to analyze in the office, or personal use to understand things that matter to you. All of these uses apply to me. Using the Data Analysis ToolPak to Analyze Heart Rate Data.