Browsing all articles tagged with Excel Formula

PERCENTILE Excel Formula

Author Zaheer    Category Formulas     Tags ,

Excel is one such powerful tool that lets you make graphs, analyze data, and use formulas and functions which are already installed. These functions allow you to do calculations in certain fields such as Statistical Functions, Text Function, Logical Function, Math Functions, Statistical Functions, and many more.

Functions are still divided into smaller groups for you to easily find the function you need. Statistical Function is composed of Counting Cells, Finding the Largest & Smallest Values, Averages, Frequency and Ranks, and Distribution and Tests of Probability. The Distribution and Tests of Probability includes the PERCENTILE functions. This function allows you to return k-th percentiles in a given range of numerical data for a specific value k.

PERCENTILE function syntax includes:

=PERCENTILE (array,k)

The array argument refers in the value or the data that you want k-th to be calculated from. The argument k in formula is value of percentile which ranges from 0-1.

If the argument array in the syntax is blank or if it has over 8,191 datum pints #NUM! error will occur. Also, #NUM! error will occur if values of the k argument is lesser than zero or when it is more than 1. The error #VALUE! will occur if the k argument is a non-numeric value.

Try PERCENTILE function by opening a blank excel spreadsheet or worksheet and input in cell A1 the data 1, in cell A2 the data 3, in cell A3, the data 2, in the cell A4 the data 4. Now input the formula =PERCENTILE(A2:A3,0.3) and the outcome will be 1.9. The result is the 30 percent of the given array values.

After inputting the formulas, you can change views from formulas to results and vice versa by hitting the keys Ctrl+` (grave accents). You can also hit the particular Formulas tab, select Formula Auditing groups option, and select the Show Formals option.

CONCATENATE Excel Formula

Author Zaheer    Category Formulas     Tags ,

First of all, what is concatenation? You think of Excel as able to carry out arithmetic functions on data. Well, you are wrong. Excel has several features that let you work with the text data as well. There are 2 ways to make concatenation formulas; it’s either the hard way or the easy way.

Suppose you had first names in the column A and the last names in the column B. your present task needs them both in similar cells. It’s simple and it’s ludicrous. Suppose you like to make automatic filenames to assign to data list that you are going to upload in online shopping cart program.

You have the entire graphics ready as thumbnails and as a regular size. You know already that you have used the SKU number which you added ‘t’ in front of the thumbnails and they are all JPEG files. You have got SKU number in the column C of the worksheet as well. You know that there should be easy way and yes there is.

Excel Concatenate Function

The Concatenate functions are one of the Excel text functions utilized to join 2 or more words or texts string together. The Syntax intended for Concatenate function is shown below:

= CONCATENATE (text1, text2 … text255)

The text 2, text 2555 could be words, blank spaces, cell references or numbers. More than 255 texts entries could be added in this concatenate function. Every entry should be separated with comma.

For example: Using Excel Concatenate Function

Note: You have to know that a concatenate function doesn’t leave blank space between other data or words.  To add spaces in between the concatenated data you will simply add space to line Text2 and Text4 of dialog box with the utilization of space bar in keyboard.  Here is how: Enter the following data into specified cells:

  • D1-4
    E1-hrs
  • Click cell D3 – it is the location where the result of the function would be displayed.
  • Click Formulas tab
  • Opt for Text Functions from ribbon to unlock the drop-down list
  • Click CONCATENATE in the list to discuss function dialog box
  • Online Text1 of dialog box, then type in the phrase “We will arrive in”
  • Online Text2 of dialog box, then press space bar to add blank space
  • Online Text3 of dialog box, click cell D1 to go into the cell reference in the dialog box
  • Online Text4 of dialog box, then press space bar to add blank space
  • OnlineText5 of dialog box, then click cell E1 to go into that cell reference in the dialog box
  • Then Click OK
  • Concatenated sentence or phrase “We will arrive in 4 hours” must come out in cell D3
  • Complete function of = CONCATENATE ( “We will arrive in”, ” “, D1,” “, E1) come into view in formula bar on top of the work sheet

How to Utilize Excel Concatenate Function?

This Concatenate function of Excel bonds text strings in solo text string. This allows you to select a variety of cells so as to make multiple strings when the cell meant to hold the result is the row which includes the chosen cells. Here are the steps which will demonstrate how you can utilize the Excel function of Concatenate:

  • The  Concatenate Functions’ syntax is expressed as:

Concatenate (text_1,text_2,text_3…text_n)

Wherein the text_1, text_2, text_3…text_n are one to thirty text items which will joined together. This value can be text strings, numbers, or references on a single cell.

  • Use ampersand as its calculation operator. You can use this kind of technique to bond text items as an alternative of Concatenate function.

Example: =A1 & A2 will bring similar result like this formula = Concatenate (A1, and A2).

  • Look for an example used for Concatenate function.

Put A2 = salmon including A3 = species and A4 = 25, then enter = Concatenate

  • Study the application of the different cell ranges intended for Concatenate function.

Enter this formula: = Concatenate (A2:A3) within cell B2.

See that Concatenate simply displays salmon within cell B2 since it simply utilizes text strings which are in results row. With this, you need to employ a suitable concatenate formula in every row so you can use fields in these rows.

  • Enter automatically the Concatenate formula.

Position the marker within a cell that you intend to use, opt for Insert menu located on its menu bar then select as well the “Function” found in the Insert secondary menu. Opt for “Text” type and then “Concatenate” function. Provide the argument as provoked and then click “OK” button so as to show the results.

PERMUT Excel Formula

Author Zaheer    Category Formulas     Tags ,

Excel Statistical Function allows you to do simple to complex statistical computations: from mean, median, and mode to probability tests. The Statistical Function is composed of five subgroups. Under the subgroups is PERMUT Function. PERMUT function allows you to compute how many permutations do a given value of objects has. As an overview permutation is the significance of an internal order of a group of events or objects. This function is commonly used in calculating the probability of lottery results.

The syntax of PERMUT function include:

=PERMUT (number,number_chosen)

…whereas the argument Number is a numerical value that describes how many are the objects. The argument Number­_chosen is a value that corresponds to how many the objects are in a given permutation.

Test the function by opening a blank Excel worksheet or spreadsheet and input the following data in the source cells. For cell A1 input 100, for cell A2 input 3 and the formula is =PERMUT (A2, A3) and the result will be 970200. The result refers to the possible permutations with the data given. You can also immediately input the values in the function as: =PERMUT (49, 6) and the result will be 10,068,347,520.

For PERMUT function, there are common errors that will occur and these are #VALUE! error and #NUM! Errors. #VALUE! Error occurs when the argument Numbers or Number_chosen are non-numerical values. #NUM! error will occur if the argument number is equavalent to or lesser than zero and if Number_chosen arguments is lesser than 0. Likewise, if the argument Number is lesser than the argument Number_chosen #NUM! Error will also occur. In addition, take heed that the arguments if function is shortened and made into integers.

Once you have inputted the formula in the selected cell the result will automatically show. If you like to view the formula of the results you can hit Ctrl+` (grave accent) in the keys. In addition, you can do this by selecting Formulas tab hit the Formulas Auditing group and in the options select the Show Formula.

