SPSS Excel Simple Linear Regression

Posted on April 4, 2016April 5, 2016 by Wyman W

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

SPSS Excel Paired Samples T Test

Posted on April 3, 2016May 19, 2016 by Wyman W

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

SPSS Excel Independent T Test

Posted on April 2, 2016November 13, 2016 by Wyman W

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

SPSS Excel One Way ANOVA

Posted on March 28, 2016April 2, 2016 by Wyman W

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

SPSS Excel Chi Squared Test of Contingency Table

Posted on March 26, 2016 by Wyman W

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

Excel SPSS Chi Squared Goodness of fit test

Posted on March 26, 2016March 26, 2016 by Wyman W

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

Access Report group by date problem

Posted on March 25, 2016 by Wyman W

This Access tutorial explains how to group by date (one date for each group) in Access Report and explain the issue. You may also want to read: Access Report keep a group together in one page Access Report group by date problem When you create an Access Report, the default setting isn't group by date. To illustrate, assume that we have an employee database as below. Table1 Hire Date Employee ID 20/12/2016 001 20/12/2016 002 21/12/2016 003 21/12/2016...

Excel VBA reformat merged cells to row

Posted on March 24, 2016March 4, 2017 by Wyman W

This Excel tutorial explains how to use Excel VBA to reformat merged cells to row. You may also want to read: Fill Blank Rows or blank Cells Seperate line break data into different rows Excel VBA unmerge columns automatically Excel VBA reformat merged cells to row It is difficult to decide the title of this post, I will illustrate with an example. Imagine a Table with column A being a merged cell, and column B are the items under the same group. When you apply filter on c...

Excel VBA generate non-duplicated random number

Posted on March 20, 2016March 20, 2016 by Wyman W

This Excel VBA tutorial explains how to generate non-duplicated random number using Excel VBA. You may also want to read: Generate random letter A to Z Generate random HKID Hong Kong ID Excel VBA generate non-duplicated random number In my previous post, I demonstrated how to assign random number to a value using Rank Function and Rand Function. In this post I will introduce a more direct approach to assign a random number with the help of VBA. In this approach, each time after a r...

Excel Rank Function

Posted on March 18, 2016 by Wyman W

This tutorial explains how to use Excel Rank Function to give a number a rank in a range of number. Syntax of Rank Function RANK(number,ref,[order]) Number Required. The number whose rank you want to find. Ref Required. An array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored. Order Optional. A number specifying how to rank number. If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order. I...