Recording Regression in Macros

H

Hitesh

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
 
N

Nigel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top