Watch the video “Forecasting a Stock Price” below. Then, using your browser, download the most recent 52-week closing stock price data from (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.
Instructions:
Submit the final Excel spreadsheet file through the portal before the deadline. Your assignment will be checked by VeriCite.
Grading Rubric:
Your assignment will be graded according to the Assignment grading rubric.
Instructional Video:
