# SPSS test reliability using Cronbach’s Alpha This SPSS tutorial explains how to test reliability using Cronbach's Alpha in SPSS. What is reliability and Cronbach's Alpha Reliability means whether the data are consistent using different instruments to measure the data. One example is the questionnaire design, in which more than one questions are asking the same thing but using different wordings. If the answers are inconsistent then the data has low reliability. Cronbach's Alpha is a common measure for reliability and internal consistency...
More

# SPSS generate random number (decimal and whole number) This SPSS tutorial explains how to generate random number in SPSS (decimal and whole number). You may also want to read: Excel VBA generate non-duplicated random number Assign unique random number using Excel SPSS generate random number (decimal number) Assume that we have 10 data from 1 to 10.   Navigate to Transform > Compute Variable   On the left hand side, type a name for the Target Variable, which is the new variable that contains the random nu...
More

# SPSS Simple Random Sampling using Select Cases This SPSS tutorial explains how to conduct Simple Random Sampling using Select Cases in SPSS. You may also want to read: Excel VBA generate non-duplicated random number Assign unique random number using Excel SPSS Simple Random Sampling In conventional simple random sampling, you need to assign an ascending number to each value of a variable and then generate a random number to help you select the corresponding data. While SPSS can generate random number using Compute Variable, it ...
More

# SPSS Automatic Recode This SPSS tutorial explains how to use SPSS Automatic Recode to convert variable from string to number (from Nominal to Scale). SPSS Automatic Recode In SPSS, the ideal data source is to convert all nominal data to numeric data, and then use Value Labels to map the corresponding text, it is because many analysis cannot use nominal data. Automatic Recode is a function to create a new column and automatically convert nominal variable from text to number. It also allows conversion of numeric v...
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