Publicly Traded Security - Accounting & Finance Assignment Help

Assignment Task

• Choose a publicly traded security for which you can find a series of historical values

• Make a conjecture about related data (at least two data series) that might be used as predictors for this series of values

• Find online data sources to get current data for both the predictors and the values of the security (up to 12/31/20 or more recent, if possible)

• Download this data and copy it into Excel

• Create graphs of the data

• Use Excel to conduct a regression of the values of the security against the predictors and verify the validity of underlying assumptions — Eliminate outliers if necessary — Check for homoscedasticity and serial correlation

• Look for evidence of multicollinearity and eliminate redundant predictors if necessary, Submit written report & Excel spreadsheet

— Report can be .doc or .pdf

— Document regression inputs with text comments

— Submit to D2L folder

• Report should:

— Clearly state the conjecture being investigated

— Clearly describe the data sources used & data handling

• Include links to data if possible

— Clearly describe the analysis performed

— Clearly state the conclusions you have drawn from this analysis

This Accounting & Finance Assignment has been solved by our Accounting & Finance experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.