Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Trendline parameters Trendline parameters
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-03-2017, 12:58 PM
Gilles Gilles is offline Trendline parameters Windows 7 64bit Trendline parameters Office 2010 64bit
Novice
Trendline parameters 		 
Join Date: Jan 2017
Posts: 2
Gilles is on a distinguished road
Default Trendline parameters
Is there a way of 'evaluating' the SLOPE and INTERCEPT parameters?
Assuming my (x,y) data are contained in cells L11 to L20 (for the y’s) and in cells K11 to K20 (for the x’s). The slope of line is obtained by using the functions =SLOPE(L11:L20,K11:K20)
Here is my question:
If cells …
I25 contains characters L11
I26 contains characters L20
J25 contains characters K11
J26 contains characters K20
Is there a way of having the slope parameters evaluated, such as:
=SLOPE(I25&":"&I26,J25&":"&J26)


I get an error when I try to do that! Is there an alternate way of automating the range of x,y ... outside the slope and intercept function?
I would use this to automate the regression parameters, as data are added to my data set?
Reply With Quote
  #2  
Old 01-03-2017, 11:54 PM
xor xor is offline Trendline parameters Windows 10 Trendline parameters Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
How about

SLOPE(INDIRECT(I25):INDIRECT(I26),INDIRECT(J25):IN DIRECT(J26))
Reply With Quote
  #3  
Old 01-04-2017, 08:02 AM
Gilles Gilles is offline Trendline parameters Windows 7 64bit Trendline parameters Office 2010 64bit
Novice
Trendline parameters 		 
Join Date: Jan 2017
Posts: 2
Gilles is on a distinguished road
Default
Thank you. That works well.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trendline parameters trendline error jayjones90 Excel 2 11-22-2016 12:36 AM
Trendline parameters Interception between trendline and markers? tinfanide Excel 4 08-24-2015 06:57 AM
Linear trendline? markg2 Excel 0 06-25-2015 05:19 AM
How to pass parameters to a .msg file? HereNow Outlook 0 11-05-2012 10:38 AM
Trendline parameters Printer parameters stored where? Doc_man Office 2 06-20-2011 12:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:17 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft