+ Reply to Thread
Results 1 to 2 of 2

Need a formula to identify trends and bias in data

  1. #1
    Registered User
    Join Date
    03-27-2019
    Location
    York, England
    MS-Off Ver
    Office 2016
    Posts
    1

    Need a formula to identify trends and bias in data

    Hi,

    Apologies if this is a stupid question!

    I need a formula to identify trends/bias in data. I analyse quality control data which compares the log difference between test and control samples. Then on a monthly basis the log difference is analysed for trends which for this purpose is considered to be where 5 consecutive values increase or decrease, or bias where 5 consecutive values return a positive or negative log difference.

    Hope thats enough info, any help greatly appreciated!

  2. #2
    Registered User
    Join Date
    03-19-2019
    Location
    London
    MS-Off Ver
    2003-2016/2016 Mac
    Posts
    57

    Re: Need a formula to identify trends and bias in data

    I guess you should use charts for the same.

+ 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. Creating bias when randomly selecting rows
    By guest267 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2018, 03:32 PM
  2. [SOLVED] formula to recognize increasing trends
    By lar9149 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-17-2016, 12:43 AM
  3. excel formula to recognize trends
    By lar9149 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-08-2016, 11:51 PM
  4. Time Series Smoothing No Look Ahead Bias
    By Hornstinger in forum Excel General
    Replies: 1
    Last Post: 08-19-2012, 02:38 PM
  5. how to identify trends in a time series
    By trilliansounds in forum Excel General
    Replies: 3
    Last Post: 12-14-2011, 07:38 PM
  6. How To Identify Trends From Multiple Factors
    By Manav in forum Excel General
    Replies: 2
    Last Post: 09-07-2009, 01:22 PM
  7. Charts - Trends - Excel Formula
    By Siggsy007 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2006, 06:29 AM

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