EXACT Excel Formula

Author Zaheer    Category Formulas     Tags ,

At the present modernity of the world, people are faced with numerous complex assignments that need to be accomplished. Unfortunately, they cannot do these complex tasks by using the manual techniques. Luckily, there is an available computer program that provides a convenient way to complete these tasks. Nowadays, one of the most commonly used computer programs throughout the whole world is Microsoft Excel. Excel contains a lot of powerful functions making it suitable for the accomplishment of complex assignments. It helps a lot of people to deal with the growing complexity of their work.

Most probably, you might have learned about the various techniques in using the functions in Excel. Some of these functions are the VLOOKUP, HLOOKUP and MATCH which are commonly employed to help in the retrieval of data especially when you are dealing with large sets of data. There is also another kind of function available in MS Excel that will allow you in comparing data contained in two different cells. This called is called as Exact function. For a better understanding, this article provides you a brief overview of Exact function and how it is used in MS excel. On the other hand, if you would like to learn more about it, read on.

Overview of EXACT Functions in MS Excel

Microsoft Excel offers a convenient way to search for matching data between multiple cells. By the use of Exact function, it is possible to find the exact match between any 2 cells. You need to enter in Exact functions formula. The 2 cells are going to be matched and the function will return the value which is either a FALSE or a TRUE. One good thing about EXACT functions is, it’s case sensitive. It returns the result “TRUE” only if the case of both cells is exactly the same.

How to Use EXACT Function with MS Excel?

This article will teach you the comparison of contents 2 cells in MS Excel by utilizing the EXACT Excel function. One good thing is which you can employ this particular function in proceeding manner to attain more customized data. However, this article will provide the most fundamental usage of EXACT function for the comparison of contents of cells in an Excel spreadsheet.

  • Of course, the first thing to do is to launch Microsoft Excel.
  • Then you can easily create some randomized data. Type in the following values in the provided cells:

