Lab Note: The tools presented in this lab periodical/y change. Updated instructions, if applicable, can be found in the eBook and lab wa/kthrough videos in Connect. Case Summary: As an analyst, you are now responsible for understanding what role textual data plays in the performance of a company. A colleague of yours has scraped the filings off of the SEC's website and calculated the frequency distribution of positive and negative words among other dimensions using the nancial sentiment dictionary classified by Loughran and McDonald. Your goal is to create a dashboard that will allow you to explore the trend of sentiment over time. Data: Lab 8-4 SP100 Sentimentzip -111KB Zip / 114KB Excel Note: Submit your answers for the following Analysis Questions in the text entry field below. A01. Click through several of the companies to observe their word counts and positivenegative ratios. What patterns to you notice? A02. If you look at the scatter plot for all NYSE companies, do word count and positive-negative ratio appear to be correlated? In other words, if a company has more to say, does that mean it is more likely to say positive or negative things? A03. What do you notice about the count of positive and negative words compared to the total word count? How might this comparison impact your conclusions? A04. How else might you want to evaluate or visualize nancial sentiment? Company. Name Proportion of Positive and Negative Words Word Count (All) 3M CO Date.Filed Year of Pos Neg Ratio Word. Count ABBOTT LABORATO Date. Filed Lm.Negativ.. Lm.Positiv.. 0.417 75,040 31,006 41.32% 3,394,966 AbbVie Inc 2014 20K 2015 74,061 30,777 41.56% 3,365,674 ADOBE INC 2016 31,435 41.32% 3,432,161 ALLERGAN INC 76,083 OK 0.416 ALLSTATE CORP 2017 77,247 32,231 41.72% 3,537,628 ALTRIA GROUP INC Pos Neg Ratio -20K AMAZON COM INC Value 0.415 Year of Date. Filed -40K (All) 2014 0.414 60K 2015 2016 -80K 0.413 2017 2016 2014 2015 2017 2018 2019 Most Positive Company Companies with the Most to Say PNR by Average Word 2020 X Company.Name Company.Name Count Exchange (All) NASDAQ 224.4K O o 0.8 NYSE 0.8 8 Most Positive Pos Neg Ratio Avg. Word.Count False 112.2K 0.4 Pos Neg Ratio True 0.4 Clusters 0.0 OK Cluster 1 CC Cluster 2 VISA INC Cluster 3 BOEING CO PFIZER INC 0.0 PEPSICO INC COCA COLA CO SOUTHERN CO ALLERGAN INC CITIGROUP INC COCA COLA CO RAYTHEON CO JPMORGAN CH.. CATERPILLAR I. FORD MOTOR CO Cluster 4 ALLSTATE CORP OCCIDENTAL PE. LOCKHEED MAR. MCDONALDS C. Duke Energy Ca.. CATERPILLAR I.. AMERICAN EXP.. MILESTONE SCI.. EMERSON ELEC. WALT DISNEY CO ABBOTT LABOR. SCHLUMBERGE.. CVS HEALTH CO.. AMERICAN INT. COLGATE PALM.. LOCKHEED MAR. PROCTER GAM.. BRISTOL MYER.. NEXTERA ENER. SCHLUMBERGE.. Philip Morris In. MCDONALDS C. Duke Energy Ca. OK 112.2K 224.4K Cluster 5 Avg. Word.Count Cluster 6