Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Statistical Calculation
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 "Aslam" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Statistical Information | Excel Worksheet Functions | |||
Need statistical help | Excel Worksheet Functions | |||
Statistical add-ins | Excel Discussion (Misc queries) | |||
statistical functions | Excel Worksheet Functions | |||
Statistical Function | Excel Worksheet Functions |