18 Jun WHICH MODEL REFLECTED ON THIS CHART PROVIDES A SUPERIOR FIT TO THE SAMPLE DATA?
No Comments
Submission: You are required to submit BOTH hardcopy and softcopy of your work. Hardcopy (printed copy) of your work can be submitted through the Assignment Drop Box on Level 3, Department of Accounting, Building H, Caulfield campus. A redundant, softcopy submission should be made through Moodle. If the (default) hardcopy submission does not exist, then the softcopy submission will be marked. The receipt of the softcopy is absolutely necessary for your assignment to be marked. So, please ensure you submit the correct version of your work – both in hardcopy and softcopy; and that the hardcopy is not submitted late (passing deadline). It is imperative for students to do both submissions (hardcopy and softcopy) to avoid missing submission. By having a redundant system, we are preventing possible dispute with regards to lost submission. Students who only rely on one mode of submission are taking the risk of their assignment being lost in the system. Finally, please ensure that the softcopy of your submission (both Excel file(s) and Word (or PDF) file) is not password protected.
For the softcopy submission, zip all your files (including the excel file and the cover sheet) and submit it via Moodle. You must use WinZip to compress your files (please do not use any alternative software to compress your files). Attach the signed cover sheet with your hardcopy submission. This signed cover sheet is a declaration that your submission is your own work. Any attempt of plagiarism will be heavily penalized. If deemed necessary, Lecturer/Tutor/Marker may opt ACF5320 Business Analytics, Individual Assignment Prepared by Dr. Kristian Rotaru, September 2016 2
to interview students on their submissions and this may be reflected on student’s mark.
Naming File: The zip file should be named X_Y_A2.zip
where
X is up to 5 characters is your SURNAME.
Y is up to 3 characters is your FIRSTNAME.
Part B. Problem Description
Instruction:
This assignment consists of three cases (Case 1: Planning the Sales Territory, Case 2: Audit Delay, and Case 3: Corporate Bonds) and three sets of tasks. It is important that you read and understand the topics and have acquired skills to successfully develop spreadsheet models before carrying out the assignment. Please note that these cases are not optional. You need to attempt three cases in this assignment and all associated questions/tasks.
Case 3: Corporate Bonds
Problem Statement
A sample containing years to maturity and yield (percent) for 40 corporate bonds is presented in the data file named Corporate_bonds.xlsx. The data file can be located in the Assignment 2 folder on Moodle.
Task group 3 (6.5 marks)
(3.1) Develop a scatter chart of the data using years to maturity as the independent variable. Does a simple linear regression model appear to be appropriate? Explain your answer.
(3.2) Develop an estimated quadratic regression equation with years to maturity and squared values of years to maturity as the independent variables. How much variation in the sample values of yield does this regression model explain? Is the overall regression relationship significant at a 0.05 level of significance? If not, explain why it is the case. If yes, then test the relationship between each of the independent variables and the dependent variable at a 0.05 level of significance. How would you interpret this model?
(3.3) Create a plot of the linear quadratic regression lines overlaid on the scatter chart of years to maturity and yield. Does this help you better understand the difference in how the quadratic regression model and a simple linear regression model fit the sample data? Which model reflected on this chart provides a superior fit to the sample data? Why?
(3.4) What other independent variables could you include in your regression model to explain more variation in the yiel
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.