How to perform an autocorrelation FUNCTION of a signal in Excel?

More Stanisław Anweiler's questions See All

How to filter out 50 Hz frequency from given signal?

Dear Researchers, I have sample signal (attachment). Another 50 Hz signal is built into this signal. How to remove the 50 Hz frequency from that sample? Thank You and best regards.

10 November 2017 10,076 4 View

What is the range of pressure drop across the air distributor in fluidization of particles?

I need to select pressure sensors for a laboratory system where I fluidize particles from 1 to 10 mm in diameter and 1 to 2 g / cm3 in density. The fluidised bed is narrow and shallow. What are...

08 September 2017 7,949 3 View

Why flat plate solar collectors with tubbing are more popular then with corrugated plates?

Hello, Flat plate solar collectors with tubes soldered to metal sheet (absorber) seem to be more polpular. More efficient way to collect solar heat with the use of two corrugated plates as...

04 May 2017 6,256 0 View

Is there anyone who made research on two-phase flows, especially process visualization in correlation with pressure drop or heat transfer?

Dear researchers, I am interested with the research of the simultaneous visualization and pressure-drop measurement of the two-phase flow in transparent channels. I am looking for cooperation with...

10 November 2016 4,339 5 View

Which equation is best for heat transfer during impact of single solid particle to curved surface?

Single hot solid particle hits the outer surface of the tube. Heat is transfered from the particle to the tube's wall. The equation should include porosity, shape, diameter of the particle. Which...

10 November 2015 2,318 3 View

How to perform an CROSS CORRELATION FUNCTION of a signal in Excel?

Has anyone come up with some excel formula or algorithm to perform the CROSS CORRELATION FUNCTION not FACTOR of a single discrete signal as shown in the attachement?

01 January 1970 4,979 3 View

How to learn more about SPSS and its Application?

I would like to learn more about SPSS and Its application especially in regards to data analysis. Please suggest me how I can learn more about it. Thank you so much.

11 August 2024 9,101 4 View

Can I base on reverse DNA sequences to perform alignment, convert to amino acids and GenBank submission?

I have reverse sequences (AB1 format), can I base on reverse DNA sequences to perform nucleotide alignment, convert nucleotides to amino acids and deposit the sequence in GenBank database?

11 August 2024 5,138 1 View

Baseline drift in HPLC? What causes this?

Hello, Why do i see this baseline drift when i compare my blank (black) to the sample (blue)? Any suggestions as to why this happened? Thank you!

11 August 2024 3,770 4 View

Text-Communication from the M1 Hand Area using BCI—and then there is Elon Musk?

Willett, Shenoy et al. (2021) have developed a brain computer interface (BCI) that used neural signal collected from the hand area of the motor cortex (area M1) of a paralyzed patient. The...

10 August 2024 7,180 0 View

Has anyone applied Python in the field of textile engineering for data analysis, automation, or smart textiles?

I'm currently exploring the application of Python in textile engineering, specifically in areas like data analysis, process automation, and the development of smart textiles. I'm interested in...

10 August 2024 7,429 2 View

How can I use the cif data obtained from rietveld refinement extracted via gsas2, for microstructural analysis using ETEX software?

09 August 2024 7,718 0 View

How are iso-frequency contours plotted?

Let's say we have a standard, regular hexagonal honeycomb with a 3-arm primitive unit cell (something like the figure attached; the figure is only representative and not drawn to scale). The...

07 August 2024 1,937 1 View

How to prepare the nanoparticle treated fungal sample for Environmental SEM analysis?

A fungal strain was treated with nanoparticles. We want to do an environmental SEM analysis. So could anyone share your views on preparing the sample? Thank you.

07 August 2024 5,307 1 View

Should I include H atom into C3N5 when i am doing DFT modelling?

Hi all, my experimental XPS results shown that my C3N5 sample consists of N-H bond, hence in this case I should incorporate the N-H bond into my DFT modelling. However, I do notice several papers...

07 August 2024 8,414 2 View

How to normalize and take the significance of the MTT OD values with 3 replicates for the same cell-line?

Hi, I have a question about normalizing the MTT OD values for doing the statistical analysis. So, if we have 3 different plates and we call them 3 different replicates, so, first we would...

07 August 2024 8,106 4 View

Márcio Fagundes Goethel

You can download a Statistical pack with the autocorrelation function (ACF) in this website:

http://www.real-statistics.com/time-series-analysis/stochastic-processes/autocorrelation-function/

I hope that can be usefull to you.

Best,

Márcio

Stanisław Anweiler

Dear Márcio Fagundes Goethel thank You. It looks like it is all I wanted for now. Best regards.

Dear Márcio,

Thanx again! I did all the calculations and all went excellent.

Do U know maybe where to find similarly explained Cross Correlation Function?

Stan