statistical analysis

Hi folks, I am trying to create a oprisk methodology based on the guidelines provided using VBA until we switch to R language. Could someone verify the code below based on the guidelines provided as well. Statistician background would be really helpful. Guidelines: Step 1: Calculate the mean...

Hi Everyone This should be rather simple, any help is appreciated thank you :) In column A i have a dates in order in order, in column B i have either if the day was a "win" or a "lose" In Column C i have a formula for current win streak im looking for a formula to determine given the...

I have a following structure: predictions, truth 1,1 1,0 1,1 1,2 1,0 ... 16 times 0,0 0,0 0,1 0,0 ... 16 times . . . I need to compute this formula for each 16 times and then do the median between all of them: the formula is: equal_values/16, where equal_values are the values of the...

Hi all. This is my first post in this forum so hope this is ok to post. I have analysed and collected data on the number of kicks per game & kicking distance for 12 International rugby union matches over the last few weeks. I have concluded that kicks per game was a winning predictor in 8/12...

Hi All, can anyone help me create a formula which will solve Owens T function. I have not been able to think of a way to do this. I have been using Wikipedia for the formula Owen's T function - Wikipedia. Does anyone know how to input a formula which can solve this for a range of x and a inputs?

Hello Experts , Can someone please help me to get the variation on Quartile 2 to Quartile 3 on Productivity. I am adding my sheet where I am unable to find the right way to show the productivity variance. ABCDEFGHIJKLMNOPQRST1Emp IDNameTenure YearTenure MonthWorkoutCore...

Hey, I am trying to calculate a percentile of salleries in a table if they've worked between 24 and 60 MonthsWorked Sallery 22 12124 23 12462 24 12521 24 12523 28 125232 60 13542 62 13800 What I've done so far which actually works: 25% Percentile sallery Monthsworked <24...

I have a time series data regarding power consumed at a phone charging station with columns named: date, user id, and power consumed. I am trying to perform a statistical analysis to figure out the following: 1. how many people used the station? I have done this one by counting the number of...