Answered
Appdesigner: Writing Data To Excel
writetable returns no arguments and needs the data to output as an argument -- read the doc first... % Button pushed function: ...

5 years ago | 1

| accepted

Answered
Combining chart for comparison got error
h1.Children.Children returns a comma-separated list-- >> h1.Children.Children ans = 0×0 empty GraphicsPlaceholder array. ...

5 years ago | 0

| accepted

Answered
Writing x values with subscript in the graph
hAx=gca; % save the axes handle -- may want later hAx.TickLabelInterpreter='tex'; % set tick lab...

5 years ago | 0

| accepted

Answered
How to extract a column from a matrix by searching
vWant=11; vecRes=matrix_test(:,matrix_test(1,:)==vWant);

5 years ago | 0

| accepted

Answered
How to plot discrete data in a stackedplot
You can get creative and use stackedplot to create the axes for you, and then go "handle-diving" to find and modify the content ...

5 years ago | 1

Answered
Log return of a timetable
To put the computed return at the end time point of the interval, augment the diff vector with a missing-value indicator--- dat...

5 years ago | 0

| accepted

Answered
Merge dataset with different lengths
TT = synchronize(DAX,SP500,'intersection'); TT = synchronize(TT,NIKKEI,'intersection'); where DAX, SP500 and NIKKEI are the th...

5 years ago | 1

| accepted

Answered
How and where to place the legend box in a "tiledlayout"?
Well, you have to get creative -- the following experiment t=tiledlayout(2,2); % create a 2x2 layout nexttile, pl...

5 years ago | 1

Answered
Incorporating Multiple Dummy Variables In A Regression Model
Firstly, all have to be column vectors; secondly you'll have to have the same number of observations for each to build an arra...

5 years ago | 1

| accepted

Answered
Axis position changes when i use rectangle
I've NEVER understood (and never will understand) the annotation implementation only in absolute units of reference relative to ...

5 years ago | 2

| accepted

Answered
Table - keeping specific data
You've got parentheses in the wrong place to do combination of logical addressing, but unless you only want "1" values in the ou...

5 years ago | 0

Answered
What Takes to Wrap MATLAB function to Use From Excel?
While I didn't answer my own Q?, I'll put an Answer here for any others who stumble over the thread and may be as confused as I ...

5 years ago | 0

Answered
Why won't my excel file import onto matlab?
You've got a very inefficeint and hard-to-read for a generic code format in the spreadsheet ...there's text scattered around in ...

5 years ago | 0

| accepted

Answered
how to create a second x axis with different intervals?
You've actually got three copies of the one axes handle (ax,ax1,ax2); you've never created a second axes. hSc=scatter(rand(10,1...

5 years ago | 0

| accepted

Question

What Takes to Wrap MATLAB function to Use From Excel?
I've got a MATLAB function that pulls data from an Excel spreadsheet (actually two separate ones) and then writes after processi...

5 years ago | 2 answers | 0

2

answers

Answered
re-arrange data
>> C=[{'A'}, {'B1'}, {'X6(1.4M), X15(3M), X25(5M), X50(10M), X75(15M), X100(20M)'}, {' X6~0, X15~1, X25~2, ...

5 years ago | 0

Answered
How do I plot only the lower error bars?
residual = N - y_new; errorbar(x_new,y_new,residual,[]) Input arguments for four inputs are: errorbar(x,y,neg,pos) If only t...

5 years ago | 0

Answered
How do I combine multiple plots that use hAxes = 'NextPlot' using subplot?
%% Plot1 s=[186,561,831,864,865,870,943,997,1001,1049,1055,1063,1077, 1078, 1171,1180,1190,1494,1497,1499,1522]; hAx(1)=subplo...

5 years ago | 0

Answered
create a table next to a graph on figure
A table object can't be put in a figure and, AFAIK, it's not possible to redirect command window output to a figure other than b...

5 years ago | 0

| accepted

Answered
loop through cell arrays and perform calculations using rows from another cell array
DATA={table(rand(4,3))}; DATA(2,1)={table(rand(4,3))}; To={table(randi(5,4,1))}; To(2,1)={table(randi(5,4,1))}; % preliminarie...

5 years ago | 0

Answered
How to make the average for columns in cvs folder contains (700 file) ?
Well, you've got to read the files somehow...show us what you have tried...here's the link to one way Mathworks suggests -- <im...

5 years ago | 0

Answered
First number that comes after a list of numbers
>> [A;interp1([-eps(1) B],[-eps(1) B],A,'next')].' ans = 1 4 8 9 20 25 >>

5 years ago | 0

| accepted

Answered
How to create an average of 2 lines on a single graph
OK, I see...the data are collected on a up- and down-slope symmetric ramp.. Try something like-- top=readmatrix('top_sensor_da...

5 years ago | 0

| accepted

Answered
Histogram plot isn't shown properly.
Can't change the characteristics of the image; any linear scaling of the axis will only change the numerical values, not the sh...

5 years ago | 0

| accepted

Answered
Averaging lots of columns at once and then combining them
"...I cannot figure out a way to take the average of each col[o]umn without manually inputing it. " Fs = 2048; ...

5 years ago | 0

| accepted

Answered
unique command and external Excel files
Well, there is a duplicate in the 2nd column... >> d=xlsread('x.xlsx','Sheet2'); >> arrayfun(@(i)numel(unique(d(:,i)))==numel(...

5 years ago | 0

| accepted

Answered
storing a 100x100 matrix from each iteration in a single new matrix
Two options -- either use a cell array each element of which is a 2D array or a 3D array in which each plane is one time step. ...

5 years ago | 0

| accepted

Answered
how to average seasonly?
This one is cute... :) Unfortunately, timetable won't accept a 2D array by row so have to do things directly... t=linspace(dat...

5 years ago | 0

Answered
loop for cell using variable as a the input
gtm_segmentations = [34 36]; % use double array, no point in cell array here corr_time_intervals = [20 22]; ...

5 years ago | 0

Answered
How is it possible to slice up a table into smaller ones if the data contains floating point numbers?
ix=find(diff(XYZ(:,1))<0); will locate the breakpoints where the X coordinate resets. Remember diff(x) contains one less point...

5 years ago | 1

| accepted