Recording Regression in Macros
 

Hi,
I am using the regression function to run regression 3 sets of (x,y) data in
a single file.
I tried to record this activity using Record MAcro. However, when the run
the macro in my next file, it says missing Y data for regression.

I am not sure whats happening .. I have trieed recording macro in the
present workbook, new workbook and Personal workbook, with no luck

Can we record regressions using the Record macro feature??

PLease advise. A solution to this will be very bery helpful
Thanks
Hitesh

Recording Regression in Macros
 

Yes, you can record, but if your ranges specified are empty or of a
different length then you will get an error.

--

Regards,
Nigel




"Hitesh" <Hitesh @discussions.microsoft.com wrote in message
...
Hi,
I am using the regression function to run regression 3 sets of (x,y) data
in
a single file.
I tried to record this activity using Record MAcro. However, when the run
the macro in my next file, it says missing Y data for regression.

I am not sure whats happening .. I have trieed recording macro in the
present workbook, new workbook and Personal workbook, with no luck

Can we record regressions using the Record macro feature??

PLease advise. A solution to this will be very bery helpful
Thanks
Hitesh