Subject Code : STAT6003
Assessment Task:
STAT6003 - Statistics for Financial Decisions Assessment Answer

Learning Outcomes

a) Examine the statistical techniques for the quantitative evaluation of data in decision making for accounting, finance and business applications.

b) Identify and apply appropriate statistical techniques to the problems and challenges.

c) Students will develop analytical and statistical skills through Excel data analysis to manipulate data into meaningful information for the purpose of decision making.

 

Assignment tasks:

The variables for this assignment are as follows: House Price Index (a)(b): Brisbane, Sydney and Melbourne, 2002–03 to 2016–17.

V1) Market Price ($000)
V2) Sydney price Index
V3) Annual % change
V4) Total number of square meters
V5) Age of house (years)

1) Module 5 topic – Regression Analysis

You will specify a regression model for this assignment. This model can be based on a theory, several theories, your experience, and/or ideas from research article(s). Suggest you consider a regression model that is of interest to you or one that is related to your profession or one that you have knowledge about

(a) Using Ordinary Least Square (OLS), estimate the model (below is a template for developing your regression model):

Y = β0 + β1 X1 + β2 X2 + β3 X3 + β4 X4 + ε.

In your model, there must be one dependent variable and four independent variables

(b) For statistical analysis involving any hypothesis test in this assignment, you are required to:

• Formulate the null and alternative hypotheses.

• State your statistical decision using significant value (????????) of 5% for each test.

• State your conclusion in context.

 

Assignment tasks:

(1) Provide an introduction section on the rationale of your model , sample size, and the dependent and independent variables (including their unit of measurement) in this model.

(2) Plot the dependent variable against each independent variable using scatter plot/dot function in Excel. Describe the relationship from the plots.

(3) Present the full model in your assignment.

(4) Write down the least squares regression equation and correctly interpret the equation.

(5) Interpret the estimated coefficients of the regression model and discuss their sig values.

(6) What is the value of the coefficient of determination for the relationship between the dependent and independent variables. Interpret this value accurately and in a meaningful way.

(7) State the 95% confidence intervals for each parameters and interpret these intervals

(8) Estimate the linear regression model to investigate the relationship between the market price and the land size in total number of square meters.

(9) Compare the original model (question 1) and re-estimated model (question 2) and evaluate the goodness of fit between them (Hint: Use R2 and Coefficient of determination to evaluate the goodness of fit of the model).

(10) Predict the market price of a house (in $) with a building area of 400 square meters.

 

This STAT6003: Statistics Assessment has been solved by our Statistics Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Mitchell Lee
  • Posted on : December 18th, 2018

Whatsapp Tap to ChatGet instant assistance