streaks

Can someone please help me? I have over 43000 rows of data in an ExcelTable. I need an efficient forumla that determines streaks of zeros & ones and uses Excel Table nomenclature. In this sample, there are two pieces of data (i.e., wtn high and wtn low) and four corresponding columns (in...

Hi, I am trying to find the win and loss streaks for set of games to find out whether both teams have scored in match and if so carry it on as a streak. Thank you

Hello, I need the frequency distribution of streaks like 0 -1 -1 -> 2 0 0 -1 -1 -1 -> 3 0 Is there a way to create a column like column 2 in excel so that I can create a histogram that shows the data. Thanks for any help.

I've got a yearly history of game results and have just started incorporating winning/losing streaks. I've got a top 10 list of longest streaks, but I want to incorporate the dates of each streak. For example, on the data below, I want to be able to pull the date data from the first and last row...

Does Excel have functions that will enable me to calculate Z scores for Normal distributions that are not symmetrical? Suppose I have all of the data for all of the major league baseball teams going back over 100 years. Suppose I want to calculate the mean and std dev for win streaks of various...

I'm not sure of the correct terminology for explaining my question, so please bear with me. Suppose I have a random event with a binary outcome (win/lose) and I have a set of data showing how many times win streaks of various lengths occurred. Here's the data for 668 "games". #Wins 0...

I wonder if someone can please help me understand how the function FREQUENCY operates here. This algorithm counts the current streak of ONs and OFFs, counts the longest streaks of ONs and counts the longest streaks of OFFs. I just don't know how nor why it works. Specifically, what goes on...

Hello, I have been working on a spreadsheet to follow my country’s national soccer league. I want to find a way to count some different streaks for each team. Here is a sample of what I have so far from A1:AI7: <tbody> 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28...