A1: basketball, A2: football, A3: football, B1: baseball

  • After doing that, you now have 1 row of information in column B and3 rows of information column A. Take note that A2 as well as A3 contain the same data which is “football”.
  • Then you can now diffirentiate various cell. In cell C2, you can enter the syntax forEXACT function for the comparison of cells. The functions’ formula include:

=EXACT (cell1, cell2)

  • In the formula, you can assign any 2 cells with cell1 or cell2 argument. Now, type in this formula in cell C2.

=EXACT (A1, A2)

  • After you enter the formula, you will get to see that the result in C2 is FALSE, since cell A1 is not equivalent to cells A2. Cell A1 contains basketball while cell A2 contains football. Next, make some changes in formula in C2, you could do it this way:

=EXACT (A2, A3)

  • ·After you enter theformula, you will now see that the result in cell C2 is TRUE. Of course, this is the value you want since cells A2/ A3 definitely contain the same data, which is “football”.
  • You can utilize the EXACT functions to compare a value of a cell with some lists of cell. As an example, in case you like to evaluate the content of cell B1 along withcontents of cells A3, A2 and A1, you could employ this syntax:

=EXACT (A1:A3, B1)

EXACT functions are one of the useful functions of Microsoft Excel. The article has provided you some of the basic concepts about this function. There are still a lot of functions contained in this powerful computer software that offer several benefits to the user. You can go for further readings since several articles are widely spread especially on the internet in which you can get lots of information.

POISSON Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel has been part of our daily computation activities from simple to complex calculations. It is composed of different functions that are very helpful in terms of calculations in various aspects. These functions are still divided into groups like the Statistical Function has the subgroups of finding the largest and the smallest value, counting cells, distribution and tests of probability, averages, frequency and rank, deviation and variance, and trend line functions. One function in Excel is POISSON function which allows the user to predict how many events there are for a specific value in a given exact time.

The syntax or the series of arguments of POISSON function include:

=POISSON(x,mean,cumulative)

…whereas the argument X in the syntax refers to how many events there is. The argument Mean refers to the expected value of numbers of event. Lastly, the Cumulative argument refers to what kid of distributions to be computed. If the cumulative argument is TRUE you will have to use cumulative distributions function. The count of the random events that will occur is between the number 0 and X wherein the values are still included. If it is false probability mass functions is used wherein the the exact numbers of event that will occur is X.

In case #VALUE! errors will occur this means that supplied X arguments or mean argument are a non-numeric value. Moreover, #NUM! errors will occur if the given X argument is lesser than 0 and if Mean argument also is lesser than 0. Also, if the argument X isn’t a number it would be automatically truncated.

Try POISSON function by opening first an Excel Spreadsheet or worksheet and input cell A1 the number 2 and in cell A2 the number 5. The formula for the argument is as follow; =POISSON (A2, A3, TRUE) and the results will be 0.124652 which is Cumulative Poisson of the given value. For Poisson possibility smass functions with formula =POISSON (A2, A3, FALSE) and the result will be 0.084224. You can also insert the values in formula as follow; =POISSON (20, 25, FALSE) and the result will be 0.051917469.

FIND Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is indeed one of the most powerful computer programs created by the Microsoft Company. Excel is equipped with numerous functions that help people to cope with the increasing complexity of their work, especially these days that the technology is advancing. Here let us talk about  some of the Excel’s function such as Search and most especially Find function that offers a lot of benefits to the users.

In Microsoft Excel, there two functions that have almost the same functionality. These two functions are used to search for some data inside the cells that matches parameter that you have indicated. They are the FIND and SEARCH function in Excel. They are actually the same, in fact, a user may wonder why there are 2 different functions that provide nearly similar results and even the syntax is the same. Here we will provide you a discussion of the Find and Search functions in Microsoft Excel and the fundamental differences between the two.

Overview of Search function in Microsoft Excel

SEARCH function are utilized to locate a character with other cells. In other works, when you trylooking for some characters that is  located in the cell containing a sentence, word or some kinds of data, you could do that by utilizing SEARCH function. Formula of the function:

=SEARCH(“find_text”,”within_text”,start_num)

As examples, words like beautiful” is contained in cell A1 and you required the position of letters ‘b’ on the cell. To do this, you could utilize SEARCH function formul2134-#777-B234a which is:

