# Excel T.TEST Function to perform Student’s T Test

This Excel tutorial explains how to use T.TEST Function to perform Independent Sample T Test and Paired-samples T Test. What is Independent T Test In statistical inference, we are interested to know whether a small sample comes from a population. To inference using sample mean, when the population standard deviation and population mean are known, we can use Z test to interference the population mean from sample mean. In reality, we do not have data of the whole population. Without the popul...
More

# Excel CORREL Function to calculate coefficient of correlation

This Excel tutorial explains how to use Excel CORREL Function to calculate coefficient of correlation. Coefficient of Correlation Covariance is a measure of how much two random variables change together. After calculating covariance, we can check the sign whether it is negative or positive.  Positive covariance means positive relationship (y increases as x increases), negative covariance means a negative relationship (y decreases as x increases). In order to measure the strength of relation...
More

# Excel calculate covariance using COVARIANCE.S and COVARIANCE.P

This Excel tutorial explains how to calculate sample covariance using COVARIANCE.S and calculate population covariance using COVARIANCE.P Covariance Covariance is a measure of how much two random variables change together. The below formula is for calculation of Population Covariance. For Sample Covariance, divide n-1 instead of N. While σx is denoted as standard variation of x, σxy is denoted as Covariance. After we calculate the covariance, we can check the sign whether it is ne...
More

# SPSS Excel Multiple Regression

This SPSS Excel tutorial explains how to run Multiple Regression in SPSS and Excel. You may also want to read: simple linear regression Multiple Regression (Multiple Linear Regression) Regression analysis is to predict the value of one interval variable based on another interval variable(s) by a linear equation. We draw a random sample from the population and draw the best fitting straight line in order to estimate the population. The straight line is known as least squares or regression...
More

# SPSS Excel Simple Linear Regression

This SPSS Excel tutorial explains how to run Simple Linear Regression in SPSS and Excel. You may also want to read: SPSS Excel Multiple Regression Simple Linear Regression Regression analysis is to predict the value of one interval variable based on another interval variable(s) by a linear equation. We draw a random sample from the population and draw the best fitting straight line in order to estimate the population. The straight line is known as least squares or regression line. ...
More

# SPSS Excel Paired Samples T Test

This SPSS Excel tutorial explains how to conduct Paired Samples T Test in Excel and SPSS. Paired Samples T Test In statistical inference, we are interested to know whether a small sample comes from a population. To inference using sample mean, when the population standard deviation and population mean are known, we can use Z test to interference the population mean from sample mean. In reality, we do not have data of the whole population. Without the population standard deviation, we use T ...
More

# SPSS Excel Independent T Test

This SPSS Excel tutorial explains how to perform one tailed and two tailed Independent T Test in Excel and SPSS. What is Independent T Test In statistical inference, we are interested to know whether a small sample comes from a population. To inference using sample mean, when the population standard deviation and population mean are known, we can use Z test to interference the population mean from sample mean. In reality, we do not have data of the whole population. Without the population...
More

# SPSS Excel One Way ANOVA

This SPSS Excel tutorial explains how to calculate One Way ANOVA in SPSS, Excel and manual calculation. SPSS Excel One Way ANOVA To determine if a sample comes from a population, we use one sample t test or Z Score. To determine if two samples have the same mean, we use independent sample t test. To determine if differences exist between two or more population means, we use One Way ANOVA (abbreviation of one way analysis of variance). The test statistics is called F test, it requires tha...
More

# SPSS Excel Chi Squared Test of Contingency Table

This Excel / SPSS tutorial explains how to calculate Chi Squared Test of Contingency Table in Excel, SPSS and manual calculation. You may also want to read: Excel SPSS Chi Squared Goodness of fit test SPSS Excel Chi Squared Test of Contingency Table Chi Squared Test of Contingency Table is used to infer whether two nominal variables in the population are related. In Excel, Contingency Table is a Pivot Table where we have a variable in the column and a variable in row, and count the frequ...
More

# Excel SPSS Chi Squared Goodness of fit test

This SPSS/Excel tutorial explains how to use Chi Squared Goodness of fit test in Excel, SPSS and manual calculation. You may also want to read: SPSS Excel Chi Squared Test of Contingency Table Chi Squared Goodness of fit test Chi Squared Goodness of fit test is used to test hypotheses about a population proportion of nominal data. A coin flipping experiment has the chance of tossing head and tail (p=0.5), we call the experiment binomial experiment, where we only have two possibilities an...
More