[R] Variance is different in R vs. Excel?

2015-02-09 Thread Karl Fetter
Hello everyone, I have a simple question. when I use the var() function in R to find a variance, it differs greatly from the variance found in excel using the =VAR.S function. Any explanations on what those two functions are actually doing? Here is the data and the results:

Re: [R] Variance is different in R vs. Excel?

2015-02-09 Thread David L Carlson
University College Station, TX 77840-4352 -Original Message- From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Karl Fetter Sent: Monday, February 9, 2015 3:33 PM To: r-help@r-project.org Subject: [R] Variance is different in R vs. Excel? Hello everyone, I have a simple question

Re: [R] Variance is different in R vs. Excel?

2015-02-09 Thread Ted Harding
] Variance is different in R vs. Excel? Hello everyone, I have a simple question. when I use the var() function in R to find a variance, it differs greatly from the variance found in excel using the =VAR.S function. Any explanations on what those two functions are actually doing? Here

Re: [R] Variance is different in R vs. Excel?

2015-02-09 Thread Ranjan Maitra
Of Karl Fetter Sent: Monday, February 9, 2015 3:33 PM To: r-help@r-project.org Subject: [R] Variance is different in R vs. Excel? Hello everyone, I have a simple question. when I use the var() function in R to find a variance, it differs greatly from the variance found in excel using