How to generate Matlab plot for this data?

4 views (last 30 days)
MS Amber
MS Amber on 29 Sep 2019
Commented: Walter Roberson on 30 Sep 2019
I have some data in excel sheet column 1 "control" and column 2 "experiment" (aprox 3000 data points in each column), how can I write a program where it can generate plot for these two column and the values I only need to keep from the columns would be in range of 0.5 to 3 only and exclude above and below it. How can I include statistics as well, like P values significance in program. I want to generate boxplot for control and experiment. Can you please share the written program for this.
Thanks

Answers (1)

Walter Roberson
Walter Roberson on 29 Sep 2019
filename = 'YourFile.xlsx';
data = xlsread(filename);
ce = data(:,1:2);
mask = all(ce >= 0.5 & ce <= 3);
usable_control = ce(mask,1);
usable_experiment = ce(mask,2);
in order to include P values significance, you need a hypothesis, which you have not told to us.
boxplot([usable_control, usable_experiment]);
  2 Comments
MS Amber
MS Amber on 29 Sep 2019
Thanks a lot! I can see now how it is working. Great learning place and support!
Walter Roberson
Walter Roberson on 30 Sep 2019
You can attach images here. Click on the picture frame, the left-most in the INSERT section of tools.

Sign in to comment.

Tags

Products


Release

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!