User Account

All Pages

Create the linear regression

Assignment Help Business Management
Reference no: EM133184269

Follow the instructions provided on using Excel to a regression equation. Find the historical data of a company of your choice from yahoo or any financial website of your choice and complete the following:

Pull the historical data for your favorite company at Yahoo or any website for the period Nov 2020 to Oct 2021, monthly closing stock prices.

1. Find the slope (a) and intercept (b)

2. Create the linear regression (equation)

3. Predict the stock price at close of June 2022.

Submit your assignment on Excel with the historical data in the following columns and be sure to include the name of the company whose stock price you are predicting, and the website link where you retrieved the historical data. Be sure item 1 to 3 are clearly outlined and included on your submission.

Column 1 = Date | Column 2 = Open $ | Column 3 = Low $ | Column 4 = Close $(y) | Column 5 = Month(x)

Instructions on how to pull historical data from Yahoo Finance (https://finance.yahoo.com/) and compute future price based on trending using regression analysis.

Read chapter 13.6 and 13.7 for more on using Regression Analysis to make predictions and using excel to.

Steps:

1. Go to Yahoo Finance on the web

2. Enter a company name or stock symbol into the "Quote lookup" field

3. Tap a quote in the search results to view it

4. Slide the menu to the left and tap Historical Data

5. Select a Time Period, data to show, and frequency

6. Tap Apply

7. You can download the data to Excel and do the regression analysis using the linear equation

8. Find the Slope (Explain its meaning and significance)

9. Find the y-intercept ((Explain its meaning and significance)

10. Using the linear regression equation y=m + bx (remember a = m = slope)

11. Substitute a period for 'X' into the equation to predict the price.

The assignment has 5 parts, namely

1. Creating the table

2. Finding the slope (Explain its meaning and significance)

3. Finding the Y-intercept (Explain its meaning and significance)

4. Writing the equation

5. Forecasting the price of the stock for a given period

Reference no: EM133184269

Questions Cloud

Case of planned parenthood and the susan g koman : Is the case of Planned Parenthood and the Susan G. Koman Foundation primarily related to the concepts of marketing, communications, or public relations? Explain
Potential problems that could be causing the issue : You are troubleshooting a wireless token ring network and use the network's beaconing feature to try to repair the problem.
Achieve a values-driven culture of integrity : Theresa and Mike want a merged company that is defined by a culture of integrity, thus aiding employees in making ethical decisions, such as in Joe's ethical di
Conduct a swot analysis of the endeavor : The executive team of a Multinational Corporation (MNC) is interested in expanding into a host country. You have been hired to conduct a SWOT analysis to see if
Create the linear regression : Pull the historical data for your favorite company at Yahoo or any website for the period Nov 2020 to Oct 2021, monthly closing stock prices.
Primary functions of communication process in organization : What are the primary functions of the communication process in organizations?
Investment option calculate the irr : Imagine you are working as an investment analyst for ABC Company, you are given 100,000$ to allocate for 5 different investment opportunities. You may select an
What is the weingarten rule : What is the Weingarten rule? What are the "rules" employers and union organizers must follow during an organizational campaign?
What are the implications of media bias in sport : What are the implications of media bias in sport? What topics should be off limits?

Reviews

Write a Review

Business Management Questions & Answers

  Description of company chosen entry mode

First, find a U.S. company that has successfully entered a foreign market with a product or service. Select one U.S. company and one country it entered.

  Representative of bajaj internationalization process

Which theory is the most representative of Bajaj's internationalization process? Discuss in relation to the organization.

  Successful marketing plan for any new business product

A successful marketing plan for any new business product in the market comprises the strategies plan for bringing the product to the market and its promotional activities to pull the customer attraction of the customer towards the new product

  Relate to cultural differences

This week we are discussing Global Interaction. Can you share your own thoughts on the below questions?Thank you!

  Describe the current market trends for the new industry

If we are in the automotive manufacturing industry but wish to diversify. Do you think is a good idea? Need more info about the new industry before diversifying

  A conflict of responsibilities

Provide a brief summary listing the key facts in the case.

  Produce high quality printers without making losses

a) Will any of the four firms be able to produce high quality printers without making losses?

  Databases that would be useful for small businesses

Suggest at least two types of databases that would be useful for small businesses, two types for regional level organizations and two types

  Contribution of organisational culture

1. To what extent is employee empowerment an effective organisational practice?

  Professional management practice

How does societal and organizational structures affect individual managers ability to move toward a more professional management practice?

  Celebrating and promoting innovation

Discuss how you can promote and support appropriate ways of celebrating and promoting innovation. (50-100 Words)

  Specific strategy and long term objective for apple

Need help with recommending a specific strategy and long term objective for apple. Specify how recommendations can be implemented

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd