Excel Project

I really enjoyed doing this excel project. It was for an Exercise Program and the owner wanted to see how effective this program was and who was most effected by it. There were 502 participants and it was for 20mins. To most effectively display the info was to find the heart rates. 1.Max Heart Rate: this was to see what the limit was on how many heart beats could happen per minute according to their age. 2.Targeted Heart Rate: this is where the trainer wanted them to reach and it was calculated as 80% of the max heart rate. 3.Highest Heart Rate: the trainer wanted to see what their highest heart rate achieved was in the 20min interval. 4.Target Achieved: did their highest heart rate reach their targeted heart rate. 5.Percentile Increase of Heart Rate: by what percentage did their heart rate go up by from beginning to their highest heart rate achieved. Each point described above was a new column added to the spreadsheet. They all also had their own formulas. This was the first time I had ever done formulas in excel, so each step was learning something new. I love it!

The owner also wanted to find out how many males and how many females had reached their targeted heart rate and what the average increase was according to their ages. This was done with a Pivot Table. I had never worked with a pivot table before, so I was a little nervous. It just looked a little bit more complex during the lecture. However everything went smoothly, with looking back through my notes and fumbling through the Excel Bible. Below is a screen capture, which I also had never done before, from my pivot table containing the info about the average heart rate increase per male and per female according to the age demographic they fall in.