Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 09:02 PM
Alex Gardner
 
Posts: n/a
Default linest won't accept multiple reference ranges

I have as extensive data set and some data is missing in places, I want to
use linest and reference my X and Y variables to multiple non-connecting
cells. I’ve tried the standard form for referencing multiple cells (A44,
F4) but linest won’t recognize the reference. Does any one have any
suggestions?

Example of data set

X Y1 Y2 Y3 Y4 Y5 ……….
1 2 2 3 6 3
2 1 N/A 2 3 1
3 1 2 4 1 2
4 N/A 1 5 3 1
5 N/A 3 5 2 N/A
6 2 3 6 1 4
..
..
I want slope of each data set.


  #2   Report Post  
Old May 17th 05, 12:54 PM
Jerry W. Lewis
 
Posts: n/a
Default

Use SLOPE instead of LINEST. SLOPE will ignore empty cells and cells
that contain text or boolean values.

Jerry

Alex Gardner wrote:

I have as extensive data set and some data is missing in places, I want to
use linest and reference my X and Y variables to multiple non-connecting
cells. I’ve tried the standard form for referencing multiple cells (A44,
F4) but linest won’t recognize the reference. Does any one have any
suggestions?

Example of data set

X Y1 Y2 Y3 Y4 Y5 ……….
1 2 2 3 6 3
2 1 N/A 2 3 1
3 1 2 4 1 2
4 N/A 1 5 3 1
5 N/A 3 5 2 N/A
6 2 3 6 1 4
.
.
I want slope of each data set.


  #3   Report Post  
Old May 17th 05, 06:15 PM
Alex
 
Posts: n/a
Default

Thanks for the help Jerry. Any idea how to find the R-Squared value of a
similar dataset. I'm having the same problem as I did with the linest
function.

"Jerry W. Lewis" wrote:

Use SLOPE instead of LINEST. SLOPE will ignore empty cells and cells
that contain text or boolean values.

Jerry

Alex Gardner wrote:

I have as extensive data set and some data is missing in places, I want to
use linest and reference my X and Y variables to multiple non-connecting
cells. I’ve tried the standard form for referencing multiple cells (A44,
F4) but linest won’t recognize the reference. Does any one have any
suggestions?

Example of data set

X Y1 Y2 Y3 Y4 Y5 ……….
1 2 2 3 6 3
2 1 N/A 2 3 1
3 1 2 4 1 2
4 N/A 1 5 3 1
5 N/A 3 5 2 N/A
6 2 3 6 1 4
.
.
I want slope of each data set.



  #4   Report Post  
Old May 18th 05, 01:20 PM
Jerry W. Lewis
 
Posts: n/a
Default

For simple linear regression, you could use RSQ() or CORREL()^2

Jerry

Alex wrote:

Thanks for the help Jerry. Any idea how to find the R-Squared value of a
similar dataset. I'm having the same problem as I did with the linest
function.

"Jerry W. Lewis" wrote:


Use SLOPE instead of LINEST. SLOPE will ignore empty cells and cells
that contain text or boolean values.

Jerry

Alex Gardner wrote:


I have as extensive data set and some data is missing in places, I want to
use linest and reference my X and Y variables to multiple non-connecting
cells. I’ve tried the standard form for referencing multiple cells (A44,
F4) but linest won’t recognize the reference. Does any one have any
suggestions?

Example of data set

X Y1 Y2 Y3 Y4 Y5 ……….
1 2 2 3 6 3
2 1 N/A 2 3 1
3 1 2 4 1 2
4 N/A 1 5 3 1
5 N/A 3 5 2 N/A
6 2 3 6 1 4
.
.
I want slope of each data set.




Reply
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
using multiple split cell references in linest Alex Excel Worksheet Functions 0 May 16th 05 05:37 PM
Sorting Multiple Ranges simoneaux Excel Worksheet Functions 1 February 8th 05 03:11 PM
How to Link named ranges from multiple Workbooks into a single Wo. PMAP_HELP Excel Discussion (Misc queries) 1 December 14th 04 05:51 PM
compare unique identifiers in multiple ranges bawilli_91125 Charts and Charting in Excel 1 November 30th 04 06:34 PM
How do I reference multiple rows Awetronics Excel Worksheet Functions 1 November 4th 04 12:37 AM


All times are GMT +1. The time now is 01:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017