Forecasting a Stock Price


 Watch the video "Forecasting a Stock Price" below. Then, using your browser, download the most recent 52-week closing stock price data from Yahoo! Finance (Links to an external site.) (in CSV/Excel format) from a company using your name to generate the list of alternatives. Using only the DATE and CLOSE columns of data, construct a 3-week moving average column and a weighted 3-week moving average column. Then create a properly formatted 2-D line chart using those columns of data as shown in the video. Save the file as LASTNAME_FIRSTNAME_M4_A1.xlsx and upload it through this portal. A properly executed assignment is worth 20 points. The deadline for this assignment is before the end of the day (23:59 CST) February 21st. 

    • 7 days ago
    • 20

    Purchase the answer to view it

    • attachment