Tag Archives: Deliverable

Week 5 Lab 6 Deliverable

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.

Lab_6_the-counted-2016_simplifiedDownload

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?

Week 5 Lab 5 Cont

Week 5 Lab 5 cont.

This deliverable is a hands-on task that you should complete in an Excel file and upload

Submit an Excel file as the deliverable

To complete today’s deliverable (due before next class), please download the database below and replicate today’s lecture on how to create graphs in Excel.

The database below is the deliverable from Lab 4.

DB_for_deliverable_5contDownload

After creating all charts, rename, save and upload your file to the upload page.

At the end of the deliverable, you should have an Excel file with the following charts:

  • One Bar chart of Country of Birth
  • One Pie chart of Gender
  • One Column chart of Major
  • One Pie chart of Liking stats or not
  • Three column charts of Liking stats by gender (one clustered, one stacked, one 100% stacked)
  • One Scatterplot of the Age variable

In total, the deliverable Excel file will have 8 charts.

Week 4 Lab 4 Deliverable

Week 4 Lab 4 Deliverable

This deliverable is a hands-on task that you should complete using Excel and upload the resulting document

Replicate today’s video lecture and submit an Excel document

To complete today’s deliverable, you should follow these 3 steps:

  1. Download the Excel file named “LAB_4_DATABASE.xlsx” from the Resources page and open it using the desktop Excel app or the online Excel app.
  2. Complete the deliverable replicating all of the procedures shown in the Week 4 Lab 4 video.
  3. Save and upload the Excel file in the “Uploads” page. Follow the instructions you will find there for naming your file.

You should end up with following 6 tables:

  • Table Country of Birth
  • Table Gender
  • Table Age
  • Table Major
  • Table Do you like stats
  • Table Gender by Do you like stats

Due before next class.

Week 2 Lab 2 Deliverable

Week 2 Lab 2 Deliverable

Answer all questions in your own words. Be as short and precise as you can.


Due before next class

Questions

  1. The Stanford Open Policing project gathers, analyzes, and releases records
    from traffic stops by law enforcement agencies across the United States. Their goal is to help researchers, journalists, and policymakers investigate and improve interactions between police and the public. The following is an excerpt from a summary table created based off of the data collected as part of this project.

a) What variables were collected on each individual traffic stop in order to create to the summary table above?

b) State whether each variable is numerical or categorical. If numerical, state whether it is continuous or discrete. If categorical, state whether it is ordinal or not

c) Suppose we wanted to evaluate whether vehicle search rates are different for drivers of different races. In this analysis, which variable would be the response variable and which variable would be the explanatory variable?

2. A study is designed to test the effect of light level on exam performance
of students. The researcher believes that light levels might have different effects on males and females, so wants to make sure both are equally represented in each treatment. The treatments are fluorescent overhead lighting, yellow overhead lighting, no overhead lighting (only desk lamps).

a) What is the response variable?

b) What is the explanatory variable? What are its levels?

3. What type of variable is telephone area code? Choose only one answe

a) Numerical, continuous

b) Numerical, discrete

c) Categorical

d) Categorical, ordinal

Week 2 Lab 1 Deliverable A

Week 2 Lab 1 Deliverable A

Math review. Respond to all 9 items.

Round to the nearest hundredth (2 decimal places; i.e. 0.72).

You should use a calculator.

Due before next class.

1.) 17(3)

2.) 17/3

3.) (42)2

4.) √113

5.) (113)(-2)

6.) 322/-11

7.) Remember the order of operations

8.) Remember the order of operations

9.) Remember the order of operations

Lab 0 Deliverable A

Lab 0 Deliverable A

Respond all following questions in your own words replying as a comment.

Due before the next class.

1. What was Hans Rosling’s main message regarding development during the last 200 years?

2. What would you critique of his presentation and why?

3. Was there something that wasn’t clear from his presentation or something you would like to clarify further or did you understand everything that was presented? If something was unclear, what would that be?