**Statistics**

RANK**185**

of 244,426

REPUTATION**424**

CONTRIBUTIONS

**17** Questions

**136** Answers

ANSWER ACCEPTANCE **
70.59%
**

VOTES RECEIVED**45**

RANK**16,618** of 17,075

REPUTATION**0**

AVERAGE RATING**0.00**

CONTRIBUTIONS**1** File

DOWNLOADS **1**

ALL TIME DOWNLOADS**4**

CONTRIBUTIONS**0 Posts**

CONTRIBUTIONS**0** Public Channels

AVERAGE RATING

CONTRIBUTIONS**0** Highlights

AVERAGE NO. OF LIKES

**Content Feed**

how to search specific data from matlab to excel

tab = readtable('myExcel.xlsx'); % see doc for more options tab(ismember(tab.(1), 'R1280XS'), :) % the row at which the input...

15 hours ago | 1

| accepted

Check for coordinate pairs matches in .mat file

Assuming both x and y are vectors of same length, this might work: x = randi([0 5], 10, 1); y = randi([0 5], 10, 1); myPair...

15 hours ago | 0

How can I create an array from the past values in a loop?

something like this? n = 10; str = strings(n, 1); for i = 1:n % do whatever str(i, 1) = gimmeMystr; end

15 hours ago | 0

Plot the slope of a parabola with only the data points being known

Before fitting, it's a good practice to visualize your data to better understand the rough relationship between your variables. ...

2 days ago | 1

How to plot a function with summation and multiple variables?

Start by understanding MATLAB a bit better. For the time being this may help you: myfnc = @(A, s, t, i, T0, tau) sum(A.*s.*(t -...

2 days ago | 0

Handle error from input

AFIK input doesn't let you control the error behavior. The better approach would be to return it as a string, and validate it: ...

2 days ago | 0

fileDatastore using for loop and scatter

You are not even reading your csv files; you just read the same file file4.csv over and over! Try this: fds = fileDatastore('*....

2 days ago | 0

mean from intersection matrix

This should work: a = [1,3,3,2,2,3,3,4,3,1,3]; b = [1,1,1,3,4,1,2,1,4,1,1]; c = [2,2,2,4,2,3,3,2,1,3,8]; x = [a; b]; [~, ...

10 days ago | 0

| accepted

Read from and make new based on positions

Why not this? G = [0 115 0 0 0 0 0 0 0 0 111 0 0 0 0 110 0 0 0 110 0 0 0 0 82 0 0 0 0 111 0 0 0 111 0 0 0 0 0 0 0 0 0 87 114...

10 days ago | 1

| accepted

Bar plot error when plotting

The main problem is that your tick labels are too long to fit under the axes. You can try something like this: figure('Name', '...

30 days ago | 0

| accepted

Open .m files in current MATLAB instance from Windows Powershell

Try this function addME(a, b) fprintf("sum a + b equals %.2g\n", a + b) end Then from powershell (assuming your PS insta...

30 days ago | 0

What equivalent MATLAB commands plots PDF of data like 'hist' command plots histogram of data.

Something like this should work: data = normrnd(10,1,100,1); pd = fitdist(data, 'Normal'); x_values = 5:0.1:15; y_values = p...

1 month ago | 0

scatter plot data that meet a condition

% some random values A = randi([0, 100], 8, 2000); F = randi([0 1], 8, 2000); F = logical(F); % convert your flag to logical ...

1 month ago | 1

| accepted

How to calculate for significant difference between Cohen's Kappa values?

You can build confidence intervals around your Kappa values, and then see if they overlap.

1 month ago | 0

How to know which distribution is BCa method form bootci assuming my data follows

To my understanding BCa tries to correct for bias and skewness (acceleration, calculated from jackknife sampling) in the distrib...

1 month ago | 1

Is there a way to turn off the scale over the graph

h = gca; h.Box = 'on'; h.XAxis.TickLength = [0 0];

2 months ago | 0

| accepted

Standard Error for bivariable zscore normalized regression

And why is it surprising to you? You can read about how coefficients and their SE are calculated in linear regression. Standard...

2 months ago | 0

I have a table where each entry is a word/sentence. How do I count how many times a word shows up?

Check out groupsummary: gender = {'male', 'female', 'male', 'male'}.'; dogorcat = {'dog', 'cat', 'dog', 'dog'}.'; T = table(g...

2 months ago | 1

How can i change the linestyle in the parcorr function?

This should work: [~, ~, ~, h] = parcorr(randn(1000, 1)); set(gca,'YTick',[-0.3 0 0.5 1 ]) title('PACF Offshore') ylabel('pa...

2 months ago | 1

| accepted

Shifting the first element of an array to the end

a = 1:4; circshift(a, 1)

2 months ago | 1

stepwiselm() function is not taking the last column of table as Response variable

The issue stems from variable Timestamp, which is of class datetime. You need to first convert it to numeric type: data = readt...

2 months ago | 1

Floating bar graphs with characters and numerical data

What about this? tags = ["Al", "Ti", "Nb", "Co", "Mo"]; ranges = [0.01 0.58; 0.76 1.95; 5 5.61; 0 1; 2.63 3.11]; h = gca; h....

2 months ago | 0

| accepted

How to compute the correlation between two metrices of same dimenstion (correlation between a column of a matrix to corresponding column of other matrix)?

A = rand(10, 3); B = rand(10, 3); R = diag(corr(A, B))

2 months ago | 0

| accepted

Counting number of words and their characters

Maybe this help txt = ["Why MATLAB doesn't offer much for data science?"; "Python and R beat MATLAB in ML"]; voc = tokenizedDo...

2 months ago | 0

How to combine multiple sheet in an excel file in to a single sheey

Follow this example: file = "test.xlsx"; % replace your file name names = sheetnames(file); data = table; for i = 1:numel(...

2 months ago | 0

| accepted

Any efficient way to identify a set of 1s in a big array?

Try this a = [1 1 1 -1 0 0 0 0 1 1 -1 0 0 1 1 1 1 -1 0 0]; astart = [1, 9, 14]; astop = [3, 10, 17]; dda = diff([0, 0, dif...

2 months ago | 0

| accepted

I have 45x484 matrix but when I calculate coeff pca function, I am getting coeff with 484x44 matrix which causes errors in biplot. Why is the rows and columns switch places?

Well you should find the answer in your problem not MATLAB pca function. You have 45 observations with 484 variables, so degree ...

2 months ago | 1

| accepted

Extracting specific data from multiple excel files and create a single matrix from those

You can use readmatrix (assuming all values are numeric, otherwise use readtable) or fileDatastore to read those files. Somethin...

2 months ago | 1

Printing a MATLAB table on the console which contains both characters and ints

One simple way is to convert them to categorical, but if you're doing something with that variable, extra care should be taken. ...

2 months ago | 0

| accepted

Intersect table with Id scattered

If both tables don't share same key ids, you can simply join them as: tOne = table(["x1", "x2", "x3"].', (1:3).', 'VariableName...

2 months ago | 0