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
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
X is up to 5 characters is your SURNAME.
Y is up to 3 characters is your FIRSTNAME.
Part B. Problem Description
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
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 yield? Explain your answer.