Answers

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search

St. Himark Radiation Analysis

Overview

Data Cleaning

Dashboard

Question & Answers

 


Analysis

Question 1

Visualize radiation measurements over time from both static and mobile sensors to identify areas where radiation over background is detected. Characterize changes over time.

Qns1.1.png
The chart above shows the average radiation of the mobile sensors (blue line) and static sensors (yellow line) by Neighbourhood. The red line is the 75cpm mark whereby any value beyond that point is abnormal.

As seen from above, from the 9th to 10th, Wilson Forest has spike in the radiation readings with an average value of 1093cpm on the 9th and 1258cpm on the 10th while the rest are under 54 and 72 on the 9th and 10th respectively.

Qns1-2.png
As the readings for Wilson Forest is very high on the 9th and the 10th, I decided to uncheck Wilson Forest to further analyse the other days.

For the analysis above, sensor id M12 has been filtered out (explained in Question 2).

Even though the average reading on the 6th of April are below 75cpm, there are certain spikes in certain neighbourhoods such as Broadview, Chapparal and Palace Hills etc.

Similarly, on the 7th of April, there are also a few peaks at certain neighbourhoods such as Broadview and Chapparal whereby they exceed 75cpm.

The more extreme readings can be seen on the 8th of April in Old Town whereby the mobile sensor readings spiked to 264.4, which the readings were above 75cpm from 5:30PM to 9:30PM.

Also, in Safe Town, there was a spike to 193.2CPM, which the readings were above 75cpm 1:20PM to 4:30PM. Apart from those towns, more towns have a radiation level exceeding 75cpm at certain timings.

Qns1-3.png In this analysis, I excluded Wilson Forest as there was a contrasting difference in the readings which will be explained in part 2 later.

From the 6th to the 7th, there is not much difference in the level of the radiation level, with a maximum of 15.4% increase in the average radiation level in Terrapin Springs. From the 7th to the 8th, there is a visible increase in the radiation level in old town whereby it increased by 118.5%.

Question 2