Yes, goosebump can be a sign of arousal. Goosebump is when you experience raised skin, usually caused by the involuntary erection of hairs on the body, mostly on the neck and arms. The medical term for goosebump is piloerection or cutis anserine. Goosebump is often caused by cold air, extreme emotions such as shock, excitement, arousal, or fear. It is impossible for you to control this experience consciously, meaning it cannot be faked. Goosebumps is a defense mechanism of the body. When the muscles that are underneath the skin contract, this makes individual hair strand to stand. Bear in mind that it is possible to be aroused without having Goosebumps.