Excell is there a formula for this

[jwunderdog]

Washington State303161USC4340836-13-9Loyola Marymount283563Cal Santa Barbara4033736-122Louisville273865Cincinnati3936756-122Air Force224264Colorado State3432666-1210Oregon State222951Oregon3429636-120Georgia Tech283260Washington4036766-12-4California354075Arizona4642886-11-2Long Beach State2642977Cal Irvine37316746NC-1111Yale233760Dartmouth3444786-11-7Duquesne303363Dayton4141826-11-8Boise State243256Fresno State3537726-11-5Fairfield192443Michigan3036666-11-12Missouri2633968Oklahoma37226656131-1111Loyola Marymount243155Portland3521566-1110Cal Riverside272956Cal Santa Barbara3731686-10-2Purdue342559Cincinnati4435796136.5-10-10American233154George Mason3331646-100Wisc Green Bay263561Illinois State3635716-100Wichita State202848Mississippi3041716-10-13

If you go to the right I have a string of numbers showing the halftime differential and the second half score differience. I want to get the median for the final score at each half time difference. If you look to the right you see several -11 in a column and them -10. Is there a formula I can use that can pick out eash of the half differences ie -11,-10 and then calculate the medians of the final scores for each of thse differences?

 

[jwunderdog]

well that didn't work!!

-11 6
-11 5
-11 9
-10 8
-10 7
-10 5
etc.

 

[TTinCO]

"Median" is pretty worthless here (I think). Are you sure this is what # you are looking for?

 

[Labeeb]

Jwunderdog,
Contact one of the mods and e-mail me the file that you are currently working with. I think I have a few ideas, but they are a bit more extensive than I really want to type out right now. I'm thinking of building filters with some conditional formulas. Hope I can help.

 

[TTinCO]

Good stuff Labeeb-am I wrong in that the ave would be much more meaningful than the median #? Especially with limited sample sizes-median can be somewhat deceiving.

 

[Labeeb]

Yes, I think that the sample size, especially if looking at just a team level, is going to be so small that the statistical relevance is very limities. However if looking at all NCAA teams, then there could be something worth looking at.