need to prepared on report formate - Australia DataLife expectancy at birth, total (years)CO2...

Question

need to prepared on report formate - Australia DataLife expectancy at birth, total (years)CO2 emissions (metric tons per capita)GDP growth (annual %)Health expenditure per capita (current US$)199519961997199819992000200120022003200420052

Australia Data Year\Indicator NameLife expectancy at birth, total (years)CO2 emissions (metric tons per capita)Health expenditure per capita (current US$)GDP growth (annual %)Mobile cellular subscriptions (per 100 people) 199577.829268292717.01161719791574.27901562473.939983313612.3741501465 199678.078048780517.98153732731767.72158811644.181423943721.7799075386 199778.480487804918.01715504671766.04944938463.972448021124.7123465053 199878.631707317118.54058404151597.62074507014.585530280926.2505045402 199978.931707317117.19979166231754.98460898645.159854379833.3282421783 200079.234146341517.20903398951728.46199332433.951352155444.6767020704 200179.634146341516.73412301041644.80347953362.071616393257.4341761622 200279.936585365917.37269100421858.49044080073.903791220564.6294992805 200380.239024390217.41490470162339.21905520213.272264035372.3130706871 200480.490243902417.35063038452888.9769621364.155794748481.9744623684 200580.841463414618.01405569073157.75430885062.959140943490.2785401735 200681.041463414618.23286280253330.21289121913.081394098895.2551050783 200781.292682926818.0716233483956.46872365293.5641779734100.6629359827 200881.395121951218.56961908974229.03306558153.8320654888102.8176450511 Using the given data set calculate and interpret HOLMES INSTITUTE FACULTY OF HIGHER EDUCATION HI5007 Statistics Business Research for Decision Making Trimester 2 2012 ASSIGNMENT 2 – DATA ANALYSIS Weght: 30% Word Limit: 2000 words Identifying a management problem and designing an appropriate business research strategy is critical for success in business, but this is only the start of the problem. This assignment requires the participant to perform quantitative research to investigate a data set. Each team member is required to make specific contributions in undertaking the required tasks of this assignment. However it is the responsibility of the team as whole to ensure that the arguments and format of the report are cohesive reflecting the collective effort of the team. To achieve this outcome, it will be necessary for the team members to meet frequently to discuss the analysis and presentation. The purpose of this assignment is to gain experience exploring a data set and applying the statistical techniques that have been learned during the lecture sessions. The Data The data set is form the World Bank and contains the following variables: · Life expectancy at birth, total (years) · CO2 emissions (metric tons per capita) · Health expenditure per capita (current US$) · GDP growth (annual %) · Mobile cellular subscriptions (per 100 people) The Tasks 1. Create appropriate plots of the data and comment on the general trends present. 2. Calculate the mean, median, standard deviation for each variable and comment. 3. Perform correlation analysis of each variable with Life expectancy. Comment on the results and the implied relationships, i.e. just because two variables are highly correlated does this imply a cause and effect relationship? Discuss. 4. Perform hypothesis tests of the correlation coefficients from task 3. Are all of the relationships statistically significant? Discuss. 5. Regress the most highly correlated statistically significant variable from 3 and 4 on Life expectancy. Note the R-square value and the statistical significance of the independent variable. Note: when performing this regression keep in mind you discussion from task 3. 6. Perform regression again now regressing the two most highly correlated variables on Life expectancy. Are both independent variables statistically significant? Does the R-square value increase? Discuss. Note: again, when performing this regression keep in mind you discussion from task 3. 7. Does the regression statistical significance of these two variables agree with the correlation statistical significance? Discuss. 8. Based on the above analysis state the best regression equation to predict life expectancy, use statistical analysis to back up your conclusions. The Report · Present concise arguments supported by your analysis · Draw conclusions justified by the arguments and evidence · Begin the report with an executive summary and include any detailed analysis, tables and charts in appendices · Your report should cover the following as a minimum: · Executive summary · Each of the tasks listed above. · Major conclusions from your analysis and the implications of these conclusions · Any limitations of the analysis Statistical Analysis Software This data analysis should be preformed using statistical analysis software. All of the analysis required can be preformed using Excel, but other statistical packages are welcome to be used (but I may not be able to provide technical support). The text for the second section of the course gives detailed descriptions’ of how to perform the required analysis.

005_q1nf9pk-j0c0afcz.xls 005_ovnf9pk-o4rfhgmf.doc

