Calculate acceleration from velocity and time fron excel

Hi I have an excel sheet with Velocity and Time columns for each step. I need help to input this excel sheet and add a 3rd column with acceleration data.

For example: (Input)

Time (s) Velocity (m/s)

0 50

1 51

2... 52...

For example: (Required Output)

T (s) V (m/s) Acceleration (dV/T)(m/s^2)

0 50 (50-0)/0

1 51 (51-50)/1

2... 52... (52-51)/2

I've used the following to read the Excel

filename='Example.xlsx';

[filepath,name,ext] = fileparts(filename) ;

data = readtable(filename);

N = length(data.t);

Answer 1

[Fabio Freschi]

acceleration = diff(data.Velocity)./diff(data.Time);

Note that this vector has one entry less than the original ones, so you may be interested in creating a new vector of time at the mid point of each time interval

tt = (data.Time(1:end-1)+data.Time(2:end))/2;

[Wayne]

Thank you for the prompt reply, how can I add this Acc column to the output excel Sheet. And how does the formula change when the exact column name (Velocity, Time) is not known but only address is known.

[Fabio Freschi]

velocity = table2array(data(:,2));
time = table2array(data(:,1));

acceleration = diff(velocity)./diff(time);

since we have one entry less than the original vector, you should decide what to do. Maybe you can assign 0 to the first entry

acceleration = [0; diff(velocity)./diff(time)];

% save table
A = table(time,velocity,acceleration);

then use writetable to write the table to excel

[Fabio Freschi]

This line

Acceleration = diff(Velocity)/Time;

is mistyped. Use

Acceleration = diff(Velocity)./diff(Time);

for incremental element-wise division

[Fabio Freschi]

acceleration is the time derivative of velocity. diff(Velocity)./diff(Time) is the derivative in a discrete setting

[Fabio Freschi]

help diff