=SEARCH(“b”,A1,1)

The function will provide you result which is 1. Then when you are looking for the position of letter “t”, you could employ this formula:

=SEARCH(“t”,A1,1)

The function would return the result which is 5. You may use SEARCH function as well to locate the position of group of characters. As an example, “2134-#777-B234″ is contained in cell A2. If you want to search forlocations of “B23″, you can use Search function formula:

=SEARCH(“B23″,A2,1)

The function returns the result which is 11.

Overview of Find function in Microsoft Excel

Find Function is one more technique to locate the position of a characte with other cell, similar to Search function. Its syntax includes:

=FIND(“find_text”,”within_text”,start_num)

With usage of similar sample in Search functions, the position of letter ‘b cell’ A1 would be located using this formula:

=FIND((“b”,A1,1)

Similarly, you would obtain a result which is 1. Then if you want to search for locations of letter “t” in cell A1, could use this formula:

=FIND(“t”, A1,1)

The function would return value which is 5. Once again, for example, “2134-#777-B234″ is contained in cell A2. Then if you want to search for the position of “B23″, you may use this formula:

=FIND(“B23″,A2,1)

FIND function returns the result which is 11. If you will notice, to the point, you can obtain similar results by using the SEARCH / FIND function in Excel.

Major Differences Between the Two Functions

The major variaiton between the two functions is , FIND function’s sensitive case whereas SEARCH function isn’tt. Therefore, if you employed formula=Search “B”,A1,1) (take note of the capital letter B), the SEARCH function would still return the same result which is 1. But when you were going employ the FIND formula, =FIND(“B”,A1,1), the function would return the result which is #VALUE! Since Find is the case sensitive as well as there are no B in word “beautiful”.

Another difference between two is, Search permits for usage of wild cards while Find doesn’t. In cse of this matter, the asterisks would search for the start of the string of character right before it, and quesiton mark would search for the right phrase and strings of character within a cell.

However, despite of their differences, in short, the SEARCH or FIND functions are very identical,and not unless you require confirmation of a certain character or some series of character, you would preferto employ SEARCH function. Based from an Excel user’s experience, SEARCH function has been useful and beneficial especially for particular financial modeling exercise. However, it is essential to learn about the differences of these two functions in terms of their usage and results.

FIXED Excel Formula

Author Zaheer    Category Formulas     Tags ,

Most probably, everyone knows about Microsoft Excel. Excel is one of the most widely used spreadsheet program around the world. This computer software is one of the essences of the Microsoft Office versions. It has several features and functions from the simple ones that are extensively used by a lot of individuals whether at home or in workplace, up to the complex functions that would only ever be employed by the professionals in various fields. Excel provides a broad range of functions that offer numerous advantages to people especially during these days that the technology develops rapidly.

Today, many individuals utilize spreadsheet in their everyday life whether when doing simple tasks or even when working with the complicated ones. Although most people utilize spreadsheet for their fundamental function, Microsoft Excel contains a huge number of advanced functions that can be very helpful especially to those who require these functions in their respective fields. Excel also contains functions such as mathematical and financial functions for easy calculation of results. One of these powerful functions that Excel provides is the FIXED function. To learn more about it, here is an overview of the FIXED function, how it is used and some examples for a better understanding.

Basic Description of FIXED Function

The FIXED function in Microsoft Excel is used to round a number value to a particular number of decimal places and then the function converts the number value into text. The syntax of the FIXED function is:

FIXED(Number, [Decimals],[No_commas])

  • Number: This argument is the number value to be converted into text.
  • [Decimal]: This is an optional argument. This argument specifies the number of decimal places to be displayed right after the decimal point.

But you have to take note of the following:

If Decimal is left blank, it automatically takes the default value which is 2.

The entered number value is rounded up to the left of the decimal point if the Decimals argument is negative.

  • [No_commas]: This is also an optional logical argument. This argument specifies the returned text result if the thousands are to be separated by commas. The possible values for this argument are the following:

If TRUE, the returned text result doesn’t includes commas.

If FALSE, the returned text result does includes commas.

Note: If the [No_Commas] argument is left blank, it will automatically take the default value which is FALSE.

As an example, “123.591” is contained in cells A2 to A6.

If you use the formula, =FIXED(A2) and enter it in cell B2, leaving the [Decimals] and [No_Commas] arguments blank, the function will return the result which is 123.59. The result is will be displayed in cell B2. As you can see the result has two decimal places after the decimal point since the [Decimals] argument is omitted, it takes the default value of 2.

