6 Dell Data

6.1 Dell Data Visualization

We have included plots for Dell’s Twitter engagement, stock price, and a comparison of the two against one another. The first plot shows the change in engagement through the Twitter handle “@DellCares”. The second plot shows the change in the stock price over the course of the three weeks we collected data. While there is a reasonable amount of change between variables on both of the plots, the general trend of the data is similar.

ggplot(filter(new_all_data, CompanyName=="Dell"), aes(x = New_Date,y= Company_Date)) +
  geom_line(aes( color= CompanyName), lty = 1, size = 2) +
  geom_hline(yintercept = 0, size = 1, color="#333333") +
  xlim(x= c(Sys.Date()-23, NA))+
    theme(legend.title=element_blank())+
  labs(title="Dell Twitter Data", x= "Date", y= "Number of Tweets")

ggplot(filter(companystock, Company=="Dell"), aes(x = StockDate,y= Price)) +
  geom_line(aes( color= Company), lty = 1, size = 2) +
  geom_hline(yintercept = 48, size = 1, color="#333333") +
  scale_colour_manual(values = c(Dell="#00BFC4"))+
    theme(legend.title=element_blank())+
  labs(title="Dell Stock Data", x= "Date", y= "Price of Stock ($)")

ggplot(filter(companystock, Company=="Dell"))+
  geom_line(aes(x= StockDate, y= scale(Price), color = "Stock Price"), lty = 1, size = 2)+
  geom_line(aes(x= StockDate, y= scale(Tweets), color = "Number of Tweets"), lty = 1, size = 2)+
    theme(legend.title=element_blank())+
  labs(title="Dell Stock and Twitter Data Comparison", y= "Rate of Change", x= "Date")

6.2 Dell Conclusion

While Dell’s Twitter and stock data seem to lack a clear trend in the first two plots, the third plot shows that the data is consistent. While there are areas of difference, the general trend in regards to the rate of change is visibly similar. The stock price didn’t vary by more than $12 during our period of collection and the Twitter data was fairly stable with only a few instances of steep drops or rises. This leads us to believe that our hypothesis is supported through the analysis of Dell’s Twitter and stock price data.