Take the 2-minute tour ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.

How should I assign variables to the data imported from excel containing 3 columns which are time, mean and standard deviation. I want to perform operations on the three variables to get new variables.

The excel file can be found on the link: https://drive.google.com/file/d/0B26xdKbTd58_SVRlOEdNaVV4VGM/edit?usp=sharing

share|improve this question

1 Answer 1

up vote 4 down vote accepted
{time, mean, std} = 
  Transpose[Import["C:\\Users\\...\\Downloads\\MEANSDVALUES.xlsx"][[1]]] 
  (* use the appropriate directory for your file *)   
share|improve this answer
    
Okay I tried this,thanks. Then I create an array say time_t of 130 elements in which i want to fill the elements of the above time matrix. How should i achieve this.? –  Pawan Apr 20 at 9:40
    
@Pawan, not sure i understand; you mean something like array=ConstantArray[0,3,130}];array[[All,;;109]]={time,mean,std}? –  kguler Apr 20 at 9:56
    
I would like to add all the elements from a matrix into an array so that I can access each element as time_t[1,2]... and perform operations on them to get a new array. For e.g.. For 2 matrices say time= {0,1,2...130} and mean={1.2,4.5,...}, whose elements need to be transferred into 2 arrays say time_t and mean_t so that I can perform operations on the mean_t and time_t arrays to get new arrays(values) say time_t1 and mean_t1 –  Pawan Apr 20 at 14:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.