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
# Chapter 6 – By Excel Topic

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

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

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

More