Statistical Calculation

[Aslam]

HOW TO CALCULATE COEFFICIENT OF COORELATION from following data:

X 2 4 5 6 8 11
Y 18 12 10 8 7 5



how to use Excel Regression tool from followinng data

X 74 93 55 41 23 92 64 40
71 33 30 71


Y 81 86 67 35 30 100 55 52 76 24 48 87


thanks

 

[Mike Middleton]

Aslam -

One way: Enter the data in columns on a worksheet.

Use the CORREL worksheet function for the coeff. of correlation.

Choose Tools | Data Analysis | Regression to perform regression.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel