cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Bekzod
Level I

How to derive variance given the data on excel sheet?

Dear community,

 

I've been trying to derive variance on jmp. I imported excel file with data (it has two columns only). I followed Analyze--> Distribution process and the answer is as shown below screenshot. Please instruct me further how to get variance

 

Bekzod_0-1694998482128.png

 

2 REPLIES 2
txnelson
Super User

Re: How to derive variance given the data on excel sheet?

The variance is just Std Dev squared.

8.6015451 x 8.6015451 = 73.986578107334

or

8.6015451^2 = 73.986578107334

Jim
jthi
Super User

Re: How to derive variance given the data on excel sheet?

You can also add Variance to Summary Statistics from Customize Summary Statistics

jthi_0-1695011323250.png

jthi_1-1695011338100.png

Basic Analysis > Distributions > The Distribution Report 

-Jarmo