Robert · Accepted Answer

Using the given data set calculate and interpret
	HOLMES INSTITUTE
FACULTY OF
HIGHER EDUCATION
	
HI5007 Statistics Business Research for Decision Making 
Trimester 2 2012
ASSIGNMENT 2 – DATA ANALYSIS
	Weght: 
	30%
	Word Limit:
	2000 words
Identifying a management problem and designing an appropriate business research strategy is critical for success in business, but this is only the start of the problem.  This assignment requires the participant to perform quantitative research to investigate a data set.
Each team member is required to make specific contributions in undertaking the required tasks of this assignment.  However it is the responsibility of the team as whole to ensure that the arguments and format of the report are cohesive reflecting the collective effort of the team.  To achieve this outcome, it will be necessary for the team members to meet frequently to discuss the analysis and presentation.  
The purpose of this assignment is to gain experience exploring a data set and applying the statistical techniques that have been learned during the lecture sessions. 
The Data
The data set is form the World Bank and contains the following variables:
· Life expectancy at birth, total (years)
· CO2 emissions (metric tons per capita)
· Health expenditure per capita (current US$)
· GDP growth (annual %)
· Mobile cellular subscriptions (per 100 people)
The Tasks
1. Create appropriate plots of the data and comment on the general trends present.
2. Calculate the mean, median, standard deviation for each variable and comment.
3. Perform correlation analysis of each variable with Life expectancy. Comment on the results and the implied relationships, i.e. just because two variables are highly correlated does this imply a cause and effect relationship? Discuss.
4. Perform hypothesis tests of the correlation coefficients from task 3. Are all of the relationships statistically significant? Discuss.
5. Regress the most highly correlated statistically significant variable from 3 and 4 on Life expectancy. Note the R-square value and the statistical significance of the independent variable. Note: when performing this regression keep in mind you discussion from task 3.
6. Perform regression again now regressing the two most highly correlated variables on Life expectancy. Are both independent variables statistically significant? Does the R-square value increase? Discuss. Note: again, when performing this regression keep in mind you discussion from task 3.
7. Does the regression statistical significance of these two variables agree with the correlation statistical significance? Discuss.
8. Based on the above analysis state the best regression equation to predict life expectancy, use statistical analysis to back up your conclusions.
The Report
· Present concise arguments supported by your analysis
· Draw conclusions justified by the arguments and evidence
· Begin the report with an executive summary and include any detailed analysis, tables and charts in appendices
· Your report should cover the following as a minimum:  
· Executive summary
· Each of the tasks listed above.
· Major conclusions from your analysis and the implications of these conclusions
· Any limitations of the analysis
Statistical Analysis Software
This data analysis should be preformed using statistical analysis software. All of the analysis required can be preformed using Excel, but other statistical packages are welcome to be used (but I may not be able to provide technical support). The text for the second section of the course gives detailed descriptions’ of how to perform the required analysis.
Solution
The data set is form the World Bank and contains the following variables:
· Life expectancy at birth, total (years)
· CO2 emissions (metric tons per capita)
· Health expenditure per capita (current US$)
· GDP growth (annual %)
· Mobile cellular subscriptions (per 100 people)
First we will create appropriate charts to graphically represent each variable and calculate descriptive statistics to summarize the data. Since this is a time series data we will use time series plot to represent each of the variables.
1. The following figure shows the line diagram of the variables:
From the above figure we can see that there is a continuous increasing trend. In 1995, the expected life expectancy at birth is between 77 and 78 and in 2008 it reached between 81 and 82.
From the above figure we can see that from 1995 to 1998 there was an increasing trend but from 1998 to 2001 it reached the maximum and 2001 onwards it has been increasing steadily. In 1995 the CO2 emissions (metric tons per capita) is 17 and in 2008 it was just above 18.5.
From the above figure we can see that Health expenditure per capita (current US$) was more or constatnt from 1995 to 2001 and 2001 onwards it has a consistent increasing trend. In 1995 Health expebditure per capita (current US$) is almost 1500 and in 2008 it was between 4000 and 4500.

Australia Data Year\Indicator NameLife expectancy at birth, total (years)CO2 emissions (metric tons per capita)Health expenditure per capita (current US$)GDP growth (annual %)Mobile cellular...

Answer To: Australia Data Year\Indicator NameLife expectancy at birth, total (years)CO2 emissions (metric...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment