Posted to microsoft.public.excel.misc

external usenet poster

Posts: 71

Regression - scenario won't run - can't determine why

Hi gang:

I am running a regression macro where I submit a X range of x variables, and
a Y range of Y data.

I make sure that my X range contains the same number of rows as my Y range.

However, when my x range (which is 15 variables) contains 15 rows, I get
this error:

Regression - the number of rows and columns in X range cannot be the same

Why is this? Is there a workaround?

thanks,
Harry

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
The multiple regression tool - linear or non-linear regression?	Statistical interest	Excel Discussion (Misc queries)	2	February 6th 08 11:01 PM
What if scenario	Andrey	Excel Discussion (Misc queries)	0	January 4th 07 03:38 PM
scenario/what if ??	MikeR-Oz	New Users to Excel	2	November 24th 06 11:33 AM
Scenario?	simmerdown	Excel Worksheet Functions	6	January 25th 06 10:05 PM
IF Scenario	will.00	Excel Worksheet Functions	1	June 15th 05 10:38 AM

All times are GMT +1. The time now is 03:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us