+ Reply to Thread
Results 1 to 3 of 3

calculate the slope of a range of numbers, if the numbers are more or less descending

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Guelph, ON
    MS-Off Ver
    2013
    Posts
    2

    calculate the slope of a range of numbers, if the numbers are more or less descending

    I have a data set that's from measuring gas concentration. basically, gas is injected into a chamber quickly (so concentration goes up over time), and then dissipates slowly (so, concentration goes down over time). There's a bit of noise in the concentration measurements, so sometimes the concentration measurement goes up a tiny bit during the "dissipation" phase of things.

    Ultimately, I need to calculate the slope of the dissipation phase. This cycle happens a whole bunch of times each day -- injection, then dissipation.

    Is there a way I can have excel automatically detect where the values are generally decreasing (allowing for the odd gas measurement that goes up a bit from instrumentation problems), select each of these ranges, and then spit out the slope of each?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: calculate the slope of a range of numbers, if the numbers are more or less descending

    Hi,

    There's no reason why Excel can't react to a change in data and display the line slope, all you need to decide is what should be the trigger for the change.

    If the data is connected to the Excel sheet then the data refresh can be scheduled as often as you like, otherwise you'd need to click a button or trigger in some other way. Once the data is refreshed you'd need to create a rolling period average in order to smooth out the effect of noise and then have Excel update and plot the points and slope line on a chart.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-16-2014
    Location
    Guelph, ON
    MS-Off Ver
    2013
    Posts
    2

    Re: calculate the slope of a range of numbers, if the numbers are more or less descending

    thanks Richard. I'm glad to hear it is doable. I suspect this has to be done through VBA? I am totally new to this sort of work with Excel and don't know where to start, unfortunately. I got as far as thinking, "something, something... conditional formatting... something..."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it possible to count some numbers in a range(Descending order range)
    By amitgurus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2013, 10:59 AM
  2. Is it possible to count some numbers in a range(Descending order range)
    By amitgurus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2013, 08:41 AM
  3. Formatting Phone Numbers & Descending Equation
    By EXhelp1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-09-2012, 04:12 PM
  4. vlookup Question about descending numbers
    By slx in forum Excel General
    Replies: 6
    Last Post: 11-12-2007, 04:46 PM
  5. Force descending sort to Start with Numbers
    By The Smuffer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2006, 04:24 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1