Statistical Calculation

A

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top