STAT6003 : Statistics for Financial Decisions - Statistical Analysis - Macquarie - Statistics Assignment Help

Subject Code: AFIN353

Statistics for Financial Decisions - Statistics Assignment Help

Assignment Task: AFIN353 The 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 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. Question (2) Plot the dependent variable against each independent variable using scatter plot/dot function in Excel. Describe the relationship from the plots. Question (3) Present the full model in your assignment. Question (4) Write down the least squares regression equation and correctly interpret the equation. Question (5) Interpret the estimated coefficients of the regression model and discuss their sig values. Question (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. Question (7) State the 95% confidence intervals for each parameters and interpret these intervals. Question (8) Estimate the linear regression model to investigate the relationship between the market price and the land size in total number of square meters. Question (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). Question (10) Predict the market price of a house (in $) with a building area of 400 square meters

This Statistics Assignment Answer has been solved by our Statistics experts at onlineassignmentbank. 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.