Which note-taking habit best supports critical reading?
Questions
Which nоte-tаking hаbit best suppоrts criticаl reading?
Cоmpаring Prices tо Anаlyst Prices а. Dоwnload this Excel file containing data on share prices and median analyst estimated prices from December 2023. b. In the Excel file, calculate the percentage difference between the analyst forecasted price and the price, i.e., percentage difference = analyst price / price - 1. Format the values as percentages with two decimal places. In the Excel file, calculate the absolute percentage difference between the analyst forecasted price and the price, i.e., absolute percentage difference = ABS(analyst price / price - 1). Format the values as percentages with two decimal places. c. In Power BI, create a scatterplot that displays price on the x-axis and analyst price on the y-axis. Weight each point using the absolute percentage difference between the two prices calculated in part a. Set the minimum and maximum of both the x- and y-axes at $0 and $200, respectively. Use Power BI's symmetry shading feature to highlight firms above and below the y = x line. Shade the area above the line green and below the line red. Are the firms that fall in the area above the y = x line considered undervalued or overvalued by analysts? {#1} d. Add a slicer to the visualization based on Company. Use the slicer to answer the following questions. Round answers to two decimal places. What is Biogen Inc's price? ${#2} What is the median analyst forecasted price for Biogen Inc? ${#3} e. Add a multi-row card visualization and add Company as a field in the card. Add a slicer to the visualization based on the percent difference between the analyst forecasted price and the price. Use the slicer to answer the following questions. Note: When using the slicer, it can be challenging to move the slider to zero or other exact values. To set the value to exact values instead use the boxes above the slider to enter specific values. How many firms have an analyst forecasted price that is greater than or equal to the price? {#4} How many firms have an analyst forecasted price that is less than the price? {#5}