# Math - working at basketball shoot - best price, best rate

## Excel Help for Math - Working At Basketball Shoot - Best Price, Best Rate in Charting and Performing Technical Analysis

### Math - Working At Basketball Shoot - Best Price, Best Rate

Rate this:
(3/5 from 1 vote)
 Math - working at basketball shoot - best price, best rateHello,I wanted to discuss a possible math problem.. perhaps its risk analysis, perhaps its  regression analysis...At a basketball booth, you pay 10 dollars to play, and if you win, you win a 12 dollar prize.My supervisor wants a 10-15% winning rate.The average person is required  to make 4 out of 5 shots rate in order to win the prize. In other words, they must have an an 80% shooting  average.After collecting data, it is determined that most people make somewhere between 2/5 or 3/5 shots, that is 40 to 60 % of their shots..Questions: What is the best required shooting average for a player such that the 10-15% winning rate is met?right now, it seems that 80% required shooting average is too high as very few players have won. Also, based on "RISK", if player can only pay 5 dollars to play, what should the required shooting average be? Should it be 90%?  Thank youJsvlad Posted by jsvlad on 19 Nov 2010
 Replies - Displaying 1 to 3 of 3 Order Replies By: Most Recent | Chronological | Highest Rated
Rate this:
(3/5 from 1 vote)
This is a simple probability calculation.  In order to have a statistically significant result, we first need to obtain the average and standard deviation of shot rate from the collected data.  For the purposes of this example, we will assume that the average is 60% (3/5) and the standard deviation is 20%.  These can be calculated using the AVERAGE and STDEV functions in Excel.

From this information we can determine the probability of achieving a target shot rate of 80% (4/5). The following spreadsheet and formula in cell B4 illustrates.