Excel FFT

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 พ.ย. 2024

ความคิดเห็น • 13

  • @NSchess54
    @NSchess54 4 หลายเดือนก่อน

    This video has helped so much for my IYPT Presentation. Thanks!!

  • @Dover0486
    @Dover0486 2 ปีที่แล้ว

    Your presentation helped me to complete a formulated FFT spreadsheet without the Analysis add-in.

  • @rickybrenay6249
    @rickybrenay6249 2 ปีที่แล้ว

    Thank you! Great video. Should sound be plotted on log scale because of sound?

  • @edwardmallon4646
    @edwardmallon4646 3 ปีที่แล้ว +1

    One interesting aspect of the FFT when applying it to slower environmental datasets: The key to getting better resolution from the Fourier when you are limited to a fixed number of data points is to decrease the sample frequency (and thus increase the overall sampling time) So we released a video demonstrating that optimization using Excel's Fourier transform to derive a tidal frequency spectrum: th-cam.com/video/0VzX-3erjPI/w-d-xo.html

  • @Tethys99999
    @Tethys99999 2 ปีที่แล้ว

    So how do you do a von Hann window with the FFT in excel?

  • @vietanhnguyen4924
    @vietanhnguyen4924 3 ปีที่แล้ว +2

    i don't understand when you at the column the frequency you re dividing by 2050

    • @lactobacillusshirotastrain8775
      @lactobacillusshirotastrain8775 3 ปีที่แล้ว +1

      he's not dividing by 2050, he is dividing by the value in cell D2050 which is the total elapsed time 0.08

  • @dp0813
    @dp0813 3 ปีที่แล้ว +1

    How do you have negative time values?

  • @lancediano8014
    @lancediano8014 4 ปีที่แล้ว +2

    You just glance over the fact that on either side of your FFT graph it's a copy of itself why is this?

    • @yourdataispublic
      @yourdataispublic 2 ปีที่แล้ว

      Think it's due to Nyquist theorem

    • @Tethys99999
      @Tethys99999 2 ปีที่แล้ว

      @@yourdataispublic The Nyquist theorem just states that in order to get an accurate measure of your sample (when converting from analog to digital), your sampling rate should be 2X the maximum frequency you are looking to describe in any analysis after digitization. So that does not account for the reflection of the wave.

  • @amr.a-m8350
    @amr.a-m8350 3 ปีที่แล้ว

    Good video