distribution

Hi all, I hope you're doing well. First of all, sorry for bad explanation as my main language is not English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula. It's quite helping with my daily Excel use. 2 of my latest question was asking about Dynamic Array...

Hello everyone, I'm scratching my head with a problem that seems to have a simple resolution but which I can't find; so I'm in need for your help. In a warehouse, I have several Buffer Areas to store boxes that will be shipped to several Destinations (see green table). Each Buffer Area has its...

Hi have a question related to covert number of calls from a cumulative total per day to a calls per hour like this.... Calls that need to be converted to hourly are on cells B3 to G23. As example we take B3 = 25 and try to split on cells B12 to B14 with this formula...

Imagine that we have 100 pens in our box (each numbered from 1 to 100). We mix them and then randomly draw ten pens and put them aside. Afterwards, we put ten new pens numbered from 101-110 into the box, and then again randomly draw other ten pens and put them aside. We continue doing these...

Hello, Please see below table: ABCDEFG1ValuesValueOccurrenceNew count of values:652BBBAAA10%3AAAAAB5%Values:4AABABA15%5ABAABB15%6AAABAA15%7ABBBAB15%8BABBBA15%9BBABBB10%10BBB11ABA12BAB13BAA14BBA15ABB16BAA17BBA18ABA19ABB20BAB21BAAD2:D9D2=COUNTIF($A$2:$A$21,C2)/20 Column C contains a list of...

Help! I am trying to create a VBA Code that is pulls from a list that equals one of the following: "Transport" "Level 1/2" "Level 3" "One to One" or "Youth Work". The information starts on the 2nd row and 8th Column. I need all of the information in the row to sort into their own worksheets...

I am working on a sales forecast for 2020. The forecast has 92 locations and I have sales by week by site for Period 1 2019 and a forecast of sales by week for Period 1 2020. Period 1 2019 Sales Total: $11,586,579 Period 1 2020 Sales Forecast: $11,57,090 Dollar Change in sales 2019 to 2020...

Hello! I have a spreadsheet with a list of items each day pertaining to cases employees work. Each case has an assigned owner but cases pile up and need to be evenly distributed. I’ve attached a dumbed down version of my spreadsheet without sensitive information. I need to assign the list...

Hi All, New to the Excel world. Need your help in providing me the excel macro to pull the member details from outlook distribution list. Can any one help me. Thank You !! Regards, Santy

Poking around on the web I find various formulas for creating histograms. I'm getting different results for each formula and I want to know which one is accurate. I have a table of purchase orders and I want to get the distribution of how many POs are in various dollar ranges (e.g. how many...

Is there any way to be able to access a spreadsheet based distribution list from outlook without having to create and then edit (as changes are made in the original spreadsheet) a static contact list in outlook?

Hello, I'm currently updating a distribution fitting template used in simulation based on historical data. I found the formula for Gumbel distribution from this thread, which is Location - Scale * LN(-LN(RAND())), for generating x...

I need help on how to estimate the degree of freedom using Maximum Likelihood procedure for student t distribution. I am working with multivariate random variables.

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.

Hello, I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while...

Hello, Just want to ask if there is an easy way to distribute the data from Column A to Column B, the result will be on Column D&E.

Hi there, How do i generate a set of data using exponential distribution with a mean of 10? Thank you!

I am looking for a formula/UDF for computing the Variance of Folded-Normal distribution. The formula for the same can be referenced at https://en.wikipedia.org/wiki/Folded_normal_distribution

Hi I put together an Excel report each morning that takes up one worksheet (about 55 rows & 26 columns). Once compiled, I have to email it out to a distribution list. Is there some way (may code based) that I can have a button on that worksheet that I activate that then automatically places...

I'd need to proportionally distribute (prorate) a value (integer number of products for a promotion) - by multiple of n - across a list, based on the relative weights (i.e. distribution of the sales) of "basis" values in the list.