**Statistics**

RANK**12**

of 250.142

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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 giorni 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 ...

circa un mese 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...

circa un mese 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...

circa un mese 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)); % ...

circa un mese 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...

circa un mese ago | 0

Box plot with categorical axis - without LaTex interpreter

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

circa un mese 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 = ...

circa un mese ago | 0

sorting data tables according to results from cluster analysis

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

circa un mese 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))...

circa un mese 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 ...

circa un mese 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...

circa un mese ago | 0

R2017b Compatibility

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

circa un mese 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(...

circa un mese 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...

circa un mese ago | 0