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

More
# Statistics

# 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...

More
# Create Excel Histogram

This Excel tutorial explains how to create Excel Histogram.
You may also want to read:
Excel clustered column chart
Excel scatter chart using text name
Definition of Histogram
Before reading this post, you are recommended to read my below post.
Types of data in statistics (Interval, Nominal, Ordinal).
Histogram is a column chart that counts frequency of numbers and categorize the numbers into numerical groups (the groups are called bins). Usually people don't leave space between t...

More
# SPSS Excel one sample T Test

This tutorial explains how to use Excel and SPSS to perform one sample T Test.
You may also want to read:
Statistics Hypothesis Testing
Calculate Z Score and probability using SPSS and Excel
What is 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 rea...

More
# Statistics Hypothesis Testing

This tutorial explains the concepts of hypothesis testing in statistics.
Hypothesis Testing
Many text book uses the court case example to explain hypothesis testing. In the U.S. (but not all countries), the court finds evidence to prove the defendant guilty, instead of proving the defendant innocent.
There are two hypothesis for a court case:
The defendant is guilty - when we have a theory and try to prove it, the hypothesis is called H1
The defendant is innocent - the alternat...

More
# SPSS Excel Covariance, Correlation, Least Squares Method

This SPSS Excel tutorial explains how to calculate Covariance, Correlation and Least Squares Method in Excel and SPSS.
Covariance and Correlation
When we plot a scattered graph to see the relationship between two interval variables, we can see how straight a line is formed (whether the relationship is strong) and whether the relationship is positive or negative (upward or download).
However, when we want to look deeper to see the strength of the relationship, we need to calculate covari...

More
# Calculate Z Score and probability using SPSS and Excel

This tutorial explains how to calculate Z Score and probability using SPSS and Excel.
You may also want to read
SPSS Excel one sample T Test
Calculate probability of a range using Z Score
Calculate Z Score and probability using SPSS and Excel
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 popula...

More
# Calculate probability of a range using Z Score

This tutorial explains how to calculate probability of a range using Z score (standard normal random variable).
You may also want to read:
Excel Range, Variance, Standard Deviation
Calculate Z Score and probability using SPSS and Excel
SPSS Excel one sample T Test
Calculate probability of a range using Z Score
Assume that a random variable is a normally distributed (a normal curve), given that we have the standard deviation and mean, we can find the probability that a certain value ran...

More
# Import Excel into SPSS

This SPSS tutorial explains how to import Excel into SPSS.
Import Excel into SPSS
It is easy to import Excel into SPSS but you should note that SPSS will automatically define each variable, some of them can be correct and some incorrect (this is very similar to Microsoft Access). In this tutorial, I will demonstrate how to import Excel into SPSS and how SPSS guesses the variable types, I will try too cover the most common scenario.
Lets say we have the following table in Excel, which contai...

More
# Excel calculate Covariance, Coefficient of Correlation

This Excel tutorial explains the meaning and calculation of Covariance and Coefficient of Correlation.
You may also want to read:
Excel Range, Variance, Standard Deviation
Covariance, Coefficient of Correlation
Assume that we have two sets of data - English and Mathematics results for each student. How can we tell whether English result has any relationship with Mathematics result?
Name of Student
English Result
Math Result
John
50
60
Mary
60
70
Peter
70
80
...

More