View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aslam Aslam is offline
external usenet poster
 
Posts: 5
Default Statistical Calculation


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