Question: The attached xlsx (Excel) file contains genuine lab data from a chromatography detector recorded at a rate of 10 Hertz, and contains, in column 1,
The attached xlsx (Excel) file contains genuine lab data from a chromatography detector recorded at a rate of 10 Hertz, and contains, in column 1, the signal in the units of micro volts. Write a Matlab code to read and plot the data: skip the first 25 rows; read only column 1, which shows the signal in micro volts. Convert from microV to mV; compress the signal data vector by keeping only every 120th entry; generate the corresponding time coordinate values by dead reckoning (remembering that the data-collection rate was 10Hz), assigning the first read entry to time zero. Suggested units for the x-axis: minutes; y-axis: mV. Bonus question: write additional lines of code which, from the data display, lets the user pick two points, and returns the average signal between the two points. Useful links:
https://www.mathworks.com/help/matlab/ref/xlsread.html https://www.mathworks.com/help/matlab/ref/ginput.html
Membrane Permeation GC Data.xlsx is below
=CHROM =Japan instruments =Valued Customer =N2024 = = =Step input = =CHANNEL 1 =RESTEK 15METER MXT-1 =HELIUM AT 5 PSI = = =ExampleComponentTable.cpt =RUN1 = = =TYPE YOUR COMMENTS HERE = 9-22-2016 =13:22:37 =10Hz =43622 =1.000000 =1.000000 =DEFAULT.CON 72795 72795 9/22/2016 13:22:37 72819 72819 9/22/2016 13:22:37 72828 72828 9/22/2016 13:22:37 72823 72823 9/22/2016 13:22:37 72835 72835 9/22/2016 13:22:37 72841 72841 9/22/2016 13:22:37 72855 72855 9/22/2016 13:22:38 72850 72850 9/22/2016 13:22:38 72845 72845 9/22/2016 13:22:38 72844 72844 9/22/2016 13:22:38 72839 72839 9/22/2016 13:22:38 72835 72835 9/22/2016 13:22:39 72835 72835 9/22/2016 13:22:39 72860 72860 9/22/2016 13:22:39 72865 72865 9/22/2016 13:22:39 72865 72865 9/22/2016 13:22:40 72879 72879 9/22/2016 13:22:40 72909 72909 9/22/2016 13:22:40 72935 72935 9/22/2016 13:22:40 72950 72950 9/22/2016 13:22:40 72930 72930 9/22/2016 13:22:40 72905 72905 9/22/2016 13:22:41 72875 72875 9/22/2016 13:22:41 72898 72898 9/22/2016 13:22:41 72923 72923 9/22/2016 13:22:41 72933 72933 9/22/2016 13:22:41 72913 72913 9/22/2016 13:22:42 72883 72883 9/22/2016 13:22:42 72871 72871 9/22/2016 13:22:42 72859 72859 9/22/2016 13:22:42 72865 72865 9/22/2016 13:22:43 72883 72883 9/22/2016 13:22:43 72900 72900 9/22/2016 13:22:43 72896 72896 9/22/2016 13:22:43 72851 72851 9/22/2016 13:22:43 72838 72838 9/22/2016 13:22:43 72839 72839 9/22/2016 13:22:44 72870 72870 9/22/2016 13:22:44 72876 72876 9/22/2016 13:22:44 72880 72880 9/22/2016 13:22:44 72885 72885 9/22/2016 13:22:44 72871 72871 9/22/2016 13:22:45 72863 72863 9/22/2016 13:22:45 72854 72854 9/22/2016 13:22:45 72833 72833 9/22/2016 13:22:45 72814 72814 9/22/2016 13:22:46 72815 72815 9/22/2016 13:22:46 72813 72813 9/22/2016 13:22:46 72808 72808 9/22/2016 13:22:46 72799 72799 9/22/2016 13:22:46 72786 72786 9/22/2016 13:22:46 72789 72789 9/22/2016 13:22:47 72794 72794 9/22/2016 13:22:47 72773 72773 9/22/2016 13:22:47 72786 72786 9/22/2016 13:22:47 72794 72794 9/22/2016 13:22:47 72796 72796 9/22/2016 13:22:48 72773 72773 9/22/2016 13:22:48 72768 72768 9/22/2016 13:22:48 72775 72775 9/22/2016 13:22:48 72776 72776 9/22/2016 13:22:49 72758 72758 9/22/2016 13:22:49 72726 72726 9/22/2016 13:22:49 72701 72701 9/22/2016 13:22:49 72741 72741 9/22/2016 13:22:49 72761 72761 9/22/2016 13:22:49 72774 72774 9/22/2016 13:22:50 72735 72735 9/22/2016 13:22:50 72718 72718 9/22/2016 13:22:50 72705 72705 9/22/2016 13:22:50 72703 72703 9/22/2016 13:22:50 72675 72675 9/22/2016 13:22:51 72636 72636 9/22/2016 13:22:51 72591 72591 9/22/2016 13:22:51 72595 72595 9/22/2016 13:22:51 72598 72598 9/22/2016 13:22:52 72596 72596 9/22/2016 13:22:52 72581 72581 9/22/2016 13:22:52 72574 72574 9/22/2016 13:22:52 72553 72553 9/22/2016 13:22:52 72559 72559 9/22/2016 13:22:52 72534 72534 9/22/2016 13:22:53 72510 72510 9/22/2016 13:22:53 72498 72498 9/22/2016 13:22:53 72478 72478 9/22/2016 13:22:53 72480 72480 9/22/2016 13:22:53 72486 72486 9/22/2016 13:22:54 72505 72505 9/22/2016 13:22:54 72548 72548 9/22/2016 13:22:54 72546 72546 9/22/2016 13:22:54 72530 72530 9/22/2016 13:22:55 72504 72504 9/22/2016 13:22:55 72504 72504 9/22/2016 13:22:55 72481 72481 9/22/2016 13:22:55 72445 72445 9/22/2016 13:22:55 72411 72411 9/22/2016 13:22:55 72379 72379 9/22/2016 13:22:56 72378 72378 9/22/2016 13:22:56 72386 72386 9/22/2016 13:22:56 72406 72406 9/22/2016 13:22:56 72401 72401 9/22/2016 13:22:56 72376 72376 9/22/2016 13:22:57 72361 72361 9/22/2016 13:22:57 72343 72343 9/22/2016 13:22:57 72313 72313 9/22/2016 13:22:57 72281 72281 9/22/2016 13:22:58 72258 72258 9/22/2016 13:22:58 72249 72249 9/22/2016 13:22:58 72251 72251 9/22/2016 13:22:58