Excel - Normalizing & Averaging Large Data

Поділитися
Вставка
  • Опубліковано 13 жов 2024
  • Part of the Advanced Excel training series which covers how to plot data from multiple test scenarios on top of each other, efficiently normalize each data set, and how to average/smooth the data. Covers "=subtotal()", "Advanced Filter: Unique Records Only", basic "=vlookup()", and "Pivot Chart".
    You can download the raw data and follow along here:
    drive.google.c...
    Or you can download the completed spreadsheet to see the final result here:
    drive.google.c...

КОМЕНТАРІ • 1

  • @alija0b
    @alija0b 8 років тому

    Thanks!
    This is better than my way of plotting averages of normalized data (thousands of raws). I just let Excel do the "moving average" graph and increase/decrease the period.