Skip to Content
Author's profile photo Former Member

Can you reduce the risk of cancer by changing Habits

Here is my first submission for Data Geek Challenge 2…

My objective of analysis to see if I can see any correlation of food habit and exercise and  with breast Cancer in females in US aged 16-64.

Lets see if the data shows any correlation with the smoking, obesity , eating habits and any relationship with Brest cancer across US states  I will be using Predictive analysis. I got the data point from the below link as CSV and did a little cleansing.

Here is the source I got some of my data from.

http://statecancerprofiles.cancer.gov/

/wp-content/uploads/2013/08/1_266484.png

Now lets import the CSV data into predictive analysis and then we will merge the data for the possible related factors with it.

/wp-content/uploads/2013/08/2_266486.png

Now once the data is acquired we will have to enrich the time hierarchy data and Geo graphic data in this case the states.

Now I would create a Geographic hierarchy Region for states so that I can use the dimension in the Geo maps. I would be assigning the non mapped states manually.

/wp-content/uploads/2013/08/3_266488.png

Now acquiring and merging the other parameter and merging based on the state dimensions.

/wp-content/uploads/2013/08/4_266490.png

/wp-content/uploads/2013/08/6_266501.png

Now lets start plotting just the % incident numbers by state in a Geo map.Now here is the chart which looks pretty much the same for all the states.

/wp-content/uploads/2013/08/7_266531.png

Now here comes the need for the some basic predictive analysis.Having said that let me be very clear here I am beginner in the predictive analysis stuff though worked in R with HANA a while ago.We would normalize the data based on a Max min Scaling algorithm with min-Max as (1-0).

/wp-content/uploads/2013/08/8_266532.png

Now platting the scaled data looks like data is scaled for based on the algorithm and gives some better idea of the data.

/wp-content/uploads/2013/08/9_266533.png

Thats a good start.

Now let’s create a bubble chart of Annual Incidence Rate per 100,000 polulation with the % of Obesity and % of Smoking for the top 10 incidents. For this we had already  merging the data from another spreadsheet. Here is how it comes as.

/wp-content/uploads/2013/08/10_266537.png

Ok lets do a regression of this incident with Obestity % and plotting the output. This is open for interpretation.

/wp-content/uploads/2013/08/11_266538.png

Now plotting the linear regression of with Obesity numbers

/wp-content/uploads/2013/08/12_266539.png

Now out of curiosity let’s see if there is any relationship we can find with Obesity & Smoking using the chart and looks like there is a pretty good correlation just by looking into it. Now let’s find out what is the correlation coefficient.Now lets do a regression.

/wp-content/uploads/2013/08/14_266541.png

/wp-content/uploads/2013/08/17_266990.png

/wp-content/uploads/2013/08/13_266540.png

Now plotting the predicted numbers in a bar chart shows there are some correlation. So we can infer if a person is a smoker there is a higher chance that

he is obese.

/wp-content/uploads/2013/08/b_266542.png

Now let’s plot it with the % of people eating fruit 5 times a day and see any correlation. Looks like people who are obese and smoke most likely eat less fruit and vegetable. As there is clearly a downward trend.So thats great its just confirming what we normally think./wp-content/uploads/2013/08/18_266546.png

Now let’s quickly see any relation between Insured Percentage before any analysis. Again its quite obvious the persons who are obese and eat less fruit and veg tends to be less insured as well.

/wp-content/uploads/2013/08/19_266547.png

As I mentioned earlier this is my first post here , I will have some more post once I something more to share.Thanks for reading.

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nic Smith
      Nic Smith

      Well done! Fantastic Data Geek entry.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Nic..

      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      really nice.. fantastic stuff !!!

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Jitendra...

      Durga

      Author's profile photo Former Member
      Former Member

      Good Stuff...

      Best Regards,

      Naresh K.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Naresh...

      Cheers!!

      Durga

      Author's profile photo Former Member
      Former Member

      Very interesting use case and excellent post! I am quite the beginner at analytics and you have inspired me to take another look at the algorithms that are giving me so much trouble in my own Data Geek effort.

      Cheers,

      Gretchen

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Gretchen for the kind words... hearing nice things like this inspires me to put some efforts into the my analytics quest. Predictive analysis tool is much easier to use for casual analysis than R that I used earlier... you are going to find it interesting..

      Cheers!!

      Durga

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Well done..

      Author's profile photo Former Member
      Former Member

      Fanastic Job! Keep up the good work

      Regards,

      Hari Suseelan

      Author's profile photo Former Member
      Former Member

      Thank you for posting stuff on Predictive analysis. πŸ™‚

      Just i want to explore on Analysis, this helps me lot. ℹ ℹ

      Regards,

      Chandrakanth πŸ™‚ .

      Author's profile photo Yasemin ULUTURK
      Yasemin ULUTURK

      Very well done. It gives idea on how to use Predictive ANalysis and helps a lot. Thank you for sharing. πŸ™‚

      Regards

      Yasemin

      Author's profile photo Former Member
      Former Member

      Really awesome stuff and imagination. It definitely is very informative for beginners and good example.

      All the best.