For this question, you are required to use the age variable (agep) in the Excel file “2001_CA_Census_small.xlsx”. Using the software of your choice, answer the following questions. Your answers must have 2 digits after the period. a) What is average age in your sample? b) What is the standard error? c) Compute the 99% confidence interval and the margin of error for the population mean age of Canadians based on your sample?*
part B and C
For this question, you are required to use the age variable (agep) in the Excel file “2001_CA_Census_small.xlsx”. Using the software of your choice, answer the following questions. Your answers must have 2 digits after the period.
a) What is average age in your sample?
b) What is the standard error?
c) Compute the 99% confidence interval and the margin of error for the population mean age of Canadians based on your sample?*
* Think about what you did here. You used a very small sample (26 people) to have a not too large interval for where the average age of all Canadians (more than 35,000,000) people lies with a very high confidence level. This the power of statistics! If you want to see what a larger sample size does, re-do this exercise using 2001_CA_Census.xlsx. You will see that the 99% C.I. gets pretty small.
| caseid | agep | sexp |
| 1 | 54 | 1 |
| 2 | 39 | 1 |
| 3 | 42 | 2 |
| 4 | 18 | 2 |
| 5 | 14 | 1 |
| 6 | 42 | 2 |
| 7 | 40 | 1 |
| 8 | 19 | 1 |
| 9 | 59 | 2 |
| 10 | 44 | 2 |
| 11 | 41 | 1 |
| 12 | 17 | 2 |
| 13 | 48 | 2 |
| 14 | 36 | 1 |
| 15 | 9 | 2 |
| 16 | 3 | 2 |
| 17 | 71 | 2 |
| 18 | 56 | 2 |
| 19 | 67 | 1 |
| 20 | 48 | 2 |
| 21 | 52 | 1 |
| 22 | 70 | 1 |
| 23 | 83 | 2 |
| 24 | 54 | 2 |
| 25 | 74 | 1 |
| 26 | 68 | 1 |
Step by step
Solved in 2 steps
