• 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 To do – 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
• 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
To do
– 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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps