Business Modelling And Analysis Assignment | Homework For You
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. For this purpose, please ensure that you have studied supplementary material about the academic report writing, available one activity 5.4 before you start your assignment. This assignment is worth 20% of your final mark.
This assignment provides students with an 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 observations (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. Get Statistics homework help today
