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