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

Use Excel to conduct a regression analysis of the values of the security against the predictor

Show your steps to calculate R and R^2. Explain the results.

Conduct ANOVA in excel

Conduct both t-test and F-test on null hypothesis b1=0

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

Evaluation of the Project: The project will be evaluated based on the following rubrics:

Present data and cite data resources clearly.

Conduct regression analysis and calculate R and R^2 correctly.

Conduct ANOVA analysis and hypothesis tests correctly.

Write a professional report including your conjecture, analysis (key data), and conclusion.