If you use the formula, =FIXED(A3,1) and enter it in cell B3, the function will return the result which is 123.6. As you will notice, the [Decimals] argument is 1, so the result has one decimal place after the decimal point.

For a better understanding of the topic, here is a detailed procedure on how to use the FIXED function in Microsoft Excel.

How to Use FIXED Function in Microsoft Excel

One of the advantages of MS Excel is that, it is capable of homogenizing and customizing data. If you need to create a professional report with reliable formatting all throughout, there are numerous functions in MS Excel that can assist you to do that. One of which is the FIXED function.

  • Of course, the first thing to do is to know what the FIXED function does. Once again, the FIXED function rounds off a numerical value to a specified number of decimals and the result is returned as text whether with or without commas.
  • Next, you need to complete the correct formula of the FIXED function which is: =FIXED(Number, Decimals, No_commas).
  • Then you can now use the FIXED function. For you to understand more about the function here is another example. You may type in hard numbers or use the cell references like A1. For example, “2627.3469373” is contained in cell A1. If you use the formula =FIXED(A1,3,TRUE), the function will return the result which is 2627.347. Furthermore, if you use the formula =FIXED(A1,4), the function will return the result which is 2,627.3469.

SEARCH and FIND Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel allows you to search or locate a current or existing text or data in the worksheet with SEARCH function and FIND function. The SEARCH and SEARCHB function is use to locate a data or text usually for the MID and MIDB or REPLACE and REPLACEB function be used. But if you want the search to be case sensitive, you can make use of FIND and FINDB command.

The syntax or series of arguments for this command is SEARCH(find_text,within_text,start_num) and SEARCHB(find_text,within_text,start_num). The argument find_text refers to the text or series of text you want to find in the spreadsheet. The Within_tex argument refers to the text which you want to search for find_text. Moreover, the argument Strat_num refers to the numerical character which is in the within_text from which you want to start your search on.

The #VALUE! Will appear if the character or words on the find_text argument is not to be found on the spreadsheet. Also, if the start_num is left blank, it is automatically assumed that the number there is 1. An error will occur if the start_num is not a higher numerical value than 0 (zero). It could also become an error if the length of the within_text argument is greater than the actual length. If you want to skip a specific number or count of characters you can use the start_num.

However, in the FIND and FINDB command, the wildcard characters are the asterisk character and the question mark character. The question mark character refers to the single character while an asterisk character refers to a series of characters.

You can also make use of the FIND function in Excel this makes the beginning position of a text string wit another text string. This will show the result of the formula of a number those points to a beginning character. Be reminded that the FIND formula is sensitive. So, if the word or label are in uppercase in the spreadsheet then make sure to input it in uppercase when you use the FIND command. The syntax of the FIND command or function is; =FIND(Find_Text, Within_Text, Start_Num). The arguments represent the same characters or data with the SEARCH function.

SUBSTITUTE Excel Formula

Author Zaheer    Category Formulas     Tags ,

A Substitute Function replaces the set of character with another. If syntax is:

= Substitute (text, old_text, new_text, nth_appearance)

  • Text is an original string to use in performing substitution
  • Old_text is known as the present character to replace
  • New_text is identified as the new character to replace the old_text
  • Nth_apperance is the optional argument. It is nth appearance of the old_text that you like to replace. If the argument is deleted, then each occurrence of the old_text would be replaced with the new_text.

Excel Substitute function appears to be the same to Excel Replace Function, however this Substitute Function replaces 1 or more instances of the given text string, while Replace Function replace the text within a specified position of supplied string.

Note:

The Excel Substitute Function’s a case sensitive. Thus, when the old_text argument is text string ‘A’, it WON’T replace the occurrence of the lower case text string a.

Common Problem Substitute Function

Use of Excel Substitute Function with the numbers, dates and time

Excel substitute function’s planned for use with the text string and return a text string. Thus, when you try to use substitute function with date, time or number, it will offer you unexpected result.

The solution to the problem in conversion of time, date or number in the text, is utilizing Excel Text to Column tool.

  • Use the mouse to opt for the cells, you like to convert to the text (this shouldn’t span more than 1 column)
  • From Data tab just at the top of the Excel work book, opt for the Text Column option
  • Be sure that all of the Delimited options are selected then click next.
  • Be sure that all of the delimiter option are not selected, and then click next again.
  • You aught to be offered selection of Column data format, and then choose text and then click finish

