Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started