For this deliverable, you should use Excel to perform a T-test and an ANOVA test. The tests should be the same ones you see in the video on T-test (link here) and the video on ANOVA (link here).
To reproduce the content of both videos, you should download and use this database file:
For this deliverable, you should use Excel to perform a Chi-square test of independence. Copy the content of the tables and then perform the steps shown in the second video of lab 14 (click here to review the video). The procedure to do a Chi-square test starts on minute 14:00 of the video.
For each answer, please state the null hypothesis, state if you have evidence enough to reject the null hypothesis, and finally state what the conclusion is.
Q1. A sample of 25 cities has been classified as high or low on their homicide rates and on the number of handguns sold within the city limits. Do cities with higher homicide rates have significantly higher gun sales? Explain your results in a sentence or two. Use an Alpha level of 0.05.
Q2. A program of pet therapy has been running at a local nursing home. Are the participants in the program more alert and responsive than nonparticipants? The results, drawn from a random sample of residents, are reported here. Use an Alpha level of 0.05.
Some results from a survey administered to a nationally representative sample are presented here. For each table, conduct the chi-square test of significance and compute column percents. Write a sentence or two of interpretation for each test. Use an Alpha level of 0.05.
Q3. Is the support for the legal right to an abortion different by age group?
Q4. Does the support for the death penalty differ by age?
For this deliverable, you should draw a curve by hand. Look at this lab’s videos to understand how to carry out the exercises.
Due before next class, on Wednesday 10/14
This deliverable comes from the Open Intro Statitstics Book, p. 142
Respond to the questions by answering to the post.
1. What percent of a standard normal distribution N (μ = 0, σ = 1) is found in each region? Hint! Be sure to draw a graph and use the distribution tables on the Resources page. (a) Z score −1.35
(b) Z score above 1.48
(c) Between Z score of −0.4 and Z score of 1.5
(d) Z score below – 2 and Z score above 2
2. Sophia who took the Graduate Record Examination (GRE) scored 160 on the Verbal Reasoning section and 157 on the Quantitative Reasoning section. The mean score for the Verbal Reasoning section for all test takers was 151 with a standard deviation of 7, and the mean score for the QuantitativeReasoning was 153 with a standard deviation of 7.67. Suppose that both distributions are nearly normal. (a) Write down the short-hand for these two normal distributions. (b) What is Sophia’s Z-score on the Verbal Reasoning section? On the Quantitative Reasoning section? Draw a standard normal distribution curve and mark these two Z-scores. (c) What do these Z-scores tell you? (d) Relative to others, which section did she do better on? (e) Find her percentile scores for the two exams. (f) What percent of the test takers did better than her on the Verbal Reasoning section? On the Quantitative Reasoning section? (g) Explain why simply comparing raw scores from the two sections could lead to an incorrect conclusion as to which section a student did better on.
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.
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)
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.)
Answer all questions in your own words. Be as short and precise as you can.
Due before next class
Questions
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
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?
Need help with the Commons?
Email us at [email protected] so we can respond to your questions and requests. Please email from your CUNY email address if possible. Or visit our help site for more information:
