Description
All information is included in the attachment.
Unformatted Attachment Preview
FIN 617 Final Project – Simple Linear Regression
Due Date: November 15, 2023
1. Choose a publicly traded security for which you can find a series of historical values and make a
conjecture about related data that might be used as a predictor for this series of values.
● Find online data sources to get current data for the predictor (x) and the values of the
security (y)
● Download this data and copy it into Excel
● Create graphs of the data
2. Use Excel to conduct a regression analysis of the values of the security against the predictor
● Interpret the regression results: the meaning of regression coefficient 1, significance of
2
●
●
the coefficients, and the meaning of .
Conduct ANOVA in Excel
Conduct both t-test and F-test on null hypothesis 1 = 0
3. Write a report and submit the data and regression analysis in Excel.
● The report should clearly state the conjecture being investigated
● The data source used & data cleaning/manipulating (if any) need to be clearly described
● The report should describe the analysis performed with graphs and results from both
regression analysis and ANOVA
● The report should state the conclusions you have drawn from this analysis
Purchase answer to see full
attachment
