Question Details

(Solved) Cover sheet for submission of work for assessment School: Economics, Finance and Marketing Program Name Course/unit name Quantitative Methods In...


Hi there,


I have been able to answer questions B and C, if anyone is able to help me with D,E,F,G and H then that would be greatly appreciated.


Thank you

Londoner

Cover sheet for submission of work for
assessment School: Economics, Finance and Marketing
Program Name
Course/unit name
Quantitative Methods
In Finance
Due Date Program Code
Course/unit code ECON1284 29 May 2017 STUDENT/S
Family name Given name Student number DECLARATION AND STATEMENT OF AUTHORSHIP
1.
2.
3.
4.
5.
6. I/we hold a copy of this work which can be produced if the original is lost/damaged.
This work is my/our original work and no part of it has been copied from any other student’s work or from any other source except where
due acknowledgement is made.
No part of this work has been written for me/us by any other person except where such collaboration has been authorized by the
lecturer/teacher concerned.
I/we have not previously submitted this work for this or any other course/unit.
I/we give permission for this work to be reproduced, communicated, compared and archived for the purpose of detecting plagiarism.
I/we give permission for a copy of my/our marked work to be retained by the school for review and comparison, including review by
external examiners. I/we understand that:
7. 8. Plagiarism is the presentation of the work, idea or creation of another person as though it is my/our own. It is a form of cheating and is a
very serious academic offence that may lead to exclusion from the University. Plagiarised material can be drawn from, and presented in,
written, graphic and visual form, including electronic data and oral presentations. Plagiarism occurs when the origin of the material used
is not appropriately cited.
Plagiarism includes the act of assisting or allowing another person to plagiarise or to copy my/our work. Student signature/s
I/we declare that I/we have read and understood the declaration and statement of authorship.
(1) Further information relating to the penalities for plagiarism, which range from a notation on your student file to expulsion from the University, is
contained in Regulation 6.1.1 Student Discipline and the Plagiarism Policy which are available on the Policies and Procedures website at
www.rmit.edu.au/policies. ECON 1284 – QUANTITATIVE METHODS IN FINANCE PROJECT
Due: 29 May at 23:59 Instructions:
The assignment must be provided in the form of a (brief) business report approximately 8-14 pages. You must
submit an electronic copy of your assignment in Blackboard. Hard copies will not be accepted. SHOW YOUR
WORK for calculation based questions.
This assignment requires the use of Microsoft Excel. If you have Windows, you will also need to use the Data
Analysis ToolPak. If you have a Mac with Excel 2011, you will need to use StatPlus:MAC LE.
Problem Description:
RMIT University has contacted us in an effort to better understand the outcome of business students seeking a
Bachelor of Business degree in Australia. In particular, they wish to seek what is a larger driver of student
outcomes, student satisfaction with their program or the prerequisites of students arriving at the university. We
have collected information on the average salary of business graduates from 39 universities across Australia.
You will use descriptive statistics, inferential statistics and your knowledge of multiple linear regression to
complete this task.
Grad salary (Dependent Variable) and several characteristics (Independent Variables) are given in the Excel
file: Monday.xlsx.
Here is a table describing the variables in the data set:
Variable
Salary
Satisfaction
ATAR
G8
ATN
VIC
QLD
SA
NSW
WA
OTHER Definition
Average salary of graduates with a Bachelor of Business degree
Share of graduates who are satisfied with the quality of the program
The stated ATAR requirement for a business degree at the university
Dummy variable indicating the university is part of the Group of 8
Universities
Dummy variable indicating the university is part of the Australian
Technology Network of Universities
Dummy variable indicating university located in Victoria
Dummy variable indicating university located in Queensland
Dummy variable indicating university located in South Australia
Dummy variable indicating university located in New South Wales
Dummy variable indicating university located in Western Australia
Dummy variable indicating university located in Northern Territory,
Australian Capital Territory or Tasmania Required:
A. Calculate the descriptive statistics from the data and display in a table. Be sure to comment on the
central tendency, variability and shape for Salary, Satisfaction and ATAR. How would you interpret
the mean of dummy variables such as G8 or the state variables? (1 Mark)
B. Draw a graph that displays the distribution of Satisfaction rates across universities. Be sure to comment
on the distribution. (1 Mark)
C. Create a box-and-whisker plot for the distribution of ATAR requirements and describe the shape. Is
there evidence of outliers in the data? (1 Mark)
D. What is the likelihood that the average university student earned more than $46,000 if the minimum
ATAR entrance score exceeded 65? Is the salary statistically independent of the ATAR entrance score?
Use a Contingency Table. (2 Marks)
E. Estimate the 95% confidence interval for the population mean salary of business students. (1 Mark)
F. Your supervisor recently stated that historically, universities set a minimum ATAR entrance score of 70
for their business programs. Yet she believes that the minimum score is falling. Test her claim at the 1%
level of significance. (1 Mark)
G. Run a multiple linear regression using the data and show the output from Excel. Exclude the dummy
variable “OTHER” from the regression results. (1 Mark)
H. Is the coefficient estimate for the ATAR requirement statistically different than zero at the 5% level of
significance? Set-up the correct hypothesis test using the results found in the table in Part (G) using
both the critical value and p-value approach. Interpret the coefficient estimate of the slope. (2 Marks)
I. Interpret the remaining slope coefficient estimates. Discuss whether the signs are what you are expecting
and explain your reasoning. (2 Marks)
J. Interpret the value of the Adjusted R 2. Is there a large difference between the R 2 and the Adjusted R2? If
so, what may explain the reasoning for this? (1/2 Mark)
K. Is the overall model statistically significant at the 5% level of significance? Use the p-value approach.
(1/2 Mark)
L. Based on the results of the regressions, what other factors would have influenced graduate salary?
Provide a couple possible examples and indicate their predicted relationship with graduate salary if they
were included. (1 Mark)
M. Predict the average graduate salary of a student enrolled in a ATN in Victoria that has an ATAR
requirement of 80 and a student satisfaction of 75 if it is appropriate to do so. Show the predicted
regression equation. (1 Mark)
N. Do the results suggest that the data satisfy the assumptions of a linear regression: Linearity, Normality of
the Errors, and Homoscedasticity of Errors? Show using scatter diagrams, normal probability plots
and/or histograms and Explain. (2 Marks)
O. Given that student enrolment varies across universities, does this data indicate the true population
distribution of graduate salaries of business students? Explain and if not, describe a sampling procedure
that could lead to more accurate results. (1 Mark) Allocation of Marks:
Professional Business Report
Part A
Part B
Part C
Part D
Part E
Part F
Part G
Part H
Part I
Part J
Part K
Part L
Part M
Part N
Part O
Total: 2 Marks
1 Mark
1 Mark
1 Mark
2 Marks
1 Mark
1 Mark
1 Mark
2 Marks
2 Marks
1/2 Mark
1/2 Mark
1 Mark
1 Mark
2 Marks
1 Mark
20 Marks

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200232559.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now