Excel VBA NPV Function to calculate Net Present Value

Posted on May 7, 2016 by Wyman W

This Excel VBA tutorial explains how to calculate net present value using Excel VBA NPV Function. You may also want to read: Excel worksheet NPV Function Net Present Value Net Present Value is to calculate the present value of future cash flow. For example, your client will give you $10000 when the project completes after 1 year, assume there will be inflation, the future $10000 will be less than the present $10000. Assume the inflation is 4%, the present value of $10000 is 10000/(1+4%) ...

Excel NPV Function to calculate Net Present Value

Posted on May 6, 2016May 7, 2016 by Wyman W

This Excel tutorial explains how to calculate net present value using Excel NPV Function. You may also want to read: Excel VBA NPV Function Net Present Value Net Present Value is to calculate the present value of future cash flow. For example, your client will give you $10000 when the project completes after 1 year, assume there will be inflation, the future $10000 will be less than the present $10000. Assume the inflation is 4%, the present value of $10000 is 10000/(1+4%) = 9615.384615 ...

Excel CORREL Function to calculate coefficient of correlation

Posted on April 30, 2016 by Wyman W

This Excel tutorial explains how to use Excel CORREL Function to calculate coefficient of correlation. Coefficient of Correlation Covariance is a measure of how much two random variables change together. After calculating covariance, we can check the sign whether it is negative or positive. Positive covariance means positive relationship (y increases as x increases), negative covariance means a negative relationship (y decreases as x increases). In order to measure the strength of relation...

Excel calculate covariance using COVARIANCE.S and COVARIANCE.P

Posted on April 29, 2016 by Wyman W

This Excel tutorial explains how to calculate sample covariance using COVARIANCE.S and calculate population covariance using COVARIANCE.P Covariance Covariance is a measure of how much two random variables change together. The below formula is for calculation of Population Covariance. For Sample Covariance, divide n-1 instead of N. While σx is denoted as standard variation of x, σxy is denoted as Covariance. After we calculate the covariance, we can check the sign whether it is ne...

SPSS test reliability using Cronbach’s Alpha

Posted on April 22, 2016 by Wyman W

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

SPSS generate random number (decimal and whole number)

Posted on April 20, 2016 by Wyman W

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

SPSS Simple Random Sampling using Select Cases

Posted on April 19, 2016 by Wyman W

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

SPSS Automatic Recode

Posted on April 18, 2016 by Wyman W

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

Protect VBA code with password

Posted on April 18, 2016 by Wyman W

This Excel VBA tutorial explains how to protect VBA code with password. You may also want to read: Excel VBA protect worksheet with password Excel VBA hide worksheet with password (xlVeryHidden) Excel VBA Add password to Excel workbook in folder Protect VBA code with password When you write Macro / VBA code in Excel, other people can easily see the source code by clicking ALT+F11 and then copy / modify your code. If you do not want anyone to see the VBA code (to steal your hard wo...

SPSS Excel Multiple Regression

Posted on April 5, 2016 by Wyman W

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