answersLogoWhite

0

FREQUENCY(data_array, bins_array).

See related links for details and examples.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


What would be the percentage between 5.10 from 4.25?

what is the formula in excel for: 5.10 percentage 4.25


Mathematical equation assigned to a cell that Excel uses to calculate a result?

formula


What is subtotal percentage formula field?

Are you asking about something in Excel? Can you give example?


In Microsoft Excel how do you use a formula to calculate the percentage of use of a set of symbols?

In A1, put the total number of symbols.In B1, put the number of symbols used.In C1, enter the formula =A1/B1Format C1 for percent and observe the answer.


What is the loan constant formula in Excel and how can it be used to calculate loan payments?

The loan constant formula in Excel is PMT(rate, nper, pv). This formula can be used to calculate loan payments by inputting the interest rate (rate), the number of payment periods (nper), and the loan amount (pv). Excel will then calculate the fixed payment amount needed to pay off the loan over the specified period.


What is the formula used to calculate result in Microsoft Excel?

The formula you use depends upon what you are trying to calculate. If you want to multiply two cells (e.g. A1 and C2), the formula would be =A1*C2.


What is the formula for Net Operating Margin in Excel?

=(total revenue- total expenditures)/revenue. you get a percentage.


How can I calculate portfolio variance in Excel?

To calculate portfolio variance in Excel, you can use the formula SUMPRODUCT(COVARIANCE.S(array1,array2),array1,array2), where array1 and array2 are the returns of the individual assets in your portfolio. This formula takes into account the covariance between the assets and their individual variances to calculate the overall portfolio variance.


How do you find the percentage on Excel?

You find percentages with excel the same why you would with any other method. Multiply the number times the decimal equivalent of the percent. If you want to find 12% of $132.56, use this formula: =132.56*.12If you store the number in cell A1 and the percent in A2, you can use the following formula to calculate the results: =A1*A2


What is the Excel formula to calculate the total of values in cells d7 through e20?

=SUM(D7:E20)


What is the Excel formula to calculate the gross revenue of the highlighted cell C8?

To calculate the gross revenue in Excel, you can use the formula: =C8 * (1 + tax_rate), where tax_rate is the applicable tax percentage expressed as a decimal (e.g., for 10%, use 0.10). If you need to sum multiple revenue sources, you can use: =SUM(C8:Cn), replacing n with the last row of your data. Make sure to adjust the formula based on whether you need to include taxes or other factors in your gross revenue calculation.