Business & Finance homework help

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.

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:

https://video.emporia.edu/media/0_70zm3clxLinks to an external site.