**Statistics**

RANK**12**

of 250,170

REPUTATION**14,697**

CONTRIBUTIONS

**45** Questions

**5,552** Answers

ANSWER ACCEPTANCE **
20.0%
**

VOTES RECEIVED**2,193**

RANK

of 17,378

REPUTATION**N/A**

AVERAGE RATING**0.00**

CONTRIBUTIONS**0** Files

DOWNLOADS **0**

ALL TIME DOWNLOADS**0**

CONTRIBUTIONS**0 Posts**

CONTRIBUTIONS**0** Public Channels

AVERAGE RATING

CONTRIBUTIONS**0** Highlights

AVERAGE NO. OF LIKES

**Content Feed**

Question

Using Cells() in VBA with Excel via ActiveX

While off topic, there are enough using Excel and ActiveX that it is a pretty active subject area, so I'll add one more I couldn...

12 days ago | 0 answers | 0

### 0

answersPlot 3 lines using plotyy with Different X-axis

plotyy creates two overlaying axes; you've created two sets of those and there's no way to not occlude one axis with the other, ...

14 days ago | 0

How do I overlap boxplots on top of each other for the same x-axis?

Use boxchart and the grouping by color option probably best builtin solution...

18 days ago | 0

What is this fft code doing?

See the documentation of FFT and read the example for a one-sided PSD from the FFT carefully... Basically, the reason for the a...

18 days ago | 0

Find and compare rows in table by column value

groupsummary(table,{'Year','Ed_level'},@(x)mean(x(randperm(numel(x),50)),'Income')

19 days ago | 0

How do I select several rows in Excel?

I'll throw the last example code out as an Answer as well as Comment just for visibility -- and it may turn out useful for other...

19 days ago | 1

How do I select several rows in Excel?

You can use any valid range expression to address any range you can code the logic to compute addresses of. You must then use e...

20 days ago | 1

| accepted

Save a matrix .mat in a specific folder with a variable name

save(filepath,'variablename') The functional form of save needs the file name to be the variable containing the (hopefully full...

20 days ago | 0

is there any way to pause the code if there exist an imaginary variable?

While I've not tried it, the following should work if you can arrange the conditions needed. The first one may be the kicker in...

21 days ago | 1

Adding text programmatically to a figure

text() is exclusively a child of an axes, not a figure. To write text outside the boundaries of an axis, use the annotation obj...

21 days ago | 0

How to scan directories and find a specific file in each folder and their respective subfolders

Of course. However, with base MATLAB syntax you have to traverse the folder tree manually/explicitly in code; there are a numbe...

21 days ago | 0

| accepted

Adding latex equation to a Matlab Live Script and Plot the equation

LaTeX is simply a display feature, at least so far it isn't tied to the actual code...

23 days ago | 0

enumeration Fails with get(), set() arguments

OK, I (finally!) figured out how to code the above to use a named constant with external interface -- don't use MATLAB enumerati...

24 days ago | 0

How to lookup and return a corresponding value from table?

I'd start by turning 'obs' into a categorical variable... cmnt0 = categorical({'obs1';'obs2';'obs3';'obs4'}); curve=[1;2;3;2];...

28 days ago | 0

I like to save a cell array into text file

>> c={'Al','Mg';'Na','K'} c = 2×2 cell array {'Al'} {'Mg'} {'Na'} {'K' } >> join(c,'') ans = 2×1 cell a...

28 days ago | 0

| accepted

How to Interpolate scalar on new grid

Error using griddedInterpolant Sample points must be unique. comes from x = Results(:,1); y = Results(:,2); ... [X,Y]=mesh...

28 days ago | 0

How to save this matrix?

If there's just one array/matrix M, then fid=fopen('test.txt','w'); fmt=[repmat('%.4f',1,size(M,2)) '\n']; % build ...

1 month ago | 1

| accepted

What is missing from MATLAB #2 - the next decade edition

Related to my previous re: insert() function for tables @ <What is Missing is insert() Function> would be enhancement to addvars...

1 month ago | 0

how can i get data sampling rate and FFT bin width?

"What is the default value of the parameters fft?" None...the fft doesn't care, the sample rate is set solely by the data colle...

1 month ago | 0

How to plot an array with an hourly time stamp without starting at 00:00:00?

You can build complete datetime variables from the input by something like-- dt1=datetime("yesterday")+duration(T(1)); % ...

1 month ago | 0

| accepted

How can I convert file txt into matrix?

Simply put, you can't. An array of anything (even a cell array) has to be regular (your cell array above is Nx1; it is only the...

1 month ago | 0

Box plot with categorical axis - without LaTex interpreter

Much easier now... :) optFV=detectImportOptions('fruitvegprices.csv') % lets you then set the input...

1 month ago | 0

| accepted

calculate kurtosis in matlab and minitab but not same answer

Looks like Minitab uses the bias-corrected estimator with the "-3" convention applied -- K>> kurtosis(x(:,2),0) ans = ...

1 month ago | 0

sorting data tables according to results from cluster analysis

Y=X(outperm,:); % presuming X is the variable guessing from the initial code...

1 month ago | 1

| accepted

sort the matrix X, then sort the another matrix in the same order as X

Matrix expansion of subscripts gets you here... Q=cell2mat(arrayfun(@(i) P(i,indx(i,:)),[1:size(P,1)].','UniformOutput',false))...

1 month ago | 0

| accepted

How can I plot a circle over an interval (range of values)

hL=plot([-1327,0],[0 0],'LineWidth',8,'Color',[1 1 1]*0.5); xlim([-1500 200]); ylim([-20 20]) xticks([]),yticks([]) hold on ...

1 month ago | 0

| accepted

How to choose values from vector (150 000x1). When i need first 512 values for x, next 512 values for y and next 512 values for z. And separate vector by this style to the end

XYZ=reshape(V,512,[]); then process by column. Most MATLAB functions operate by column natively; depending upon what you're do...

1 month ago | 0

R2017b Compatibility

https://www.mathworks.com/support/requirements/matlab-system-requirements.html?s_tid=srchtitle_MAC%20Monterey_6 indicates R2021b...

1 month ago | 0

How do I get my graphs to converge on one ?

... [yob,t,xob] = lsim(syst,r,t,[x0 x0ob]); figure(2); hold on plot(t,xob(:,1)/max(xob(:,1)),'r'); plot(t,xob(:,2)/abs(min(...

1 month ago | 0

select folder that also includes subfolders

There is no builtin gui tool that does more than multi-select on files within a single folder; you have to traverse the director...

2 months ago | 0