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

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #278804

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

qa-featured

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”.

excel

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.

excel1

Login/Register to Answer

Related Questions