Workshop Statistics
Lab 2

Prelab 1: Introduction 2: Files 3: Two-way Table 4: Numerical Summary 5: Graphical Summary 6: Discussion 7: Thought Questions 8: Simulation 9: Applet 10: Analysis 11: Conclusions 12: Application 13: Simulation 14: Comparisons 15: Summary

Creating a Two-way Table

After collecting the data, the next step is to produce some numerical and graphical summaries of the sample data. The goal is to discuss the overall patterns in the data. Here we don’t want to just present a bunch of "yawned" and "didn't yawn" outcomes but a simple number and a picture or two that best represents what we learn from the data.

(a) Use technology to organize the data in a two-way table of counts:

Click here to display Minitab instructions

OR

Click here to display Excel instructions

---

From the main Minitab menu, choose Stat > Tables > Cross Tabulation and Chi-Square.
For the rows, enter the column containing he response variable - either type it in or double click on it in the left pane. Then click in the For columns box and specify the column containing the explanatory variable.
Click OK.

---

Video Instructions: Click here to see a demo on how to create a table in MInitab from raw data.

---

---

Use your mouse to select the two columns of data.
Select Insert > PivotTable. Indicate where you want the table. I suggest selecting in "Existing Worksheet" and specifying an empty cll near the data, such as D1. Press OK.
The PivotTable Field List should now appear.
From here, drag the "group" variable to the Column Labels box and the "outcome" variable to the Row Labels box. Then also drag the "group" variable into the Values box. The two-way table should now appear

---

Take a screen capture of the table and copy and paste it into your lab report. Then return back here and click the Next button for futher instructions.