Question

Do a regression analysis using R software OR Excel. You may use legitimate sources of data...

Do a regression analysis using R software OR Excel. You may use legitimate sources of data such as Yahoo finance, nasdaq.com, bloomberg.com, US Dept of Labor etc. The data you analyze should be business related or economics related. Attempt to explain why you received the results of your analysis. What do you believe caused these results? Is there anything you found in the news or online which would explain these results?

Homework Answers

Answer #1

I did the regression analysis on the GDP of India data and the sales of the stock price of the Hero Automobiles. After getting the result I found that the stock price of Hero increases with the increase in GDP.

The regression equation line found was.

Stock Price = 2507 + 24*GDP.

The R2 was found to be 80%, means 80% variation of stock price was explained by the regression equation.

The result is caused by the strong co-relation between demand of automobiles with increase in income which is shown by an increased GDP.

In news these days due to increased projected GDP, sales of automobiles are also increasing and so is the stock price.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put...
Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put below (Note: First enter the data in the next page in an Excel spreadsheet) Home Sale Price: The table below provides the Excel output of a regression analysis of the relationship between Home sale price(Y) measured in thousand dollars and Square feet area (x):    SUMMARY OUTPUT Dependent: Home Price ($1000) SUMMARY OUTPUT Dependent: Home Price ($1000) Regression Statistics Multiple R 0.691 R Square 0.478...
Use the graphing feature and the linear regression tool from the Data Analysis ToolPak in Excel...
Use the graphing feature and the linear regression tool from the Data Analysis ToolPak in Excel to analyze the data found in Alligator mass/length data. After graphing the data, add a trendline and be sure to include R2 and the equation of the line. Length (ft) Weight (lbs) 8.2 280 11.5 314 10.1 296 9.6 408 9.1 267 12.3 467 14.3 580 10.4 318 8.7 351 13.7 560 16.1 582 14.3 572 8.3 235 7.6 208 9.4 347 13.6 543...
1.   Regression analysis is to be conducted with data from vegetarians to see whether the number...
1.   Regression analysis is to be conducted with data from vegetarians to see whether the number of grams of protein each ate per day was related to diastolic blood pressure.   The resulting regression formula will be used by medical personnel to predict blood pressure in a weight loss clinic in downtown Pittsburgh. Subject Grams of protein Diastolic BP 1 4 73 2 6.5 79 3 5 83 4 5.5 82 5 8 84 6 10 92 7 9 88 8...
Part C: Regression and Correlation Analysis Use the dependent variable (labeled Y) and the independent variables...
Part C: Regression and Correlation Analysis Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected...
Ans via excel using data analysis toolpak explaining which function you used and why 13a. Do...
Ans via excel using data analysis toolpak explaining which function you used and why 13a. Do goals by appearance (G/A) and Age predict players' Trading Value? Please run the appropriate test and report your findings. 13b. If we have a new player to this dataset with a G/A ratio of .75 who is 26 years old, how much do we predict her/his Trading Value to be? Percentage playing time by year Player # Year Trading Value (Millions of $) Y-5...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable. Determine the coefficient of...
Introduction Purpose Your goal is to create a design for a software interface. You will experience...
Introduction Purpose Your goal is to create a design for a software interface. You will experience the scope of the design process from brainstorming ideas and gathering information about users’ needs to storyboarding, prototyping, and finally, testing and refining your product. As you work on the software interface, you will demonstrate your ability to apply fundamental Human-Computer Interaction principles to interface analysis, design, and implementation. You will be responsible for delivering project components to your professor at several points during...
Analysis: This section should include the issue register as a bare minimum, but may include also...
Analysis: This section should include the issue register as a bare minimum, but may include also why-why diagrams, a Pareto chart, a waste table and/or value-added analysis table. Flow analysis or simulation of this case study might be possible but might require making a lot of assumptions given the provided data. The first part of the project: Introduction    Walmart has continued to retain the top position on the Fortune 500 list for a consecutive fifth year. The brand has...
Bivariate Data & Probability After completing the calculation by hand in Q1 you can use Excel...
Bivariate Data & Probability After completing the calculation by hand in Q1 you can use Excel to check your answers before submitting. Q2 assesses your general understanding of probability and linear associations using Excel to analyse a large dataset. Question 1       Covariance and Correlation The table below shows a set of sample bivariate data. Calculate the covariance and correlation coefficient by completing the below table. Show all working. X Y (X - ) (Y - ) (X - )(Y -...
As you saw from the lab PowerPoint slides last week, you will be doing a research...
As you saw from the lab PowerPoint slides last week, you will be doing a research study looking at ‘Aggression Priming” for your first paper. For this week’s discussion, I want you to discuss with your group what you think this study is about. What is the hypothesis? What theory does it come from? What do you predict will happen (do you expect something different than the hypothesis in the researcher instructions? If so, what and why?)? Do you think...