Basic Data Analysis – Cross-Tabulation& t-test

File Format: Word document only.

1. Create Cross-tabulation Tables (2.5 pts). See pp. 396-398 in textbook.

Browse the NBA 2018-2019 regular season webpage ( and look at the numbers in HOME and AWAY columns.

  1. A) Pick any two teams EXCEPT Golden Gate Warriors (sorry I know most of you love this team☺) and for each team create a Game Location (home vs. away) x Game Result (won vs. lost) contingency table.
  2. B) Coverteachcontingencytabletoapercentagecross-tabulationtable.
  3. C) Briefly discuss which team’s game results are more heavily influenced bygame location?

2. Conduct a univariate t-test. See pp. 403-407 in textbook and watch the video.

Choose either 2A or 2B to work on! Both 2A and 2B involve a univariate t-test. Hence, do not work on both.

2A: Suppose a Pizza-In store manager believes the average number of customers who order take-out is 18 per day. The store gathers a sample of data by recording the number of take-out orders for each of the 24 days it was open during a given month. The mean is calculated to be 20, and the standard deviation to be 4.8. Does the number of take-out orders differ from 18 per day? Follow the steps below.

2B: Leslie is in charge of the customer complaints at her company. According to her past few years of experience, the average number of customer complaints is 27.5 per week. In order to see whether or not her company received fewer complaints this year, she randomly sampled 14 weeks of complaints and calculated the average number of complaints as 24.7 and standard deviation as 3.8. Is the number of complaints different from 27.5 per week? Follow the steps below.

  1. State an appropriate null hypothesis and alternative hypothesis.
  2. Find the critical values at significant level α =.05 (see t-table in Module C2)
  3. Calculate the t-statistic.
  4. Compare t-statistic with critical values.
  5. Make a decision.