Week 5 Lab 6 Deliverable
For this deliverable, you will use the skills you have learned in Excel to process data.
Due before next class.
OBS! For this deliverable, you are expected to work in Excel to answer all the questions, but you do not need to upload your Excel document.
In this lab, you will use Excel to calculate measures of central tendency using The Guardian’s data set that compiles police killings in the U.S. in 2016. You will compute the mode, median, mean, and percentile commands in Excel.
Instructions
Download the database named “Lab_6_the-counted-2016_simplified.csv”. Open the data in Excel. It’s a more simplified version of the data you used in the last lab. Compute the data in Excel but answer the questions in this post.
Questions (answer all of them)
1. What is the most common age of those killed by law enforcement in this data set? In any blank cell, type =mode(C:C) to get the answer.
2. What is the most common day of the month reported in this data set?
3. What is the typical age of those killed by law enforcement? In any blank cell, type =median(C:C) to get the answer. What does this mean?
4. What is the typical day of the month reported in the data set? What does this mean?
5. What is the average age of those killed by law enforcement? In any blank cell, type =average(C:C) to get the answer.
6. Is the age variable skewed in these data? How do you know? Hint: Today’s lecture video shows how to tell if your data is skewed.
7. What age is the 25th percentile in these data? In any blank cell, type =percentile(C:C, .25) to get the answer. What does this mean?
This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.
1. 25
2. 11th
3. 35 years old
4. the 16th
5. 36.81 years old
6. No skew
7. 27, 25% of victims were under 27 years old
1. The most common age of people killed in this data set is 25 years old.
2. The most common day of the month is the 11th.
3. The typical age of those killed by law enforcement is 35 years old.
4. Day 16 is the most typical day of the month reported. This means that half of the reports were made before the 16th and the other half after.
5. The average age of those killed by law enforcement is 36.81.
6. The age variable is not skewed because the average or mean which is 36.81 is close in range to the median which is 35.
7. 27 years old is the 25th percentile in this data set, that means 25% of all the ages reported are under 27 years old.
1) The most common age of those killed by police was 25 years old.
2) The most common day of the month was the 11th.
3) The typical age of those killed by the police was 35 years old.
4) The typical day of the month was the 16th.
5) The average age of those killed by police was 36.81 years old.
6) There was no skew because the mean and median were so close to each other.
7) The age in the 25th percentile was 27 years old which means that from the data gathered, 25% of people that were killed were below the age of 27.
1) 25
2) 11
3) 35
4) 16
5) 36.811
6) Mean and Median are close: No skew
7) 27: This means 25% of the age found in the date fall below age 27
1. Most common age is 25
2.Day 11
3. The typical age is 35
4.16
5.36.811
6. No skewed is available because the mean 36.11 is close to the median 35
7. The age of 27 is the 25th percentile which means 25% of people killed are 27 years old and under
1) 25
2) 11
3) 35. This speaks about the average of those killed by law enforcement.
4) 16
5) 36.81
6) No.
7) 27. This means that out of twenty-five percent, there are some who scored above twenty-seven years old and some who scored below it.
1. (Mode) Age 25
2. (Mode) Day 11
3.( Median) Age :35. This means that 35 is the common age for those that got killed by law enforcement.
4. (Median)16. This means that is the day when most deaths are reported.
5. (Average) age: 36.81180812 the age for those killed by law enforcement,
6. The age variable is not skewed because the mean (36.81180812) and the median (35) is very close in numbers.
7. Age 27 is the 25th percentile which means 25% of the ages reported are under the age of 27
1. 25
2. 25
3. 35. Median = middle case
4. 11
5. 36.81
6. There is no skew because the median and mean are close.
7. 27. which means those killed by police are the age 27 and under
1. Age 25
2. Day 11
3. 35 years old. This represents the exact center of age distribution, which mean 50% of people who were killed by law enforcement were above 35 and 50% below 35 years of age.
4. Day 16. This means that the center day of death reports of the month is on the 16th, and 50% of reports were made before the 16th and another 50% after the 16th.
5. 36.8 is the average age.
6. No, it’s not skewed because the mean (36.8) and the median (35) age variable are close to equal.
7. Age 27, which means that 25% o the age group falls below the age of 27.
1. Mode of age= 25
2. Mode of days of the month=11
3. Median of age=35
4. Median of days of the month=16
5. Mean (average) of age=36.81181
6. The age variable is not skewed because both the mean (36.81181) and the median (35) are close in range.
7. The age of 27 is the 25th percentile. This means that 25% of the ages reported, fall below the 27 age mark.
1. The most common age of those killed by law enforcement in this data set is 25.
2. The most common day of the month reported in this data set is January 5 because it occurs six times.
3. The typical age of those killed by the law enforcement is 35. This means that those who were killed by the law enforcement where 35 years old.
4. The typical day of the month reported in the data set is December. This means that December occurs most and more in excel and is more likely a regular day could resemble it.
5. The average age of those killed by law enforcement is 36.81181.
6. No, the age variable is not skewed. I know its not skewed because the mean is larger than the median.
7. The age in the 25th percentile is 27 in the data. This means that it can be worked out by applying the formula which is =percentile(C:C,.25).