Skip to content
SOPHUC

Excel is easy to learn

Menu
  • Home
  • Tips
  • Excel functions
  • text strings
  • Date function
  • Database functions

Category: Statistical functions

In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells.

How to use VAR.S Function in Excel
Statistical functions

How to use VAR.S Function in Excel

ExcelNovember 1, 2020August 4, 20200
The Excel VAR.S function returns the variance of a sample. If data represents the entire population, use the VAR.P function. …
Read More
How to use Z.TEST Function in Excel
Statistical functions

How to use Z.TEST Function in Excel

ExcelOctober 27, 2020July 5, 20200
Excel Z TEST is a kind of hypothesis test that is used to test the alternative hypothesis against the null …
Read More
How to use WEIBULL.DIST Function in Excel
Statistical functions

How to use WEIBULL.DIST Function in Excel

ExcelOctober 26, 2020July 4, 20200
Excel Weibull distribution is widely used in statistics to obtain a model for several data sets, the original formula to calculate …
Read More
How to use VARPA Function in Excel
Statistical functions

How to use VARPA Function in Excel

ExcelOctober 25, 2020July 4, 20200
The Excel VARPA function computes the variance of for a population of data. Unlike the VARP function, the VARPA function evaluates text …
Read More
How to use VARA Function in Excel
Statistical functions

How to use VARA Function in Excel

ExcelOctober 24, 2020July 4, 20200
The Excel VARA function estimates the variance of a sample of data. Unlike the VAR function, the VARA function evaluates text …
Read More
How to use VAR.P Function in Excel
Statistical functions

How to use VAR.P Function in Excel

ExcelOctober 23, 2020July 4, 20200
The Excel VAR.P function returns the variance in an entire population.  If data represents a sample of the population, use …
Read More
How to use STDEVPA Function in Excel
Statistical functions

How to use STDEVPA Function in Excel

ExcelOctober 22, 2020July 4, 20200
The Excel STDEVPA function calculates the standard deviation for an entire population. Unlike the STDEVP function, STDEVPA evaluates text and …
Read More
How to use TRIMMEAN Function in Excel
Statistical functions

How to use TRIMMEAN Function in Excel

ExcelOctober 21, 2020July 4, 20200
The TRIMMEAN function returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding …
Read More
How to use STDEV.P Function in Excel
Statistical functions

How to use STDEV.P Function in Excel

ExcelOctober 20, 2020July 2, 20200
The Excel STDEV.P function calculates the standard deviation for a sample set of data. STDEV.P calculates standard deviation using the …
Read More
How to use TREND Function in Excel
Statistical functions

How to use TREND Function in Excel

ExcelOctober 19, 2020July 4, 20200
TREND function is a built-in function in excel which comes under the category of Statistical function to calculate the linear …
Read More

Posts navigation

1 2 … 11 Next ›
Search for

Popular Posts

    Recent Posts

    • How to use VAR.S Function in Excel
    • 10 Ways to Raise Your Excel PivotTable Game
    • What are PivotTables in Excel? What Can You Do with Them?
    • 4 Reasons for Marketers to Love Pivot Tables [Excel Tricks]
    • SUBTOTAL in Excel: Everything You Should Know

    Recent Comments

      Categories

      • Average
      • Compatibility functions
      • Count
      • Cube funcitons
      • Database functions
      • Date function
      • Engineering functions
      • Excel
      • Excel functions
      • excel min max
      • Financial functions
      • Information function
      • Logic function
      • Lookup and reference
      • Math and trigonometry
      • Power BI
      • Statistical functions
      • sum
      • text strings
      • Tips
      • Vlookup excel

      Sitemap

      1. Post
      2. Page
      3. category
      4. Post_tag
      5. Author
      Proudly powered by WordPress
      RedWaves theme by Themient
      Menu
      Search for
      • Home
      • Tips
      • Excel functions
      • text strings
      • Date function
      • Database functions