# statistics

1. ### Adding new teams to darts Statistics.

Hey all, I have just taken over as the stats man without knowing to much. The excel file i have been given works great. The problem i have is it only has room for 6 teams but one of our divisions has 9 this season. Would anyone be able to explain how i can add on an extra 3 teams? Thanks...
2. ### Power Query Statistics Greyed Out for Certain Columns

Was trying to add a Z-score column and needed to calculate mean and median but I can't for certain columns with a large number of null values. Both columns are in the same merged query data source and are both decimal types. I can calculate statistics for one and not the other.
3. ### Make a nicer trendline in bar chart in Excel

Hi All, I currently have a setup similar to this: I want to create a trendline for the 2022 bar charts. My issue is that no matter which one I pick (exponential, linear, logarithmic etc.) it doesnt touch the top of the bar charts for 2022 and it seems to just go through them. Does anybody...
4. ### Calculate Owens T Function

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?
5. ### Modelling a Cumulative distribution function for a skewed normal distribution

Hi, I am trying to create a formula in excel which shows the provides the Cumulative distribution function for a skewed normal distribution giving set parameters for skewness, mean and std. dev. I have done this for a normal distribution using the Norm.Dist (Culminative True) function, but i...
6. ### Find medians from a frequency distribution table?

Hi all, new to this site. I'm hoping to find an answer to this. I have been looking to figure this out for some time, and have tried a couple of methods that don't work quite right. I want to find the median in a frequency distribution table in excel. I only have one sample group to work from. I...
7. ### Probability after Loss in a row

Hey guys, I have a spreadsheet with the past frequency of losses in a row before having a winner. What formula can I use to calculate the probability of having a winner after 1,2,3(etc) losses in a row according do this data? Thanks, appreciate the help!
8. ### Need help With formula

Hi I need a formula for: to find all numbers/rows that repeat at least two numbers in the entire row in at least one other row. Maybe highlight each set wit different color? im not sure if this is even possible since if the numbers in different row repeat then it would highlight it in both...
9. ### Copying data from a closed workbook / replacing indirect(concatenate)

Hello, I need some advice regarding following: Once a month a workbook is created with reports. The structure of the monthly workbooks looks in 2019 like this: Statistics Modell 201906.xlsx Statistics Modell 201905.xlsx Statistics Modell 201904.xlsx Statistics Modell 201903.xlsx Statistics...
10. ### Analysis? Which of 7 factors affect revenue? HOW

Hi. Urgent as need to hand in tomorrow. Completely lost. I have revenue each day; there's multiple factors; TV ads, radio ads, Facebook likes, Google ads, temperature and precipitation for each day too... In excel- what do I use? What stats to do a quick job on what factors affect revenue...
11. ### help with efficiency on football database

https://imgur.com/r5isISk hi everyone the link there takes you to a screenshot of a spreadsheet I have operated for several years to record results of a weekly indoor football game with friends with teams chosen at random. hopefully its reasonably self explanatory how I have set it up as it is...
12. ### Macro taking long time to execute.

Hi all, Have to generate 640 files basis district name. The output sheets are formula based , they pull the data from input sheets. Mostly the sumifs formula is used. It takes almost 5 minutes to generate one single file. Perhaps with each change of district the calculation features takes time...
13. ### Compatibility Functions

I am using the statistics functions on Excel 2016, which have various items listed as 'compatibility functions', for instance, =mode and =stdev. I wanted to know, if I import an old spreadsheet: 1) Is there somewhere I can find out which of the new functions the deprecated ones refer to? For...
14. ### Statistics Help on Excel

How do you find the statistical difference between a slope of -0.09 and a slope of 0? What steps would you need to do to figure it out? What statistical analysis would you need to do?
15. ### Football algorithm - statistics

Hi, I have a bit of a problem. Usually I manage to find answers and solutions in the older threads (thanks to everyone for posting answers on the site), but this time I was forced to register and post my issue :). I m designing an algorithm for a football game, the issue is statistics. It would...
16. ### Is it possible to take a list of numbers and put each one of them in a different cell

Hi, I have a lot of data sequences I need to statistically analyze. The problem is that the numbers are separated by a space character. I need each number to be in a different excel cell. Is there a way to tell excel to use the space as "move the next number to a different cell"? For example...
17. ### Probability on Excel

<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>
18. ### Power/Sample Size Calculator

Hi all, I'm trying to find the formulas needed in Excel to calculate Power and Sample size, as we currently use Minitab and it is tedious with a long list of inputs. I used this site http://www.real-statistics.com/sampling-distribuion/statistical-power-sample/ but I do not have a standard...
19. ### SUM IF all sheets ending with "Statistics"

I hope I explain this okay because it's quite complicated but here goes: I have multiple sheets ending with the word "Statistics", Dave Statistics, Stuart Statistics, Alan Statistics etc (more sheets can be added at any given time) I need a formula that will... Firstly look in all sheets that...
20. ### Rows Between Next Item

Hey everyone, I'm new here so just a short Hello and hoping you're all well. I have a one column list of over 3000 rolls of a dice. E.g 3 6 5 3 2 3 4 4 2 2 3 etc, etc I need a way to know how many rolls before the same number came up again. So, in the above snippet of the data, if I checked... ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back