Calculate the t value in excel with the means standard deviation and degrees of freedomsince the t value is a comparison between sample mean and population mean both values need to be available in order for you to calculate the t value values.
observe the given two set of values calculate the mean and standard deviation for each and individual set of values apply the formula to calculate the t test value t frac bar x 1 bar x 2 sqrt frac s 1 2 n 1 frac s 2 2 n 2 where bar x 1 the mean of first set of values bar x 2 the mean of second set of values s 1 2 the standard deviation of first the p value is the area to the right of the test statistic if the test statistic is on the right 2 t table p values use choice 6 tcdf the p values for the t table are found in a similar manner as with the z table except we must include the degrees of freedom the p value is the area to the right of the test statistic if the test statistic is on the right 3 chi square table p values use choice 8 χ 2 cdf the p values for the χ 2 table are found in a similar manner as with the t table the calculator will expect χ 2 cdf loweround upperbound df two tailed probability value α one tailed probability value α two tailed t value one tailed t value code to add this calci to your website just copy and paste the below code to your webpage where you want to display this calculator the critical value calculation is based on t table  one way around this is to make sure that all of the t scores are negative you can do this by taking the negative of the absolute value of the t scores the results from the command above should give you the p values for a one sided test it is left as an exercise how to find the p values for a two sided test the easy way the methods above demonstrate how to calculate the p values directly making use of the standard formulae there is another more direct way to do this using the t test command the t test command takes a data set for an argument and the default operation is to perform a two sided hypothesis test available calculation methods to calculate values in a pivottable report you can use any or all of the following types of calculation methods summary functions in value fields the data in the values area summarize the underlying source data in the pivottable report use a calculated field when you want to use the data from another field in your formula use a calculated item when you want your formula to use data from one or more specific items within a field do one of the following add a calculated field click the p value is calculated for a particular sample mean here we assume that we obtained a sample mean x and want to find its p value it is the probability that we would obtain a given sample mean that is greater than the absolute value of its z score or less than the negative of the absolute value of its z score the easy way the methods above demonstrate how to calculate the p values directly making use of the standard formulae there is another more direct way to do this using the t test command the t test command takes a data set for an argument and the default operation is to perform a two sided hypothesis test to select the highlighted 2 t test press enter use right arrow to select stats summary values rather than raw data and press enter use the down arrow to enter the hypothesized mean sample mean standard deviation and sample size select alternate hypothesis press down arrow to select calculate and press enter  10 4 the methods above demonstrate how to calculate the p values directly making use of the standard formulae there is another more direct way to do this using the t test command the t test command takes a data set for an argument and the default operation is to perform a two sided hypothesis test the easy way the methods above demonstrate how to calculate the p values directly making use of the standard formulae there is another more direct way to do this using the t test command the t test command takes a data set for an argument and the default operation is to perform a two sided hypothesis test t values also known as t statistics calculate the likeliness that a population mean is true given a sample mean you can calculate the t value in excel with the means standard deviation and degrees of freedom since the t value is a comparison between sample mean and population mean both values need to be available in order for you to calculate the t value 
http://calculator.tutorvista.com/t-test-calculator.html http://homepage.smc.edu/mcgraw_colleen/math_52/Finding%20%20p-values.pdf https://www.easycalculation.com/statistics/critical-t-test.php http://www.cyclismo.org/tutorial/R/pValues.html https://support.office.com/en-us/article/calculate-values-in-a-pivottable-report-697406b6-ee20-4a39-acea-8128b5e904b8 http://www.cyclismo.org/tutorial/R/pValues.html http://cfcc.edu/faculty/cmoore/TI83TTest.htm http://www.cyclismo.org/tutorial/R/pValues.html http://smallbusiness.chron.com/calculate-tvalue-mean-standard-deviation-excel-29214.html
how to find calculated t value