Question: How do i solve this in excel? In the last module, you examined whether defendants received different sentences based on what they wore to court.
How do i solve this in excel?
In the last module, you examined whether defendants received different sentences based on what they wore to court. However, other factors might complicate this comparison! In this problem, we're going to examine whether sentence lengths varies by what the defendant wore to court (suit or no suit), their previous conviction status (no prior convictions, one prior conviction, multiple prior convictions), and the interaction of these factors. You will explore this data using ps11_sentence.xlsx or ps11_sentence.sav. The data set includes the following variables:
Sentence: Length of the sentence in years
Suit: Whether Respondent Wore a Suit in Court (0 = No; 1 = Yes)
Convict: Respondent's prior conviction status (0 = No Prior Conviction; 1 = One Prior Conviction; 2 = Multiple Prior Convictions)
For Excel, the sheet has data on sentence length organized by suit status and prior convictions.
Using this data, answer the following question (a=.05), answer the following questions. Include both your answer and program output from either SPSS or Excel.
- Does sentence length vary between those who wear a suit and those who do not?
- Does sentence length vary with prior conviction status?
Yes,
- Do sentence length vary with the interaction of dress and conviction status?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
