<div>
The square of the population standard deviation (Excel STDEVP function) is the variance.<br />
=POWER(STDEVP(A:A),2)
</div>


<div>
The_Barman,<br />
<br />
If I receive a value of .348, does that mean there is little correlation?
</div>


<div>
correct.<br />
<br />
Correlation Coeficient runs between 1 and -1 with 1 being perfect positive corelation and 0 being no correlation.<br />
Correlation above .8 or below -.8 are good. Between .5 and -.5 is poor correlation.<br />
<br />
As .348^2 (.348 squared) = 0.1211 = 12%<br />
Only 12% of the change in the Y value can be attributed to variation in the X value.
</div>


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have to columns of data. &nbsp;One has the number of claims for a member. &nbsp;The other has the number of months the member is enrolled.<br />
<br />
i am trying to calculate the variance to see if there is a correlation between the two. &nbsp;Does anyone have any idea how I would dot this in Excel.<br />
<br />
Using ColumnA as number of claims<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ColumnB as number of months enrolled
</div>
</div>


Experts,

I have to columns of data.  One has the number of claims for a member.  The other has the number of months the member is enrolled.

i am trying to calculate the variance to see if there is a correlation between the two.  Does anyone have any idea how I would dot this in Excel.

Using ColumnA as number of claims
          ColumnB as number of months enrolled

The square of the population standard deviation (Excel STDEVP function) is the variance.
=POWER(STDEVP(A:A),2)

The_Barman,

If I receive a value of .348, does that mean there is little correlation?

correct.

Correlation Coeficient runs between 1 and -1 with 1 being perfect positive corelation and 0 being no correlation.
Correlation above .8 or below -.8 are good. Between .5 and -.5 is poor correlation.

As .348^2 (.348 squared) = 0.1211 = 12%
Only 12% of the change in the Y value can be attributed to variation in the X value.

caculating a variance in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

The Math / Science topic primarily includes discussions of mathematics, physics, statistics and economic analysis, but also biology, chemistry and other sciences.