Determine the least square line

Reference no: EM131494023 , Length: word count:2000

Assignment

This assignment consist of case study/report writing and short questions/calculations

Q1: Case study/report writing

In recent years Australian export and import prices have shown dramatic trends as shown by export and import price indices. Export and import price indices measure the overall change in the prices of goods and services exported or imported respectively. The prices of all goods and services do not change at the same rate. A price index thus summarizes their movements by averaging over them. A price index assumes a value of unity, or 100, in some reference period. Table 1 presents quarterly export and import price indices for 2000 to 2015 (see, the attached file entitled Assignment 2 ABS-Data.xlsx). Your task is to write a report (about 1500 words):
(a) Convert (using Excel or manually) quarterly export and import price indices data into yearly (Hint: first add quarterly data for each year and then divide it by four because there are four quarters in a year);
(b) Discuss which is the most appropriate graph to present this statistics and then present it in a graph(s);
(c) Discuss emerging trends in Australian export and import prices in the last few years;
(d) Explain why this trend may have occurred in recent years (Hints: for this part you need to look at Australian trade data from the Australian Bureau of Statistics (ABS) site (www.abs.gov.au) or do some research on the net as to what kind of goods and services Australia exports and imports and what has happened to their exports and imports in recent times).
(e) What would be the implications of this trend for Australian business? Discuss.

Note: For this question you are required to present your answer in a report form. Your written report should have a cover page with your name, student number and an abstract of your answers (4-5 lines). In the next pages, you should have an introduction (5-10 lines), main body of the report (where you discuss/answer all five questions analytically- about 2 pages) and then a conclusion of your report (10-15 lines). Finally, you should have a reference section if you have taken material or idea from any published or unpublished sources.

Q2: Short questions

Rising price level, as measured by the rate of inflation, reduces people purchasing power. For this reason, investors tend to invest in high return shares. Table 2 provides a dataset from 1995- 2015 for both All-Ordinary Index (Y) and inflation (X). See the attached file containing data on All-Ordinary Index and inflation.
Based on this dataset answer the following questions:

(a) Calculate covariance between X and Y, and the coefficient of correlations
(b) What does these statistics tell you about the relationship between All-Ordinary Index and inflation?
(c) Determine the least square line.
(d) Determine the coefficient of determination R2

Attachment:- Data.rar

Reference no: EM131494023

Questions Cloud

What steps can the generalist practitioner adopt : What steps can the generalist practitioner adopt to embrace cultural relativity in American society

What impact does society have on our view of addicts : What impact does society have on our view of addicts? What would be a christian response be in light of the biopsychosocial model

Write about family policy topic - homelessness : Choose one of the Family Policy Topics (below) and present a debate, where YOU take both sides. Family Policy Topics - elderly care and homelessness

Explain interpersonal communication : How would humanistic theories explain interpersonal communication versus existential theories

Determine the least square line : Discuss which is the most appropriate graph to present this statistics and then present it in a graph(s); Determine the coefficient of determination R2

Description and explanation of the type of business entity : Description and explanation of the type of business entity that is best for your business - Description of possible ethical considerations for your business

What challenges does law enforcement face : What challenges does law enforcement face in controlling Child Pornography? How can law enforcement deal with this problem?

Create a spread sheet so you can write all scores into it : Create a spread sheet so you can write all scores into it. Points will be taken off if you do not follow the instructions.

Research the protection of children from sexual predators : Research the Protection of Children from Sexual Predators Act of 1998. I work for an ISP in the United States, and discovered child pornography on a Web site we host

Reviews

len1494023

5/12/2017 9:09:14 AM

Q2: Short Questions Relevant learning objectives High Distinction(85%+) Academic writing and presentation skills Highly developed skills in expression and presentation of ideas. Fluent writing style. No major grammatical and spelling errors. Identification of appropriate statistical tools and their application Excellent use of knowledge gained and awareness of deeper and more subtle aspects of the statistical tools. Quality of arguments, analytical and forecasting/evaluations skills Provides well-argued and articulated statements with supporting evidence. Evidence of originality and independent thought. Has highly developed analytical skills & consistently demonstrates high levels of critical analysis. Demonstrates ability to reflect on conclusions and their implications.

len1494023

5/12/2017 9:09:06 AM

Q1: Case Study/ Report writing Relevant learning objectives High Distinction(85%+) Academic writing and presentation skills Highly developed skills in expression and presentation of ideas. Fluent writing style. No major grammatical and spelling errors. All references, including recent literature, cited and used accurately. Content & Knowledge of statistical tools and its application to business Excellent use of knowledge gained and awareness of deeper and more subtle aspects of the statistical tools. There is clear evidence of researched/read more widely beyond the core materials. Quality of arguments, analytical and forecasting/evaluation skills Provides well-argued and articulated statements with supporting evidence. Evidence of originality and independent thought. Has highly developed analytical skills & consistently demonstrates high levels of critical analysis. Demonstrates ability to reflect on conclusions and their implications.

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages