Different values for variance and std. dev in JMP vs. Excel...why?
I'm transforming some data into ZScores. A friend transformed the data in excel and the values came up slightly different than those in JMP. When trying to track down why, I found that the variance and standard deviation in excel differed from JMP. I decided to calculate the standard deviation by hand, using excel as a glorified calculator. My variance and standard deviation still came out dif...
