statistics

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

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

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

I use an array formula to calculate the z score of numerical results in a list. The reason I use an array formula is because each result in the list is also part of a subgroup (subgroup labeling is in a different column in the same sheet; result is on the same row as its corresponding subgroup...

Hello, I need help!! Im totally new to any time of statistics. This will probably be easier on SPSS or Minitab - I have access to both but would also be open to using excel if i can. I have some data. Its 1500 rows like the following. - The data is from a OEE system. It is the occurrences that...

I'm trying to return the answer to the formula for BINOMDIST to the worksheet. However, unless I comment out the "cdf" row, the macro does not loop. I don't know what I'm doing wrong here. Any help will be appreciated. Thanks, Andrew Function AllowedErrors(Size As Double, Conf As Double, p...

I can use the BINOMDIST to find the sample size needed when I provide the required accuracy, confidence level, and number of errors. But I'd like to go the other way and find the number of allowed errors when I know the required accuracy, required confidence level, and number of trials. Is...

I use the workbook referenced below to provide me with the minimum sample sizes needed for a range of allowed errors, given a required accuracy and required confidence. In a round-about way, I fill-down the BINOMDIST function in a column to provide me with the probability/confidence that my...

Hi all I have the following code that I am using to generate a set of discriptive statistics for a set of random numbers by using the . However when I try to loop through the action of refreshing the data set there is a popup. "That says Descriptive Statistics - Output will overwrite existing...

I have a macro inserting a new row and providing a numbering sequence that works with our number of jobs in a list of jobs. I have had to set these jobs up in a typical table with the following columns: Job Number Project Name PM Bid Date Probability Contract Amount I have some formulas on a...

Hello everyone, I would like to use the Student T density function & cumulative probability function in a measure related to a data table in PivotTable Fields. Excel has it with T.DIST(..., ..., FALSE/TRUE). However is it a more or less straightforward to use an equivalent in DAX? Thanks in...

I have been asked to add a 3 sigma to the Fire and Release. The problem is I have no clue how. If you could please help me out that would be awesome! Thanks soooooo much Test stats..xlsx - Google Drive

Hi all, I have a dataset which includes. Invoice No, Stock Reference, Qty All stock references are batteries with codes 301 to 399 Is there an easy way to determine the AVERAGE order? I have tried calculating the average count of each invoice numbers (which is 8) and...

Background A group of trainees have each completed a training evaluation form. We have collated the results in an Excel table. The table header represents the degree to which they want more or less of an item. This ranges from -5 (much less) to 0 (keep it as it is) to +5 (much more). The Y...

I'm trying to, what I think is, 3-D Cell References across worksheets to calculate a baseball league's statistics. My document can be downloaded here: http://twitterbaseballny.com/wp-content/uploads/2017/04/2016-Twitter-Baseball-League-Wide-Stats.xlsx I've set up my excel file with the first...

I have a sheet to log incidents and I would like to complete a sheet for daily statistics. For example, if one person (name in cell A1) attended an incident (data validated from a separate list in B1) then on a separate sheet, I would like a total amount of those incidents that the particular...

I have a multiphysics problem in which my output voltage data is dependent on the input oscillation frequency. There are four physics coupled in the problem. I have experimental voltage data available w.r.t time. However, I don't have an extensive input frequency data points. I would like to...

Hello, I have been charged with creating an interactive pivot chart which calculates the frequency of census values. What I have done is used the census table to generate a census per day. From that I am trying to get frequency. To thwart confusion, frequency is defined...

Some of you folks could come up with the answer to this far quicker than I could painstakingly do: How many years must pass before theres a Full Moon AND Daylight Savings Clock Adjustment falling on the same date? (This I guess could include both the Fall AND Spring time adjustment dates.)...

Hello. First-time posting so please forgive any breaches of etiquette. I have been using excel for over 20 years and rarely come across something that stumps me, but I have a real quandry on my hands and am very much in need of your collective wisdom. I am analyzing the distribution of...