Reference no: EM132318484
Business Modelling and Analysis Assignment -
Objectives - In this assignment you are expected to develop a business report that will be presented to a senior manager of a human capital management company. The report should be informative but concise and follows a specific structure that allows the document to be easily read and understood.
This assignment provides students with opportunity to:
- combine statistical analysis and report writing skills to prepare a concise, non-technical business report,
- draw a random sample to complete statistical analysis,
- develop and enhance computing skills, specifically the use of the built-in functions in MS Excel and MS Word,
- apply statistical techniques to a data set, and
- reinforce taught concepts including descriptive statistics, sampling and estimation, hypothesis testing, correlation and regression.
Tasks - Most of your statistical calculations should be carried out using Excel only and you will use Microsoft Word and Excel to complete this assignment.
1. Select a Random Sample
Select a random sample of size 100 from the given 182 countries (as demonstrated in videos of e-tivity 1.1). Remember that 182 countries constitute the population of interest and do not calculate any parameters such as mean and standard deviation from the population. Then from each category with an odd number (categories 1, 3, 5, 7, 9 and 11), select one variable only. For example, under category 3, Shelter, there are four variables. They are:
- Availability of affordable housing
- Access to electricity
- Quality of electricity supply
- Household air pollution attributable deaths
You need to select only one of them based on your preference for this category. As a result, each student will have a different sample that includes different variables. After this process, you will have a data set with a total of eight variables (including Countries Names and Continent) and 100 observations corresponding to each variable. If you have variables with missing values in your sample, you are allowed to remove those observation (delete the entire row that has a missing value). In that case your sample will be below 100 observations, which is acceptable. You will use this sample data to complete tasks 2 to 5.
2. Descriptive Statistics
Use appropriate data summary methods to describe the variables in your sample. At this stage, you only concentrate on seven variables and exclude Countries Names. For each of the seven remaining variables, you need to have a graph and a table and descriptions for both. Use an appropriate graphical and/or summary statistical technique based on the type of variable. These techniques include:
Tabular Techniques: e.g. Frequency tables and Grouped (joint) frequency tables.
Graphical Techniques: e.g. Pie chart, Bar graph, Histogram (avoid three dimensional graphs).
Summary Statistics: e.g. Mode, Median, Mean, Standard Deviation, Range, Coefficient of Variation and Interquartile Range (you do not have to report all of these summary statistics. Choose the most appropriate measures based on your personal judgement).
You will need to choose the most appropriate technique(s) for each analysed variable. Less appropriate/inappropriate techniques will receive fewer/no marks.
For a nominal or an ordinal (discrete) variable, draw a graph and present a frequency table in percentages.
For a ratio or an interval variable (continuous), draw a graph and a summary statistics table.
Try to use different graphs, e.g. pie chart/bar chart or histogram as much as possible for different variables. Do not draw two different graphs for the same variable.
3. Confidence intervals
Estimate the following quantities using 95% confidence intervals. Explain the meaning of your confidence intervals.
i. The average of the variable that you have chosen from Category 3 (Shelter).
ii. The average of the variable that you have chosen from Category 11 (Tolerance and Inclusion).
4. Hypothesis Testing
Margaret has some concerns about the common assumptions regarding social development across countries in different continents. As such, she asked Jason to carry out the following hypothesis tests based on the chosen variables in these categories.
Prepare a report on social development across countries in different continents by considering social progress index. Further find out the answers of following research questions.
i. It has been argued that the level of Access to Basic Knowledge is higher among American countries than African countries?
ii. It there any difference in terms of Personal Rights between Asian and European countries?
iii. It there any difference in terms of Health and Wellness between European and American countries?
Only present the main elements of your analysis and your important findings in the main section of the report. The computations and Excel outputs should be placed in an appendix.
5. Correlation and Regression
Margaret is interested in the relationships between some of these social variables. Margaret asked Jason to conduct regression analysis on the following variables:
- Nutrition and Basic Medical Care related variables (Category 1) and Health and Wellness variables (Category 7).
- Access to Basic Knowledge related variables (Category 5) and Personal Rights variables (Category 9).
Use these variables to develop two regression models and make sure to provide full discussions on each test. Use your chosen sample for these analyses. You discussions for each test should include:
- a scattergram and full interpretation
- an estimate of the linear regression model
- the coefficients of correlation and determination
- a test of the hypothesis that there is no linear relationship between dependent and independent variables.
Assignment structure -
Presentation
Executive summary
Introduction (about half a page)
Analysis
Conclusion and limitations (about one page)
Reference list
Appendices
Attachment:- Assignment Files.rar