Fill in Order Details

  • Submit paper details for free using our simple order form

Make Payment Securely

  • Add funds to your account. There are no upfront payments. The writer will only be paid once you have approved your paper

Writing Process

  • The best qualified expert writer is assigned to work on your order
  • Your paper is written to standard and delivered as per your instructions

Download your paper

  • Download the completed paper from your online account or your email
  • You can request a plagiarism and quality report along with your paper

Corporate Bonds Regression Analysis Worksheet

Please note that, outside of running the Regression tool, all work should be completed inside of the yellow-filled cells. Including ANY work outside of the yellow-shaded cells will result in an automatic ZERO for that step. Similarly, you should NEVER hard-code the values into a cell and/or formula. In other words, you MUST use only cell references and formulas to complete all instructions and calculate your results; directly entering values into cells or formulas will result in ZERO credit for the step.

Step 1: Download the attached file “Module 5 CorporateBonds Template.xlsx” and open the file in Microsoft Excel.

Step 2: Use the Data Analysis package to run a Regression where you use Years to predict Yield.

Step 3: Use relative cell references to display the coefficients for Years and Yield from the Regression Report in cells D44:D45 on the Data worksheet.

Step 4: Use the Regression Coefficients you entered in Step 3 to predict the Yieldvalues for each company, based on the Years for that row. Enter the results in range D2:D41. Remember, hard-coding is NOT permitted and will result in zero credit.

Step 5: Calculate the Residuals (aka Regression Errors) for each predicted value from Step 4, and enter the results in range E2:E25.

Step 6: Use the Residuals calculated in Step 5 to compute the Sum of Squares due to Error (SSE) in Cell F42, using Cells F2:41 for the intermediate computation of the Squared Residuals.

Step 7: Follow a similar process from Steps 5 and 6 to compute the Sum of Squares due to Regression (SSR) in Cell H42. To do so, you will need to compute the y-bar in Cell C42, and you should use cells G2:H41 for your other intermediate computations.

Step 8: Now compute the Total Sum of Squares (SST) in Cell J42 by completing the computations in Cells I2:J41.

Step 9: Compare your results for SSE, SSR, and SST to the SS column of the ANOVA table in your Regression Output generated in Step 2. If your computed values do not match the corresponding values from the Regression Output report, review your calculations to identify and correct your mistake.

Step 10: Cell M2 contains a formula that tells Excel to pick a random number each time that formulas are recalculated across the sheet (which by default happens every time that a cell value is changed), so as you are working, you may notice that the value in this cell changes, but don’t pay it any mind. Rather, build a formula in cell M3 that predicts the Yield based on the Random Years in cell G2. Note: this step is similar to the process for computing Regression Coefficients in Step 3.

Once you have completed all the steps, save your work and submit the completed document to this Assignment folder.

Reviews


Anonymous

Excellent job, received an A+ (96) on the paper. Thank you so much.

Anonymous

On time and beyond the work I expected. Communication is fast and amazing, this is the only writing service I will be using.

Consider Your Assignments Done

“All my friends and I are getting help from eliteacademicresearch. It’s every college student’s best kept secret!”

Jermaine Byrant
BSN

“I was apprehensive at first. But I must say it was a great experience and well worth the price. I got an A!”

Nicole Johnson
Finance & Economics

See Why Our Clients Hire Us Again And Again!

OVER
10.3k
Reviews

RATING
4.89/5
Avg Rating

YEARS
12
Experience

Elite Academic Research Promises You:

Always on Time

If we are a minute late, the work is on us – it’s free!

Plagiarism-free

If the work we produce contains plagiarism we’ll pay out a £5,000 guarantee.

Quality

Providing quality work is core to our beliefs, which is why we will strive to give you exactly that, and more!

Written to Standard

All of our assignments go through a stringent quality checking process from start to finish.

Success Guarantee

When you order form the best, some of your greatest problems as a student are solved!

Reliable

Professional

Affordable

Quick

What our customers say
_____

Writer provided excellent layout and research assistance I needed in order to create my own essay.
Great service fast and friendly. Have used the team more than once for assistance with work of a high standard. Communications have been faultless and everything arriving by promised time line. Will definitely use again ! 5 star
error: Content is protected !!