Objective:

Scenario:

A valuable artifact has been stolen from a museum. The police have narrowed down the list $of$ suspects based $on$ a few criteria:

The suspect was $in$ the museum $on$ the day $of$ the theft.

The suspect's alibi $is$ either missing $or$ unverified.

The suspect has been involved $in$ similar incidents $in$ the past.

You are tasked with using Excel logic functions $to$ determine who the likely culprit $isby$ analyzing the suspect data.

Dataset:

You have a dataset containing the following columns for each suspect:

Suspect Data.$csv$ darr

Suspect Name

Location $on$ Day $of$ Theft $(values$: "Museum", "Not Museum"$)$

Alibi Status $(values$: "Verified", "Unverified", "Missing"$)$

Previous Offenses $(values$: "Yes", $"No")$

Time $of$ Arrival $(timein$ hours$)$

Time $of$ Departure $(timein$ hours$)$

Task $1$: Identify Suspects Who Were $in$ the Museum

Use the $IF$ function $to$ label each suspect $as$ a "Potential Suspect" $if$ they were $in$ the museum $on$ the day $of$ the theft, and "Cleared" $if$ they were not $in$ the museum.

Task $2$: Check Alibi Status

Task $3$: Combine Alibi and Offense History

Use AND $to$ combine the logic for alibi status and previous offenses:

$If$ the suspect's alibi $is$ "Unverified" $or$ "Missing" and they have previous offenses, mark them $as$ "High Risk."

$If$ the suspect's alibi $is$ verified $or$ they have $no$ offenses, mark them $as$ "Low Risk."

Task $4$: Identify Key Times

For suspects marked $as$ "High Risk," calculate whether they could have committed the crime based $on$ their Time $of$ Arrival and Time $of$ Departure.

Assume the theft occurred between $14$:$00$ and $16$:$00.$

Use the $IF$ and AND functions $to$ label suspects $as$ "Present During Theft" $if$ their arrival time $is$ before $14$:$00$ and their departure time $is$ after $16$:$00.$

Task $5$: Final List $of$ Suspects

Based $on$ your analysis, create a final list $of$ suspects who meet all the criteria:

They were $in$ the museum.

They are suspicious based $on$ their alibi and offense history.

They were present during the time $of$ the theft.

Use the AND function $to$ combine the results from the previous steps.

Bonus Task:

Eliminate innocent suspects: Use the NOT function $to$ identify suspects who $do$ not meet the criteria and eliminate them from the list.

Submission Instructions:

Complete all tasks $by$ applying the necessary $logical$ functions.

Create a final list $of$ suspects who meet the criteria for being the primary suspects.

Submit your Excel file with the solved mystery. Suspect Name Location on Day of Theft Alibi Status Previous Offenses Time of Arrival Time of Departure