stats

I have a basketball stat workbook in Microsoft Excel 2013. There is a tab for each game with the players listed and their stats for that specific game. I also have a tab with the team's stats that pull from each game tab. I would like to be able to add a tab for each player and have their...

I have a sheet with 20 names in one column. Now I have five separate columns to rate different performance categories with a scale of 1-20 (1 being the best). I'm looking for a formula to pick the name in a given cell of the player in each column with the score of 1. In theory, I should show...

Sorry if this Question is already been answered have looked quite a lot but couldn't find. Last week at work I used this function(floor) to calc. number of for eg. 10 that comes under 100. Could you please let me know if you can give me the formula for it. So to explain properly. I give £5 to...

Hello all, I'm haven't played with stats in a while and now I'm trying to determine the ideal traffic/labor hour in order to maximize revenue/labor hour. My data looks like this: Excel 2010 <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead> A B C D E F...

I have a Workbook with several spreadsheets in it that I use to stat our games. With the help of someone on this board I was able to create this; sorry I don't recall whom it was, but it was whomever listed the sheets with SUMPRODUCT for football. Now I am trying to add a little convience to...

Lend me your ears! I have a graph from a drug development lab where I work. The graph plots the concentration of drugs (which a cancer killing drugs) versus cell viability (x vs. y). Basically, the higher the concentration the less viability (Cancer drugs kill cancer cells). My problem is...