Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


MNGT 379 NE IL University Corporate Bonds Regression Analysis Worksheet

MNGT 379 NE IL University 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.

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Fox Writers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Fox Writers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Fox Writers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Fox Writers, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.