The BINOMDIST function returns the individual term binomial distribution probability. You can use BINOMDIST to calculate probabilities that an event will occur a certain number of times in a given number of trials. BINOMDIST returns probability as a decimal number between 0 and 1.
Binary...Read more
The goal is to filter the horizontal data in the range C4:L6 to extract members of the group "fox" and display results with data transposed to a vertical format. For convenience and readability, we have two named ranges to work with: data (C4:L6) and group...Read more
In order to understand this problem, make sure you understand how percentage number formatting works. In a nutshell, percentages are decimal values: 0.1 is 10%, 0.2 is 20%, and so on. The number 1, when formatted as a percentage, is...Read more
In the example shown, the goal is to enter a valid time based on days, hours, and minutes, then display the result as total hours.
The key is to understand that time in Excel is just a number. 1 day = 24 hours, and 1 hour = 0.0412 (1/24). That means 12...Read more
The SKEW.P function returns the "skewness" of a distribution. SKEW.P measures the symmetry of a distribution. A positive skew result indicates a distribution that tails off to the right. A negative skew result indicates a distribution that tails off to the left. In a perfectly...Read more
The SKEW function returns the "skewness" of a distribution. SKEW measures the symmetry of a distribution. A positive skew result indicates a distribution that tails off to the right. A negative skew result indicates a distribution that tails off to the left. In a perfectly symmetrical...Read more
In this example, the goal is to sum the first n matching values in a set of data. Specifically, we want to sum the first 3 values for both Red and Blue, based on the order they appear in the table. There are 12 values total; 6 entries each for Red and Blue. All data is in ...Read more
The FORECAST.ETS.STAT function returns a given statistical value related to time series forecasting. The statistic_type argument determines which statistic is returned by FORECAST.ETS.STAT.
The FORECAST.ETS.STAT function is (optionally) used to output forecast statistics as...Read more
Traditionally, counting unique items with an Excel formula has been a tricky problem, because there hasn't been a dedicated unique function. However, that changed when dynamic arrays were added to Excel 365, along with several new functions...Read more
The FORECAST.ETS.CONFINT function returns a confidence interval for a forecast value at a specific point on a timeline (i.e. a target date or period). It is designed to be used along with the FORECAST.ETS function as a way to show forecast accuracy...Read more
