How do I compare data sets of different lengths?
19 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
We have a total of 4 columns of data 2 columns are for one program and the other 2 columns are for another program. We are trying to correlate the data and find the slope of the line between the all 4 columns of data. The issue is that the data sets are of unequal length because the frequency of data collection we are using on two pieces of equipment are different and cannot be changed. So, for example, one piece of equipment is taking data at a speed of 100 data points per second where the other piece of equipment is taking one data point per second. This causes the data sets to be completely different in length. I am compiling all 4 columns into one spreadsheet.
As of now, the first two columns start in A and B are begin at row 35 and end at 195. The other two columns are C and D and begin at row 35 and end at 4554. We are trying to plot the data on one line and compare the 4 columns of data onto one plot. A previous code was written and is provided below.
%%Axial Reducer Data Analysis
clc;
clear;
%Call all the data, has to be manually changed
count = xlsread('AR3 Formatted',1, 'A35:A195');
ForceLV = xlsread('AR3 Formatted',1, 'B35:B195');
count2 = xlsread('AR3 Formatted',1, 'C35:C4554');
ForceMM = xlsread('AR3 Formatted',1, 'D35:D4554');
%find the normal factor
num=ceil(size(count2)/size(count))
%setup the averaged array
blockSize= [num, 1];
meanFilterFunction = @(theBlockStructure) mean2(theBlockStructure.data(:));
% Now do the actual averaging (block average down to smaller size array).
ForceMM = blockproc(ForceMM, blockSize, meanFilterFunction);
%will still be a little off, just subtract the first few numbers till the
%length is the same.
ForceLV=ForceLV(6:end);
plot(ForceLV, ForceMM);
%factor=Strainave\force
title('Axial Reducer Calibration')
xlabel('Force Read by Labview (N)')
ylabel('Force Read by MM (N)')
6 commentaires
Star Strider
le 18 Nov 2018
I have no idea.
I don’t know the units for either one. That makes any reliable scaling impossible.
Réponses (2)
Haritha
le 19 Nov 2018
yes
1 commentaire
madhan ravi
le 19 Nov 2018
Modifié(e) : madhan ravi
le 19 Nov 2018
@Haritha if you put up an answer use a single answer section don‘t post multiple answers in a single thread.
Voir également
Catégories
En savoir plus sur Creating and Concatenating Matrices dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!