LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
RickH
 
Posts: n/a
Default Regression Analysis Format

I've never had to perform multiple regression through Excel before so forgive
any simple mistakes or assumptions.

I'm trying to create a relationship between 3 variables (Crossfall, gradient
and flow width) and an output (Area). Having arranged the data in a suitable
way that Regression Analysis could be carried out I'm presented with 3
variables. However, nowhere does is specify what in format these variables
are applied / combined such that I may produce a result.

Is it a simple y=Aa+Bb+Cc+I? Or is there something more complex? I have
tried with the above format but the equation does not reproduce the figures
that I'm after.

Cheers,

RickH
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 08:47 AM
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM
why does currency format change to number format? Cassie Excel Discussion (Misc queries) 3 March 18th 05 06:57 PM
Keep custom format in new worksheet Buddy Excel Discussion (Misc queries) 2 March 14th 05 10:03 AM
Copying a conditional format Meaux Excel Worksheet Functions 2 November 29th 04 10:19 AM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"