Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-12 : 08:07:43
|
| Walter writes "I ran your sample code for pencentiles and it works perfectly as shown, however when I try to recreate the same scenario in Excel by using the PERCENTILE() function using the same exact scores I arrive at a different value.I also noticed that it says "count" the number of scores below 20, when infact it uses a SUM()Any help would be greatly appreciated." |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-08-12 : 09:47:03
|
| Posting your code and samples of both results (SQL and EXCEL) would help. |
 |
|
|
|
|
|
PERCENTILES