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 ...
Read 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...
Read 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...
Read 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...
Read 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...
Read More

Assign unique random number using Excel

This tutorial explains how to use assign unique random number using Excel. You can apply this skills to Simple Random Sampling. You may also want to read: Generate random letter A to Z Generate random HKID RANDBETWEEN Function Assign unique random number using Excel There are several ways to assign unique random number, the simplest way to do it is to use Worksheet Rand Function. You can apply this skills to Simple Random Sampling. Rand Function generates a decimal number from 0...
Read More

Excel first date of month and last date of month

This Excel tutorial explains how to find first date of month, last date of month using Excel worksheet Function and Excel VBA Function. You may also want to read: Excel Use Date in IF Condition Excel first date of month To find first date of month in Excel, first we have to understand DATE Function, you can use it to combine the year, month and day to a date. Syntax of Date Function DATE( year, month, day ) Example Formula Result Explanation =Date(2012,1,1) 1/1/2012 Co...
Read More

Excel Descriptive Statistics

This Excel tutorial explains how to interpret the summary table generated from Excel Descriptive Statistics. Excel Descriptive Statistics One of the options under DATA > Data Analysis is Descriptive Statistics, which generates a statistics summary of a variable. It is very useful because it saves you a lot of time from entering a lot of formulas in order to get some basic analysis. Before using Excel Descriptive Statistics feature, you should first install Analysis Toolpak Add-Ins. As...
Read More

Excel Hyperlink Function

This Excel tutorial explains how to use Excel Hyperlink Function to add hyperlink to Cell and send email. Excel Hyperlink Function Excel Hyperlink Function is to add a hyperlink to a Cell. You can add hyperlink without using any Function. Right click on a Cell and then select Hyperlink to enter a web address or email address. With Excel Hyperlink Function, you only need to enter arguments for the Function instead of right clicking a Cell. This is useful if you are trying to create a ...
Read More

Excel dynamic data range

This Excel tutorial explains how to create Excel dynamic data range using Name Range. You may also want to read: Excel dynamic Data Validation list Excel Dynamic Print Area Excel graph dynamic data range Excel dynamic data range The purpose of Excel dynamic data range is to select data range based on how many data you have input instead of using a fixed range. Assume that you have the data set below. You can select A1 to B11 as the data source, but if you do that, you n...
Read More