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.

  1. Does sentence length vary between those who wear a suit and those who do not?
  2. Does sentence length vary with prior conviction status?

Yes,

  1. Do sentence length vary with the interaction of dress and conviction status?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock