Describe the movements of two data series GFCF and GDP

Assignment Help Applied Statistics

Reference no: EM132310805

Business Statistics Written Assignment - Computer Application Project -

Computer Applications Assignment Problem -

Assume that you are a research analyst in a business firm. Your team leader has given you a research task to investigate whether the Private Gross Fixed Capital Formation (on Machinery and Equipment) in Australia is a good predictor of the Gross Domestic Production of the country.

Using the link given below, download the data on the following two variables from the Australian Bureau of Statistics (ABS) website and answer the questions 1-6.

Q1. Download data (in excel format) for PRIVATE GROSS FIXED CAPITAL FORMATION - MACHINERY AND EQUIPMENT (GFCF) and GROSS DOMESTIC PRODUCT (GDP) for the period March 1986 to December 2018 from the above website to carry out Tasks 2-6. Display a screenshot of first 10 rows of the dataset.

Q2. Using appropriate graphical descriptive techniques (in Excel):

(a) Describe the movements of two data series GFCF and GDP.

(b) Analyse the relationship between the two variables, GFCF and GDP.

Q3. Using appropriate numerical descriptive methods (in Excel):

(a) Summarize the above two data series, GFCF and GDP.

(b) Comment on the strength and the direction of the relationship between GFCF and GDP.

Q4. Using the Simple Linear Regression technique,

(a) Develop a model to explain the relationship between GFCF and GDP. Explain the reason for your choice of the dependent and independent variables of your model.

(b) Estimate the model you proposed in 4(a) using Excel.

Q5. Applying appropriate statistical techniques,

(a) Test whether the linear relationship between Gross Fixed Capital Formation - Machinery and Equipment and Gross Domestic Product you estimated in Q4 is significant (use α = 0.05). (Hint: display 6 steps process in relation to this test).

(b) Assess the fitness of the estimated model you have estimated in Q4.

Q6. Based on all your answers above, write a summary report about your findings to hand over to your team leader (maximum 250 words).

Attachment:- Assignment Files.rar

Reference no: EM132310805

Questions Cloud

Variation from the national economic situation : Are there any unique characteristics of Georgia's state economy that would explain its variation from the national economic situation?

Define scope and produce a scope management plan : Closure and Evaluation-Researching for the closure checklist and project evaluation - Write an Annotated Bibliography for three (3) relevant texts or readings

Contribution before the price and cost changes : Their current volume is 1,000 units. Fixed costs are $1,400. What is unit (per shoe) contribution BEFORE the price and cost changes?

Business and the triple bottom line approach : The Triple Pundit website is a very informative media hub when it comes to business and the triple bottom line approach

Describe the movements of two data series GFCF and GDP : STA510 Business Statistics Written Assignment - Computer Application Project, Charles Darwin University, Australia. Describe the movements of two data series

Price and output where demand is inelastic : A profit-maximising monopolist will set its price and output where demand is inelastic. Is this statement true or false?

What is julee profit-maximising quantity : A) Does Julee have any market power? How can you tell? B) What is Julee's profit-maximising quantity?

Distinguish between different employee roles or positions : Employers should have the ability to ban visible body art in the workplace, however, I also believe that it should depend on the job.

Measures including sectors of the economy : How do you explain and synthesize the potential impacts on the US economy tied to these austerity measures including sectors of the economy that would be affect

Reviews

len2310805

5/23/2019 4:07:29 AM

Instructions: You will need to download Assignment Question file (this file) and data file to complete your assignment. All numerical calculations and graphs/plots should be done using EXCEL as much as possible. Only typed assessments in a Word document will be marked. Hand-written equations and symbols are accepted if scanned and pasted into the word document. You have to copy and paste Excel outputs (eg, plots, tables etc) into your main assignment, which is a Word document. Any answer in the Excel document, but not in the main document, will NOT be marked.

len2310805

5/23/2019 4:07:23 AM

The completed assignment (word document) must be submitted electronically via “Written Assignment Submission Point: Word Document ONLY” under Written Assignment folder. The Excel output file consisting of data, any calculations and estimation you perform must be submitted electronically via “Excel Workbook Submission Point” under Written Assignment folder. Word files that are not accompanied by Excel files will NOT be marked. You are required to keep a hard copy of the submitted assignment to re-submit, in case the original submission is lost for some reason.

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