When I first opened the Excel page "Raw Data" I was overwhelmed. There were so many rows and columns filled with numbers. At a first glance, there is no telling what it all could possibly mean. However, I really learned during this project that Microsoft Excel can take such a large amount of data and truly make it manageable - in other words - simply make sense. I was able to really dissect the data in a real world scenario. I created a formula for the highest heart rate achieved from the data using the MAX formula. In addition, in order to create a target heart rate using the number specified, 80 percent, I had to use absolute addressing in the formula to create the target heart rates for all the subjects. The pivot tables were an excellent way to show the data to the fitness center's owner is a visible fashion. I dissected the data according to who achieved and did not achieve their target heart rate, specifying between male and female.
Overall, the project was a great learning experience, and I definitely see all the real world application Excel has.
No comments:
Post a Comment