Cummulative Pressure vs. Counts

From MariachiWiki

This tutorial combines all of your pressure files into one file so as to have enough data points to see any relevant correlation.

1. Open - Open a new Excel file and name it “pressure vs. counts.xls.” Open the existing “pressure vs. counts_week[x].xls” files.

2. Copy - On the existing file, highlight the data cells in columns F and G and copy them.

3. Paste special - Using the “paste special -> values” option from the Edit menu, paste the copied cells into column A (starting with A2). Do this for each week that you have data for, pasting the new data in the first empty A cell.

4. Labels - In A1 type “average pressure” and in B1 type “number of counts”.

5. Select - Select all the data cells.

6. Chart - From the Insert menu, choose “chart”. Step 1 – XY scatter -> next; Step 2 – do nothing -> next; Step 3 – title – Cummulative Pressure vs. Number of Counts for [x] weeks, x-axis – Pressure, y-axis – Number of counts, on the “gridlines” tab, check major and minor gridlines on the x-axis, on the “legend” tab, choose to not display the legend; Step 4 -> finish.

7. Save!

EXAMPLE

---

Back to Correlation with Pressure

Back to Candice