Multiple Linear Regression

sssb2000

Well-known Member
how can i find the "Multiple Linear Regression" for the measure of effectiveness (FER).

i need to know how the Beta (b) is calcualted. (ie. -495.3846154, 1869.358974, 96.92307692, -392.1794872, -253.974359, -301.5384615 values)

ANY suggestions? :-\

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=11><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - New_Opt_WB - siroos.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=11><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=11><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value==LINEST(I6:I13,D6:H13) selected>K6<OPTION value==LINEST(I6:I13)>K13<OPTION value==AVERAGE(I6:I13)>I14<OPTION value==C\$17>C20<OPTION value==D6*D\$17>D20<OPTION value==E6*E\$17>E20<OPTION value==F6*F\$17>F20<OPTION value==G6*G\$17>G20<OPTION value==H6*H\$17>H20<OPTION value==SUM(C20:H20)>I20<OPTION value==C\$17>C21<OPTION value==D7*D\$17>D21<OPTION value==E7*E\$17>E21<OPTION value==F7*F\$17>F21<OPTION value==G7*G\$17>G21<OPTION value==H7*H\$17>H21<OPTION value==SUM(C21:H21)>I21<OPTION value==C\$17>C22<OPTION value==D8*D\$17>D22<OPTION value==E8*E\$17>E22<OPTION value==F8*F\$17>F22<OPTION value==G8*G\$17>G22<OPTION value==H8*H\$17>H22<OPTION value==SUM(C22:H22)>I22<OPTION value==C\$17>C23<OPTION value==D9*D\$17>D23<OPTION value==E9*E\$17>E23<OPTION value==F9*F\$17>F23<OPTION value==G9*G\$17>G23<OPTION value==H9*H\$17>H23<OPTION value==SUM(C23:H23)>I23<OPTION value==C\$17>C24<OPTION value==D10*D\$17>D24<OPTION value==E10*E\$17>E24<OPTION value==F10*F\$17>F24<OPTION value==G10*G\$17>G24<OPTION value==H10*H\$17>H24<OPTION value==SUM(C24:H24)>I24<OPTION value==C\$17>C25<OPTION value==D11*D\$17>D25<OPTION value==E11*E\$17>E25<OPTION value==F11*F\$17>F25<OPTION value==G11*G\$17>G25<OPTION value==H11*H\$17>H25<OPTION value==SUM(C25:H25)>I25<OPTION value==C\$17>C26<OPTION value==D12*D\$17>D26<OPTION value==E12*E\$17>E26<OPTION value==F12*F\$17>F26<OPTION value==G12*G\$17>G26<OPTION value==H12*H\$17>H26<OPTION value==SUM(C26:H26)>I26<OPTION value==C\$17>C27<OPTION value==D13*D\$17>D27<OPTION value==E13*E\$17>E27<OPTION value==F13*F\$17>F27<OPTION value==G13*G\$17>G27<OPTION value==H13*H\$17>H27<OPTION value==SUM(C27:H27)>I27<OPTION value==SUM(J20:J27)>J28<OPTION value==SUM(K20:K27)>K28</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==LINEST(I6:I13,D6:H13) name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">

Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Replies
3
Views
116
Replies
0
Views
204
Replies
5
Views
563
Replies
13
Views
1K
Replies
4
Views
627

1,136,368
Messages
5,675,358
Members
419,565
Latest member
Phil57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back