multiple regression

Hi,

I need to use linear regression to make a prediction using 3 independet
valuables.
I went to tools->data analysis-->and chose "regression" in the pop-up window.
But, after I got a window for regression, I see only two text boxes to
insert independent variables though I uses 3 variables.

Does anybody know how I can get a data analysis tool which is used for more
than 2 independent valuables?

Actually, there is only one box for the independent variables.

To specify multiple independent variables simply specify the larger
range. For example, if the values for the three indepdendent variables
are in A2:C23, specify that as the range for the 'Input X Range'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> Hi,
>
> I need to use linear regression to make a prediction using 3 independet
> valuables.
> I went to tools->data analysis-->and chose "regression" in the pop-up window.
> But, after I got a window for regression, I see only two text boxes to
> insert independent variables though I uses 3 variables.
>
> Does anybody know how I can get a data analysis tool which is used for more
> than 2 independent valuables?
>

Thank you for your quick response! I appreciate!!

But, I still see two boxes in the window.
I also tried to specify two columns for a box, but it does not accept
several range and said to select a single row.
I think I'm using something different from what you taught me.

Could you tell me how did you get the window which has the only one box for
the independent variables?

Best regards,

"Tushar Mehta" wrote:

> Actually, there is only one box for the independent variables.
>
> To specify multiple independent variables simply specify the larger
> range. For example, if the values for the three indepdendent variables
> are in A2:C23, specify that as the range for the 'Input X Range'.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <[email protected]>,
> [email protected] says...
> > Hi,
> >
> > I need to use linear regression to make a prediction using 3 independet
> > valuables.
> > I went to tools->data analysis-->and chose "regression" in the pop-up window.
> > But, after I got a window for regression, I see only two text boxes to
> > insert independent variables though I uses 3 variables.
> >
> > Does anybody know how I can get a data analysis tool which is used for more
> > than 2 independent valuables?
> >
>

If you use the Regression tool of the Data Analysis ToolPak (Tools |
Data Analysis... | select Regression in first dialog box), the first
field is labeled 'Input Y Range' and the 2nd field is labeled 'Input X
Range'. The 1st field is for the dependent Y values, the 2nd field for
independent variables values.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> Thank you for your quick response! I appreciate!!
>
> But, I still see two boxes in the window.
> I also tried to specify two columns for a box, but it does not accept
> several range and said to select a single row.
> I think I'm using something different from what you taught me.
>
> Could you tell me how did you get the window which has the only one box for
> the independent variables?
>
> Best regards,
>
> "Tushar Mehta" wrote:
>
> > Actually, there is only one box for the independent variables.
> >
> > To specify multiple independent variables simply specify the larger
> > range. For example, if the values for the three indepdendent variables
> > are in A2:C23, specify that as the range for the 'Input X Range'.
> >
> > --
> > Regards,
> >
> > Tushar Mehta
> > www.tushar-mehta.com
> > Excel, PowerPoint, and VBA add-ins, tutorials
> > Custom MS Office productivity solutions
> >
> > In article <[email protected]>,
> > [email protected] says...
> > > Hi,
> > >
> > > I need to use linear regression to make a prediction using 3 independet
> > > valuables.
> > > I went to tools->data analysis-->and chose "regression" in the pop-up window.
> > > But, after I got a window for regression, I see only two text boxes to
> > > insert independent variables though I uses 3 variables.
> > >
> > > Does anybody know how I can get a data analysis tool which is used for more
> > > than 2 independent valuables?
> > >
> >
>

I got it!
I was confused with the boxes for the independent variables and the
dependent variables.
Finally I got the output summary.
Thank you for your kind assistance! Appreciated!!!

Best regards,

"Tushar Mehta" wrote:

> If you use the Regression tool of the Data Analysis ToolPak (Tools |
> Data Analysis... | select Regression in first dialog box), the first
> field is labeled 'Input Y Range' and the 2nd field is labeled 'Input X
> Range'. The 1st field is for the dependent Y values, the 2nd field for
> independent variables values.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <[email protected]>,
> [email protected] says...
> > Thank you for your quick response! I appreciate!!
> >
> > But, I still see two boxes in the window.
> > I also tried to specify two columns for a box, but it does not accept
> > several range and said to select a single row.
> > I think I'm using something different from what you taught me.
> >
> > Could you tell me how did you get the window which has the only one box for
> > the independent variables?
> >
> > Best regards,
> >
> > "Tushar Mehta" wrote:
> >
> > > Actually, there is only one box for the independent variables.
> > >
> > > To specify multiple independent variables simply specify the larger
> > > range. For example, if the values for the three indepdendent variables
> > > are in A2:C23, specify that as the range for the 'Input X Range'.
> > >
> > > --
> > > Regards,
> > >
> > > Tushar Mehta
> > > www.tushar-mehta.com
> > > Excel, PowerPoint, and VBA add-ins, tutorials
> > > Custom MS Office productivity solutions
> > >
> > > In article <[email protected]>,
> > > [email protected] says...
> > > > Hi,
> > > >
> > > > I need to use linear regression to make a prediction using 3 independet
> > > > valuables.
> > > > I went to tools->data analysis-->and chose "regression" in the pop-up window.
> > > > But, after I got a window for regression, I see only two text boxes to
> > > > insert independent variables though I uses 3 variables.
> > > >
> > > > Does anybody know how I can get a data analysis tool which is used for more
> > > > than 2 independent valuables?
> > > >
> > >
> >
>

You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> I got it!
> I was confused with the boxes for the independent variables and the
> dependent variables.
> Finally I got the output summary.
> Thank you for your kind assistance! Appreciated!!!
>
> Best regards,
>
{snip}