trend analysis

  1. Z

    HOW TO MAKE SIMPLE FORMULA FOR TREND IDENTIFICATOR ?? (INCREASING/DECREASING)

    HI I HAVE 6 CELLS (A1:F1) FILLED WITH 6 PAST WEEKS OF SALES VALUES. I NEED TO CALCULATE IN (G1) CELL IF THAT RANGE HAS INCREASING OR DECREASING TREND. IDENTIFICATOR (G1) CAN BE WORD ''DECREASE'' OR CAN BE PERCENTAGE VALUE. WHAT WOULD FORMULA FOR BOTH IDENTIFICATOR TYPES LOOK LIKE?
  2. S

    YTD Dynamic Trend formula

    Hi All, could someone please help me figure out how to make a dynamic trend formula in a following way: I calculated YTD trend as but would like the Trend formula to automatically take into account the following month once I update the source table with September Actuals so that the trend for...
  3. R

    calculate if your sales are up or down with a nice chart

    Hello Everyone, Can you please help me make a trend chart to determine if our sales of units in this time span is trending up or down. Thank you.
  4. T

    Help with plot returning strange values for trendline

    Hi folks, I am trying to do a calibration curve and have strange results from the trendline. It appears to be giving me a trend that beggars belief! Just looking at the X and Y axes, it seems apparent that the relationship given is not likely at all. Can you advise on where I'm going wrong...
  5. T

    Data trend without a graph

    I am attempting to trend data without using a graph. The data would look something like this: Week Revenue 1 $90,934.15 2 $143,314.75 3 $134,522.00 4 $202,343.00 5 $177,218.00 6 $132,985.75 7 $113,291.00 8 $62,821.00 9 $151,983.00 10 $161,214.80 11 $142,278.45 12...
  6. M

    Forecasting current sales according to ongoing trend and history data

    Hello everyone, hope you'll be able to help me I have everyday sales data of this month and I need to forecast daily sales till the end of this month. I have to take into consideration the ongoing trend and also the history sales of the same month of previous year. The solution has to be...
  7. I

    LOOKUP + SEARCH for a Trend Report

    Hello Everybody, I need to format some raw data for a trend report as following: The raw data is extracted from a ticketing system and I need to assign a Category/Topic and a Subcategory to each ticket by using the text present in the "Short description" tab. I defined two names as "keywords"...
  8. P

    How to plot a chart showing a job progress

    My sheet is simple: A1: data volumn, a big int like: 19981573933 B1: partition day, a small int like 365, every day has certain amount of data to be processed, total add up to A1 A2: starting date time (could be only time part, like 16:05) B2: 0 (meaning at the starting point processed days is...
  9. Z

    forecast monthly change of inflation rate

    Hi :) I am working on a project to forecast monthly change of inflation rate. I used SLR but the forecast doesnt seem to be correct. Could someone take a look please? :confused: I am also not sure how to diagnose time series (stationarity, trend, ARMA..) in Excel( is this even possible?) I...
  10. N

    VBA Loop for each to build forecast

    I have a data set that includes Column1 (Dates, week-to-week starting on Mondays), Column2 (product by SKU), Columns3 (product status, active... this will eventually be left out as soon as I finish the VBA to permit a list to be built allowing only active products to be selected in the data...
  11. W

    TREND or FORECAST function

    I'm trying to trend out some numbers. I have two sets of numbers: The first we can call a "local" projection and the second we can call a "national" projection. For the national projection I know all 3 numbers: Low, Medium, High For the local projection I know only 1 number: Low I would...
  12. P

    Populate text when 4 cells consecutively increase

    Hi there - Haven't been able to find an answer to this exact question, and am not able to get nestedIFs to work. In short, I'm doing a trend analysis based on ranks that looks like the below: Jan | Feb | Mar | Apr | TREND 2 | 5 | 6 | 8 | GROWING 3 | 1 | 7 | 3 | NO TREND 4 | 2 | 8 | 7 | NO...
  13. F

    Probability - TREND

    Hi, I'm new to the board hoping for some friendly insight.. I'm trying to find a means to calculate a probability of default trend line over a certain period using the TREND function in Excel 10. My issue is the probability figure cannot be less than zero, however I'm not sure how to configure...
  14. G

    Conditional formatting query

    Hi, I'm looking to apply conditional formatting based on the value of the adjacent cells. So using the example below, I want to highlight the figure showing for Q4 if it is 10% greater than the value in Q3. (However that figure in Q4 is a forecast in which I will be using trend function - not...
  15. S

    lock a trend line and re-plot the outlier without effecting the trend line

    I have a small data set with Fiscal years and Sales. One of the data points is an outlier so in order to get an accurate trend line I have omitted the outlier data point. I have already created a trend line omitting the outlier. What I want to do: 1) Lock the trend line and re-plot the...
  16. F

    Trend Analysis

    Hi Folks, Uust wonderin if anyone has come up with a way to perform trend analysis againt Nessus scan results using Excel. Thanks, Fergie
  17. M

    Trend analysis for QA/QC data using conditional formating

    I am trying to update my Quality control charts with some basic trend analysis. I need to be able to easily track trends in Spike, blank and standard results using excel 2010. Using conditional formatting I have been able to track 7 consectutive increasing or decreasing points: =AND(O4:O9>O3:O8)...
  18. S

    Use Excel to identify changes in Trend

    I was given a spreadsheet that has over 50 control charts -- 1 control chart on each tab. The control charts are run against 1 set of data (on a tab called "data"). My job is to review every control chart every day to look for data points that are above or below control limits or that seem to...
  19. R

    Problem deciding best way to "graph" my Trends

    Hi Hope it's OK to ask an open question, but I have problem deciding the best way to "graph" my Trends. I have Students entering the company, on different student schemes (12 in total), with Years of entry over the past 15 years. I want to be able to compare trends, which looks at pay...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top