Hi - please help with the following. PNR benchmark is 0.7. Thank you,

Kristie

Lab 8-4 Analyze Financial Sentiment5&P1OO 0 Saved Help Save 8. Exit 4 Pan4of9 10 points eBook Print References 0 This question will be sent to your instructor for grading. Required information Lab Note: The toois presented in this lab periodically change. Updated instructions, ifappiicabie, can be found in the eBook and lab waikthrough 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 financial 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 SP'IOO Sentimentzip - 111KB Zip i 114KB Excel Note: Submit your answers for the following Analysis Questions in the text entry field below. A01. Given the benchmark for PNR, do you expect financial statements to include more positive or negative words overall? Why? A02. Look at the companies with the highest word counts. Do they tend to have a higher or lower PNR? Would you expect companies that with high word counts in their financial statements to include more positive words or more negative words? Sub #Tableau - Lab 8-4 SP100 Sentiment Analysis X ile Data Worksheet Dashboard Story Analysis Map Format Server Window Help 2 . [T Entire View Y Show Me Dashboard Layout Word Count Company.Name Proportion of Positive and Negative Words (All) Default Date.Filed 3M CO Phone Year of.. Lm.Nega.. Lm.Positi.. Pos Neg .. Word.Co.. ABBOT... 2016 76,083 31,435 41.32% 3,432,161 Device Preview 20K -0.425 32,231 AbbVie ... 2017 77,247 41.72% 3,537,628 2018 78,099 33,332 42.68% 3,680,969 ADOBE ... Size OK 2019 73,559 30,937 42.06% 3,806,797 ALLERG... Automatic -20K -0.420 Pos Neg Ratio Year of Date.Filed Value (All ) Sheets -40K 2014 Proportion of P... 2015 Word Count 60K 0.415 2016 Most Positive ... -80K 2017 Companies wit... 2016 2017 2018 2019 2018 PNR by Avg W... Most Positive Companies Companies with the Most to Say PNR by Avg Word Count Exchange ( All ) Company.Name Company.Name NASDAQ 0.8 NYSE Objects 0.8 000 200K 00 Horizontal O Blank 0.6 Most Positive 0.6 O Pos Neg Ratio ? Avg. Word. Count Navigation False Vertical 0.4 100K Pos Neg Ratio True A Text C. Download 0.2 0.4 Clusters Image Extension OK Lee Cluster 1 Web Page Ask Data 0.2 3M CO O Cluster 2 NIKE INC 0.0 Cluster 3 PFIZER INC EXELON Corp HONEYWELL I.. SCHLUMBERG.. JOHNSON JO.. CVS HEALTH C. Motors Liquid. UNITEDHEALT UNION PACIFIC SCHLUMBERG.. AMERICAN EX. NEXTERA ENE.. BRISTOL MYER UNITEDHEALT Floating ALTRIA GROUP Tiled VERIZON COM.. OCCIDENTAL P. US BANCORP WALT DISNEY .. CAPITAL ONE F. GOLDMAN SAC. MCDONALDS C. OK 50K 100K 150K 200K 250K Cluster 4 Cluster 5 Show dashboard title Avg. Word.Count Cluster 6