Question

द फार्मूला ऑफ पोषण डिस्ट्रीब्यूशन​

Answer 1

Answer:

Z=(X- µ)/ α

maark the brainlist answer

Answer 2

Answer:

NORM.DIST Function

Calculates the probability that variable x falls below or at a specified value

Home › Resources › Excel Resources › Functions › NORM.DIST Function

What is the NORM.DIST Function?

The NORM.DIST function is categorized under Excel Statistical functions. It will calculate the probability that variable x falls below or at a specified value. That is, it will calculate the normal probability density function or the cumulative normal distribution function for a given set of parameters.

To understand what normal distribution is, consider an example. Suppose we take an average of 30 minutes to complete a task, with a standard deviation of 5 minutes. Assuming a normal distribution for the time it takes to complete the work, we can calculate the percentage of time for which the time would be between 25 minutes and 35 minutes.

As a financial analyst, the NORM.DIST function is useful in stock market analysis. In investing, we need to balance between risk and return and aim for the best possible return. Normal distribution helps quantifies the two aspects, risk and return, by the mean for returns and the standard deviation for risk.

Formula

=NORM.DIST(x,mean,standard_dev,cumulative)

The NORM.DIST uses the following arguments:

X (required argument) – This is the value for which we wish to calculate the distribution.

Mean (required argument) – The arithmetic mean of the distribution.

Standard_dev (required argument) – The standard deviation of the distribution.

Cumulative (required argument) – This is a logical value. It specifies the type of distribution to be used: TRUE (Cumulative Normal Distribution Function) or FALSE (Normal Probability Density Function).