Learn How To Do A “Multiple Linear Regression In Excel”

Asked By Grace Caldwell 0 points N/A Posted on - 11/12/2016

Hi I am not good with the computer I want to complete my assignment of multiple linear regression in excel, can someone help me out? Please reply ASAP

• Status: Open
• Question Views: 690
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Office
• Question Tags: Document | MS Office

Answered By edwin atestain 0 points N/A #278804

Learn How To Do A “Multiple Linear Regression In Excel”

Hii if you wanted to use Excel, it’s the best way, and you have to follow some simple steps.
First of all open Excel and check that “Data” tab is visible to you or not, if it’s not, then you have to go to “Files” tab on top left>”options”>”Adds-in”>select “Analysis ToolPak”>Click “Go” next to manage>check the “Analysis toolpak”>click “OK”.
Open your file> select “Data” tab>Select “Data Analysis”.

Now input the data of Y cell in the Input Y Range.
Similarly, input the data of X1 and X2 in Input X Range.
Click “Ok” and Analysis will be done.

About edwin atestain

Questions
9

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/12/2016
• Question Category: Microsoft Office