title: How to calculate average response time from the csv file that JMeter produces?
body: <p>I am running the Ant task to run my JMeter script or jmx file. The script runs smooth and produces a csv file with the following (standard) information: timeStamp, elapsed, label, responseCode, threadName, success, bytes, grpThreads, allThreads, Latency, sampleCount, ErrorCount and Hostname.</p>
  
  <p>My question is: how can I calculate the average response time from this CSV file? What is the formula? I know how to load the CSV file into MS-Excel but simply don't know what is the relationship among the elapsed time and latency with the average response time.</p>
  
  <p>Can anyone please provide the formula with some explanations, if possible. Thank you!</p>
  
  <p>--Ishti</p>