Statistics using Excel, a data type based approach

5 Extra
5.1 Control

5.2 Questions

  1. For which kinds of data can we make a histogram using just counts?
  2. For which kinds of data can we make a cumulative count graph?
  3. What is the probability of the value “Cat” in this data set: Mouse, Cat, Mouse, Dog, Mouse, Dog, Mouse, Mouse
  4. What is the probability of the value “Dog” in this data set: Mouse, Cat, Mouse, Dog, Mouse, Dog, Mouse, Mouse
  5. What is the probability of the value “Mouse” in this data set: Mouse, Cat, Mouse, Dog, Mouse, Dog, Mouse, Mouse
  6. What is the median of the following values: 2, 5, 3, 4, 1
  7. What is the median of the values 2, 2, 6, 4, 6, 4
  8. What is the median of the following grades, knowing that grades follow the order F, D, C, B, A: F, B, D, A, C, C, B, A, F
  9. What is the mean of the following values: 1, 4, 3, 7, 5
  10. What is the mean of the following values: 14, 25, 46, 34, 11
  11. What is the standard deviation of the following values: 1, 3
  12. What is the standard deviation of the following values: 10, 25
  13. To which kind of data can you apply Pearson’s chi-squared test?
  14. To which kind of data can you apply Fishers’s exact test?
  15. To which kind of data can you apply Student’s T test?
  16. To which kind of data can you apply Fisher’s exact test?
  17. You apply Pearson’s chi-squared test, and it returned a p-value of 3%. What is the meaning of this?
  18. You apply Fisher’s exact test, and it returned a p-value of 12%. What is the meaning of this?
  19. You apply Student’s T test, and it returned a p-value of 1%. What is the meaning of this?
  20. You apply an F test, and it returned a p-value of 20%. What is the meaning of this?
  21. A diagnostic test has it results written as (A,B), where both A and B can be either P (for positive) or F (for negative), and the first entry represents the reference for the test, and the second the result of the diagnostic. The results were (T,T), (T,F), (F,T), (T,T), (F,F), (F,T), (T,T). How many true positives does this test has?
  22. A diagnostic test has it results written as (A,B), where both A and B can be either P (for positive) or F (for negative), and the first entry represents the reference for the test, and the second the result of the diagnostic. The results were (T,T), (T,F), (F,T), (T,T), (F,F), (F,T), (T,T). How many false positives does this test has?
  23. A diagnostic test has it results written as (A,B), where both A and B can be either P (for positive) or F (for negative), and the first entry represents the reference for the test, and the second the result of the diagnostic. The results were (T,T), (T,F), (F,T), (T,T), (F,F), (F,T), (T,T). How many false negatives does this test has?
  24. A diagnostic test has it results written as (A,B), where both A and B can be either P (for positive) or F (for negative), and the first entry represents the reference for the test, and the second the result of the diagnostic. The results were (T,T), (T,F), (F,T), (T,T), (F,F), (F,T), (T,T). How many true negatives does this test has?
  25. A diagnostic test has it results written as (A,B), where both A and B can be either P (for positive) or F (for negative), and the first entry represents the reference for the test, and the second the result of the diagnostic. The results were (T,T), (T,F), (F,T), (T,T), (F,F), (F,T), (T,T). What is the sensitivity of this test?
  26. A diagnostic test has it results written as (A,B), where both A and B can be either P (for positive) or F (for negative), and the first entry represents the reference for the test, and the second the result of the diagnostic. The results were (T,T), (T,F), (F,T), (T,T), (F,F), (F,T), (T,T). What is the specificity of this test?
  27. A diagnostic test has it results written as (A,B), where both A and B can be either P (for positive) or F (for negative), and the first entry represents the reference for the test, and the second the result of the diagnostic. The results were (T,T), (T,F), (F,T), (T,T), (F,F), (F,T), (T,T). What is the PPV of this test?
  28. A diagnostic test has it results written as (A,B), where both A and B can be either P (for positive) or F (for negative), and the first entry represents the reference for the test, and the second the result of the diagnostic. The results were (T,T), (T,F), (F,T), (T,T), (F,F), (F,T), (T,T). What is the NPV of this test?
  29. Which ones of these are types of text weight in Word?
  30. Which ones of these are types of text alignment in Word?
  31. Which ones of these are types of text justification in Word?