Let's gauge the sentiment intensity of the tweet "@GarfieldLineker @TimCRoberts *on his back. Apologies for retweeting a tweet with grammatical error #mybad 😱". Assign a real number within the range of 0 to 1, with 0 representing highly negative and 1 representing highly positive.