SPSS Excel one sample T Test

Posted on October 25, 2015April 3, 2016 by Wyman W

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

SPSS Select Cases (filter data)

Posted on October 21, 2015October 21, 2015 by Wyman W

This SPSS tutorial explains how to filter data using Select Cases Function. SPSS Select Cases (filter data) In Excel, you can apply Autofilter and enter criteria to select data what you want. SPSS has similar function but it is called "Select Cases". In this tutorial, we will talk about the options are available to facilitate data filtering. Navigate to Data > Select Cases There are several options in this Select Cases box. We will talk about each option in the below sec...

Statistics Hypothesis Testing

Posted on October 16, 2015October 24, 2015 by Wyman W

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

Excel VBA clear cell contents with ClearContents Method

Posted on October 15, 2015October 16, 2015 by Wyman W

This Excel tutorial explains how to clear cell contents / clear cell formats using Clear, ClearContents, ClearFormats Method. Excel VBA clear cell contents There are several kinds of "clear" related Excel VBA Methods for different scenarios. I will also explain how to clear single cell contents, clear merged cells contents, and clear blank cells. Clear single cell contents with ClearContents There are two ways to clear single cell contents (clear value in a Cell but not formatting) As...

Excel Delete Blank Rows

Posted on October 12, 2015February 26, 2017 by Wyman W

This Excel tutorial explains how to delete blank rows in Excel with VBA and without VBA. You may also want to read: Excel delete blank rows and blank cells before import into Access Excel delete duplicated data in consecutive rows Excel Delete Blank Rows Sometimes we have data that contains blank rows, one example is data with pivot table layout where data are grouped together and repeated items are blank. Previously I wrote a post about filling blank rows, this post is about delet...

SPSS Import Text File

Posted on October 2, 2015 by Wyman W

This SPSS tutorial explains how to import text file into SPSS. SPSS Import Text File Navigate to File > Open > Data Select Text in Files of Type, and then select the target text file Step 1 Does your text file match a predefined format? Leave the option default as No if this is the first time you import this file. Select Yes if you have previously saved the format in your last import. Step 2 How are your variables arranged? Wh...

SPSS Excel Covariance, Correlation, Least Squares Method

Posted on September 28, 2015April 3, 2016 by Wyman W

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

Calculate Z Score and probability using SPSS and Excel

Posted on September 14, 2015March 27, 2016 by Wyman W

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

Calculate probability of a range using Z Score

Posted on September 13, 2015October 26, 2015 by Wyman W

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

Import Excel into SPSS

Posted on September 11, 2015 by Wyman W

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