How do I do regression analysis in excel?



How do I do regression analysis in excel?..

Answer / Arvind Chaudhary

To perform a linear regression analysis in Excel, go to 'Data' > 'Data Analysis', then select 'Regression'. Enter your input range (independent variable) and output range (dependent variable). Choose Output range and Options as desired, then click OK.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is function in ms excel with example?

1 Answers  


Please tell me how I can split combined data into separate columns in an excel spreadsheet. For example I have a spreadsheet that contains the city and state (i.e.kennett square, pa) in the same column and I would like to have them in two separate columns?

1 Answers  


How do I create a conditional formula in excel?

1 Answers  


How do I create a data connection in excel?

1 Answers  


How can I convert figures into words in excel?

1 Answers  


How you can sum up the rows and column number quickly in the excel sheet?

1 Answers  


Can you merge cells in excel?

1 Answers  


What does the indirect function do in excel?

1 Answers  


How do you auto adjust cells in excel?

1 Answers  


What is a nested if statement?

1 Answers  


What is a what if scenario?

1 Answers  


How do I use solver constraints in excel?

1 Answers  


Categories