View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how i calculate pearson correlation coefficient for excel graph

In a cell in the worksheet, enter this formula

=CORREL({y range},{x range})

where {x range} and {y range} are the ranges occupied by the X and Y values
in the sheet. You can select them by clicking and dragging while you are
entering the formula.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"university student that is lost" <university student that is
wrote in message
...
how do I calculate the pearson correlation coefficient for on microsoft
excel
for a grapg of information. If it is not possible is there another program
that can do this for me?