How to Use Excel Substitute Function?

Excel Substitute function becomes helpful when you have lots of cells containing similar data format although with various values. With Substitute function, entering info is allowable only once, and then you can write formula display variation of those cells through the spreadsheet.

  • Prefer the cell where you like to key in the formula then click it using the mouse. Click the inside function box just under its Excel menu.
  • Type the function inside the format: =Substitute (“text”, “old_text”, “new_text”, “instance_num”). This text cell includes the text that you wish to substitute. ‘Old_text’ is the needed text or content to be substituted and ‘new_text’ is the required text substituting it. ‘Instance_num’ is instance of text you like to replace.
  • Make an example so you can learn how substitute function really works. Click the gray cells in order for the entire spreadsheet to be highlighted. Then click format from its menu. Opt for text.
  • Click the cell B1. Then go to function box then key in =Substitute (A1, “2”, “6”, ‘‘1’’). Click enter key and then the text inside cell B1 will appear November 6, 2008. Edit its formula and then take out 1. All occurrences of 2 would be changed in 4.
  • In function box, key in = (A1, 8, 12). Press the enter key. Year now reads 2011. In this scenario, you don’t require ‘’instance_num’’, since there’s simply one “8” that appears on its cell.
  • Get assistance and some other example of substitute function through clicking ‘help’ on Excel menu. Inside the keyword box, key in substitute work sheet function.

To sum it all, this Substitute function looks like:

SUBSTITUTE (text/ cell, old text, new text)

Then again, if it is useful to you, think about this like PHP’s str_replace or the SQL’s REPLACE.

  • Text refers to the cell reference to URL from the log file data.
  • Old text is for example www.mysite.com
  • New text is considered as the ‘’’’

Learn it or hate it, you have to know that Excel probably consumes lions share of the present day as several web analyst and search marketing experts. It is the first or the series designed to uncover and explore a few common uses of excel over laid with lots of internet marketing data task.

So, use SUBSTITUTE when you like to replace particular text in the text string, and make use of Replace if you like to replace any text which occurs in the specific location in text string.

TDIST Excel Formula

Author Zaheer    Category Formulas     Tags ,

A lot of people these days are utilizing Microsoft programs particularly companies and businesses. With Microsoft Excel, they can manage to keep and analyze data easily. Usually, companies and businesses use it as their main database. Aside from managing data, the program is also a great tool used in computing some statistical problems. But in terms of computation, it is suggested that users must know the different functions that Excel contains and be familiar with them. This is to make sure that in the end, accurate and correct results are obtained. However in Excel, you have to learn the different functions that you can use like TDIST function.

TDIST Function Description

TDIST function is used to compute percentage points for t-distribution of the numeric value of x which refers to the computed value of t with the percentage points needed to be computed. T distribution is utilized in testing the hypothesis of small sample of sets of data. This function is used in place of tables for t-distribution critical values.

Syntax for TDIST Function

In Microsoft Excel, it’s imperative for the users to know the different function syntax to make sure that they obtain the needed answer.

In the formula of the TDIST function the following arguments are included:

  • x – is considered as the numeric value needed to compute the distribution.
  • degrees_freedom – refers to the number that indicates the value of degree of freedom.
  • Tails – specify the tails of the distribution number to compute. Once the tails is equal to 1 then the answer for the function is one tailed distribution. Once the tails is equal to 2, the answer for t distribution is in two tailed distribution.

Example for TDIST Function

Take a look at the example below to learn and understand more about the function. Since you are new with this, you can try doing the function by following the given instructions below. Make sure to place in the right values and formula to avoid errors.

Calculate the t-distribution having the value of 1.81 and 75 as the degrees of freedom. Compute for the two distributions.

Given:

1.81 – value needed to compute the distribution

75 – the degrees of freedom

To compute the t-distribution using Microsoft Excel follow these procedures:

  • Open a new worksheet.
  • From the empty worksheet, place the given values. For instance, in columns A and B.
  • After placing the given values, click for an empty cell from the worksheet. The selected cell will be the location of the answer.
  • On the blank cell, type the formula for TDIST function. Since they are place at A and B column, the syntax to appear must be “=TDIST (A1, B1, 1)” for one tail distribution and “=TDIST (A1, B1, 2)” for two tail distribution.
  • After placing the needed values, press “Enter” key.
  • Right after pressing the enter tab, the answer will appear from the blank cell. For one tail distribution the answer is 0.037151 and for two tail distribution the answer is 0.074302.