Greetings-
I am currently (attempting) to chart normal distribution for a series of triathlons. I was able to manipulate all of the data to my liking, but setting up the formulas for the z-scores of 9 different times (time of swim, pace of swim, z score of swim, time of transition between swim and cycle, you get the picture) is a lot of work. Seeing that I have 20 races to analyze in the same fashion, I would like to be able to utilize my pre-existing chart as a template in which to simply copy the data of alternate races. However, while the columns are situated consistantly, there are a varied number of contestants in each race (anywhere from 20 to 150). The STANDARIZE, STDEVP, NORMDIST functions all require an absolute reference to the AVERAGE &/or to the STDEVP. How can I set up the worksheet so that when I enter the new times/pace/rate excel automatically inserts the AVERAGE & STDEVP functions into the appropriate row relative to the size of the range (2 rows following the last cell in a range) and use this value to calculate that same range? In other words, how can I place an absolute value into a relative cell and still place it into a function?