Intro to Regression Assignment

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.

Don't use plagiarized sources. Get Your Custom Essay on
Intro to Regression Assignment
Get a plagiarism free paper Just from $13/Page
Order Essay

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.

Master Homework
Order Now And Get A 20% Discount!
Pages (550 words)
Approximate price: -

Advantages of using our writing services

Custom Writing From Scratch

All our custom papers are written by qualified writers according to your instructions, thus evading any case of plagiarism. Our team consists of native writers from the USA, Canada, and the Uk, making it convenient for us to find the best to handle your order.

Unlimited Free Revisions

If you feel your paper didn't meet all your requirements, we won't stop till it's perfect. You're entitled to request a free revision within 7 days after we submit your paper.

Quality Writing In Any Format

If you have issues with citing sources and referencing, you need not worry. Our writers are highly knowledgeable in referencing, including APA/MLA/Havard/Chicago/Turabian and all other formatting styles.

Fast Delivery And Adherence To The Deadline

All our custom papers are delivered on time, even the most urgent. If we need more time to perfect your paper, we may contact you via email or phone regarding the deadline extension.

Originality & Security

At Master Homework, your security and privacy is our greatest concern. For this reason, we never share your personal information with third parties. We use several writing tools to ensure your paper is original and free from plagiarism.

24/7 Customer Support

Our agents are online 24 hours a day, 7 days a week, and are always ready to serve you. Feel free to contact us through email or talk to our live agents whenever you need assistance with your order.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

We work nonstop to see the best client experience.

Pricing

Flexible Pricing

We offer pocket-friendly prices that coincide with the preferred client's deadline.

Communication

Admission help & Client-Writer Contact

Our support team is always ready to ensure vital interaction between you and the writer whenever you need to elaborate on something.

Deadlines

Paper Submission

We deliver our papers early within the stipulated deadlines. We are glad to help you if there should be an occurrence of any alterations required.

Reviews

Customer Feedback

Your review, positive or negative, is of great concern to us and we take it very seriously. We are, consequently adjusting our policies to ensure the best customer/writer experience.