statistic

Hi everyone, I have been trying to create an algorithm to calculate the delivery efficiency rate (DER) of a logistics delivery company. The variables I have currently are late delivery risk( 1 or 0), distance between departure (customer city) and destination city(order city) , time taken for...

In the final match a boxer is facing another boxer and is expected to win 48% of the time. In reality they win 80% of the time. What is the probability of that occurring in 10 matches? 2) In the very next match (in a different tournament), the boxer who won the previous match only wins 40% of...

<colgroup><col><col span="6"></colgroup><tbody> 1.1 The average number of deer seen per hour 3.6. Calculate the probability of observing 0, 1, 2, …. 10+ below Number of Deer Seen 1 2 3 4 5 6 7 8 9 10+ How would i solve this on excel? </tbody>

Hi everyone, I'm teaching statistics and started incorporating Excel alongside R. When we got to running a Chi-Square test, I noticed something very odd that I cannot figure out. Can someone tell me why I get different results with the same formula function. Note, I'm using Excel 365 on...

Something like [=MEDIAN(ABS(C3:C20-MEDIAN(C3:C20)))] works but I can not find a way to define this statistic with a range of C:C so as to be able to see the change as soon as I add values? I thought that [{=MEDIAN(ABS(IF(AND((C:C<>0),(ISNUMBER(C:C))),C:C)-MEDIAN(C:C)))}] Would exclude empty...

Hi - I need help determining the best way to forecast for the following year end forecast value. The 'Xs' represent the data I have available to me to leverage. Ideas??? Thanks!!! <tbody> Months: 1 2 3 4 5 6 7 8 9 10 11 12 Total 2018 x x x x *FORECAST* 2017 x x x x x x x x x x...

First of I'm not sure if this is the place for such a question I have a set of 8 Players (could be any number from 2 players to 8 players in the group) I would like an excel formula to workout the percentage chance of each player to score the most points. I have managed to workout on Excel...

Hi, all. We have a chess club, and each member has data based on their participation in National events, State events, Local events, and Non-events. Each event, they are ranked by Participation (show, no show, where no show is BAD), Win/Loss per sub-event, as well as level of player that they...

I'm looking for a method of extracting data depending on a criteria and performing stats all within a single formula. <tbody> Participant ID Genders Scores 1 M 8 2 M 7 3 F 8 4 F 9 5 F 7 6 M 8 7 F 8 8 M 7 9 F 8 10 F 9 </tbody> The data that I am looking to extract: The...

Hi all, I'm getting the following error in a macro I've written that is currently calculating a rolling correlation. Error 1004: Unable to get the Correl property of the worksheet function class Here's the code: rng correl represents the number of days to take the correlation over; correlcalc...

Hi all, The answer I know is 312 x 311 x 310 x 309 x 308 = 2,862,766,146,240 = 2.86277E+12. The arguments are 312 and 5. Using the notation myfunction(x,y) the result is (x)*(x-1)*(x-2)*(x-3)*(x-4)*..etc...*(x-(y+1)) Another example, myfunction(17,10) = 70572902400...