User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Bekzod
Bekzod
Level I

How to derive variance given the data on excel sheet?

Sep 17, 2023 08:56 PM (1083 views)

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

 

0 Kudos
2 REPLIES 2
txnelson
Super User txnelson
Super User

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

Sep 17, 2023 09:15 PM (1079 views)  |  Posted in reply to message from Bekzod 09-17-2023

The variance is just Std Dev squared.

8.6015451 x 8.6015451 = 73.986578107334

or

8.6015451^2 = 73.986578107334

Jim
0 Kudos
jthi
Super User jthi
Super User

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

Sep 18, 2023 12:29 AM (1073 views)  |  Posted in reply to message from Bekzod 09-17-2023

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

Recommended Articles