Week 4 Lab 5 Deliverable

Week 4 Lab 5 Deliverable

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

Due before next class

Submit an Excel file as the deliverable

To complete today’s deliverable (due before next class), please download the document below and follow the instructions.

Instructions for the deliverable are here:

Lab5 deliverableDownload

You should complete the whole excercise in an Excel file.

After you complete the required tasks, save your work and name it with your name and the name of the lab (Lab#-Yourname.xlsx).

Next, please upload the resulting Excel file through the “Uploads” page.

Where to find the database?

The deliverable uses a database created by the newspaper The Guardian. To download and work on the database, go to the “Resources” page.

You can also download it here:

the-counted-2016Download

Important hints!!!

All data is located in the Excel sheet called “in”.

The range of the data: data starts in row 2 and ends in row 1094.

More information about the database

The database was created by a research project called “The Counted” by The Guardian. You can visit the project page in this link:

https://www.theguardian.com/us-news/ng-interactive/2015/jun/01/the-counted-police-killings-us-database

For more details about the database, visit this link:

https://www.theguardian.com/us-news/ng-interactive/2015/jun/01/about-the-counted

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 3 Lab 3 Deliverable

Week 3 Lab 3 Deliverable

Each group should answer all questions together and submit one survey and one group response.

Include a header with the names of all group members.

Due before next class

Creating a Survey on Intimate Partner Violence

In this lab, you will design a survey and identify the levels of measurement of your variables.

Your research question is:

What is the prevalence of Psychological/Emotional Intimate Partner Violence in Brooklyn?

Assume you will give this survey to a representative sample of household members in Brooklyn.

1. Create a survey using Google Forms that will give you data to answer your research question. Make sure you follow the best practices we have discussed in class.

Your survey should have between 7 and 10 questions, including socio-demographic information. Consult the “Intimate Partner Violence and Sexual Violence Victimization Assessment Instruments for Use in Healthcare Settings”, by the CDC for the questions on emotional or psychological violence (download it from the Resources page)

Send the survey link to [email protected]

2. Identify the unit of analysis of the research and list all your questions here. For each question identify whether it is numerical or categorical, and what response options there are.

Sampling Strategy (who you will give the survey to). Answer all the following questions:

3. What is your study population?

4. Which representative sampling strategy will you use? Why?

5. Discuss in detail how you will draw your sample (your procedure.)

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?