statistics

  1. Jyggalag

    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...
  2. O

    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?
  3. O

    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...
  4. J

    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...
  5. J

    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!
  6. W

    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...
  7. E

    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...
  8. S

    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...
  9. H

    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...
  10. V

    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...
  11. H

    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...
  12. S

    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?
  13. P

    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...
  14. S

    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...
  15. S

    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>
  16. T

    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...
  17. J

    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...
  18. S

    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...
  19. S

    Football Statistic Match Ratings (Average for Past 3 Games)

    I'm building out a database of Football statistics for the Football Teams I support, however an issue I have is that it is all automated, except for the average rating for the past three matches (Recent Form). At the moment I have to manually select the cells that would contribute to this...
  20. S

    statistics for "difference in differences"

    I wonder if anyone on this forum knows how to calculate using EXCEL the statistics for "difference in differences". I have 4 sets of groups - each group has a mean and a standard error I am trying to calculate if the difference between group 1 and 2 is the same or not the same (statistically)...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top