can somebody help me in doing a REGRESSION ANALYSIS, and  or Correlation in Microsoft Excel, in simple word?
463366
when you know your range of y's and x's, then in excel you click on fx (formula function)key menu to display and insert the formula using the parameters requested.
550410
There are a lot of software libraries that do that:\n\nhttp://tinyurl.com/k9zah\n\nincluding some for Excel:\n\nhttp://tinyurl.com/hrda7
705232
Regression is basically trying to draw a line of best fit through a set of data to see if a (typically linear) relationship exists between the 2 variables.  A regression equation is expressed as y = mx + c where y is the independent variable, x is the dependent variable and m is the slope of the line.\n\nTo use regression in excel, highlight the data you want to use and go to Tools > Data Analysis > Regression. Try the excel help function an read up about regression analysis on wikipedia.
924855
The CORREL() function in many major spreadsheet packages, such as Microsoft Excel and Gnumeric calculates Pearson's correlation coefficient.
583560
Here you go:\n\nhttp://www.usd.edu/trio/tut/excel/index.html
967626
EXCELL - Spreadsheets
574840
I suppose it kind of depends on what kind of raw data, and what kind of software you have.\n\nI have had good luck importing txt files into Excel...From there, you can analyze and manipulate it at your leisure.
129909
You might find the following informative:\nhttp://www2.mtroyal.ab.ca/~igilborn/admn1382/regression/theory/part_b.htm
775593
Load the Analysis Toolpak add-in and then use this formula, it's shorter:\n\n=A1/GCD(A1, B1)&":"&B1/GCD(A1, B1)
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
979232
Use microsoft excel or go here to get a free open source office download http://lost-newbie.blogspot.com/
1089446
You can use a spreadsheet. Then resort.\n\nAnother way is to put things in a regular word processing document and cut and paste into another one. \n\nDepends on what you prefer to do.
572168
In general, one of the best Excel answer sites I have found is MrExcel.com (link below).  But in any case, the better you state your problem the better the advice you'll get.\n\nFor example, how many pages do your reports run?  What do you hope to gain by converting them from Excel to Word?  Are you aware of other solutions, such as 'printing' your report to a PDF file?  (CutePDF, for one example)  Finally, is this something that could be handled by MailMerge (if you know what that is)?  If you don't understand MailMerge, you can look it up in Word's help.
831403
I guess you don't have Excel.\nGet OpenOffice.\nwww.openoffice.org
33456
lotus is an older program. excel is best. but annoying when it comes to formulas.
919222
The correlation coefficient is a number between -1 and 1 that measures the degree in which values in a sample space are linearly related. Graph the points and see how they are related spatially, if the points form something that looks like a blob  then the correlation coefficient is zero, or there is no linear relationship. If the points form a perfect line with a positive slope, then the correlation coefficient  is  1. If the points form a perfect line with a negative slope, then the correlation coefficient is  -1. So when you graph your sample space make a guess at where the data falls within the range of -1 to 1. Hope this helps.\n\nP.S. Use excel and you can graph those points quickly.
332491
Try digdb excel add-in\n\nthis is the linke you need