Collect data from finance.yahoo.com and FRED database and use Microsoft Excel to run a multivariate regression model for a publicly traded company using economic variables. Round results to two decimal places when possible. If not, explain.
Use 30 observations for each variable. Same format for all variables.
Compute, analyze, and explain the following results from data.
Null hypothesis Alternative hypothesis
Multicollinearity test for all independent variables
Data must be formatted
Use 3 references to support regression. Include works cited page for references. Include four parts
1.Choose between 3 to 5 valuation measures from finance.yahoo.com
2.Present the null and alternative hypothesis and explain the significance.
3.Introduce and analyze results with ANOVA table using a 5% significance level. Identify which variables have the best predictive ability. Explain significance of f test, t-statistic, and p-value. Run forecast and determine if the company’s stock is undervalued or overvalued. Explain significance if some of the p-values are below the significance level. Explain significance of whether or not the t-values are too low. 4. Summarize and convey conclusions regarding the topic.
The post collecting data from finance.yahoo.com and FRED database to use in a multivariate regression model for a publicly traded company, and then analyzing the results. appeared first on Scholarly Solutions.