Assignment Cover Sheet
Qualification Module Number and Title
Higher National Diploma in Computing & Software Engineering COM5221 - Business Analytics
Student Name & No. Assessor
Prepared by Mr.Induranga De Silva – Module Leader
Hand out date Submission Date

Assessment type
Coursework Duration/Length of
Assessment Type
3 weeks Weighting of Assessment
100 %
Learner declaration
I, …………………………………………. name of the student and registration number , certify that the work submitted for this assignment is my own and research sources are fully acknowledged.
Marks Awarded
First assessor
IV marks
Agreed grade
Signature of the assessor Date
FEEDBACK FORM
INTERNATIONAL COLLEGE OF BUSINESS & TECHNOLOGY
Module:
Student:
Assessor:
Assignment:
Coursework
Learning outcomes covered
• Understand Business Analytics methodologies, tools and the techniques
• Evaluate business advantages produced by business analytics.
• Be able to perform a business analysis
• Be able to propose solution for a business problem or creating opportunity using appropriate business analytics methodologies, tools and the techniques
Scenario and the Task
Introduction
The Business Analytics subject domain is considered to be one of the major area where most of the companies and various profitable and non- profitable institutions consider for achieving the best decision support in their respective various operations life cycles. Because of the economy is growing rapidly to achieve tangible and intangible as well as financial and non-financial targets all most all the government and private organizations required to consider precision and accuracy of their management decisions in all major three levels; operational, tactical and strategic. The amount of information generated in modern agile economic environment is very high and nature of consistency also highly varies within short time frame. Because of the fact that utilization of big data analysis considered as one of the prime concern to deal with the data to produce credible and valuable information. During the process of conversion data to decision supportive information it is very important use different data analysis methods, techniques and tools that are comprehensively explained in data analytics. The high importance of data analytics subject elements leads to include those in modern management information systems and decision support information systems for enabling online analytical processing to incorporate with connected operational databases, data marts and data warehouses.
In performing big data analysis, it is very important to use good statistical software. At present there are many such products available under generic or bespoke software category considering open source or closed source. Usually open source products are financially feasible for many organizations compared to closed source products. At present big data analysis rapid growth identifiable in open source category with frequent versions and many feature extensions compared to closed source. On the other hand, side much reliable many software products have been released by industry pioneer solution providers. Therefore, section of the best product for data analysis is also need to be done wisely by relevant authorities of organizations for their objectives to be precisely achieved.
SCENARIO
Prestige of an occupation considered to be vital factor in planning human resource needed for national development planning in short term and long term. Identification of factors contribute for prestige of an occupation is very crucial in deciding what industries and professions need to be given priority when national development planning are done by government with the support of ministries such as industry and commerce.
The dataset comprises of information about various types occupations in Canada. The information includes education, income, women, prestige, census, occupation type. Any changes in those directly influence to have prestige score variations.
The ministry of industry and commerce is considering getting full-scale data science support to develop essential business intelligence required for further elaboration of the suggestions given by the consultants with the support of national and international real world examples in human resource management. The company has appointed a panel of experts in the field of data science to facilitate the aforementioned with the aid of local and foreign intelligence. Assume that you are one of the data scientists in the panel assigned with a special set of tasks to accomplish and provide a report of what factors contribute in prestige of occupation. You are required to complete the below mentioned tasks and prepare a report based on the findings.
Survey Data Dictionary
Variable name Description
Occupation Name of the occupation
education Average education of occupational incumbents, years, in 1971.
income Average income of incumbents, dollars, in 1971.
women Percentage of incumbents who are women.
prestige Pineo-Porter prestige score for occupation, from a social survey conducted in the mid-1960s.
census Canadian Census occupational code.
type Type of occupation. A factor with levels;
bc -Blue Collar;
prof - Professional, Managerial, and Technical;
wc - White Collar.
NA Data is Not Available
Tasks
1. Provide an in detailed explanation about the expectation of the analysis and benefits generated for the ministry of industry and commerce. (5 Marks)
2. Explain tools, techniques and methodologies going to use for the analysis. (6 Marks)
3. Find out minimum, maximum, mean, median, mode of income of the incumbents. (6 Marks)
4. Find out summary statistics of prestige, education, income of the incumbents. (6 Marks)
5. Graphically represent prestige, education, income of incumbents during the mentioned period of the survey. (10 Marks)
6. Conduct central tendency analysis for prestige, education and income and find out standard deviation of those. Represent finding graphically using bell curves. (12 Marks)
7. Using most suitable statistical hypothetical mean and variance testing justify whether occupation type affects the prestige of the incumbents in the industry during the mentioned time period. (10 Marks)

8. Using statistical hypothetical testing prove, whether there is a statistically significant relationship exist with prestige and education of the incumbents. (10 Marks)
9. Using statistical hypothetical testing prove, whether there is a statistically significant relationship exist with prestige and income of the incumbents. (10 Marks)
10. Using statistical hypothetical testing prove, whether there is a statistically significant relationship exist with prestige and Type of occupation of the incumbents. . (10 Marks)
11. Write a conclusion based on the above findings and suggest necessary recommendations. (15 Marks)
• Note: Data analysis results should be descriptively discuss with useful external information.
• Note: The conclusion can include the findings of suitable regression analysis as well.
Marking Scheme
Task-1 contains 5 marks
Criteria Marks
Out of 5
Fail
Not Explained the scenario and not included the benefits provided by the analysis for the selected company/institution etc.. 0-1
Pass
Explained the scenario.
1-2
Good
Explained the benefits provided by the analysis for the selected company/institution etc.
2-3
Excellent
Well explained the scenario and the benefits provided by the analysis for the selected company/institution.
3-5
Task-2 contains 6 marks
Criteria Marks
Out of 6
Fail
Not Stated tools, techniques and methodologies going to be used for analysis 0-1
Pass
Stated tools, techniques and methodologies going to be used for analysis 1-2
Good
Stated tools, techniques and methodologies going to be used for analysis. Explained the mentioned tools, techniques and methodologies. 2-4
Excellent
Stated tools, techniques and methodologies going to be used for analysis. Well explained the mentioned tools, techniques and methodologies.
4-6
Task-3 contains 6 marks
Criteria Marks
Out of 6
Fail
Not used minimum, maximum, mean, median, mode functions to get respective statistics of provided data 0-2
Pass
Used minimum, maximum, mean, median, mode functions to get respective statistics of provided data 2-4
Good
Used minimum, maximum, mean, median, mode functions to get respective statistics of provided data and got an accurate set of results and explained briefly about what obtained. 4-5
Excellent
Used minimum, maximum, mean, median, mode functions to get respective statistics of provided data and got an accurate set of results and well explained about what obtained. 5-6
Task-4 contains 6 marks
Criteria Marks
Out of 6
Fail
Not included summery statistical data using summary statistical function. 0
Pass
Included summery statistical data using summary statistical function. 6

Task-5 contains 6 marks
Criteria Marks
Out of 10
Fail
Not Included bar chart/pie chart/ to represent data provided graphically. 0-1
Pass
Included bar chart/pie chart/ to represent data provided graphically. 1-4
Good
Included bar chart/pie chart/ to represent data provided graphically
and included brief information about what is represented in the charts. 4-7
Excellent
Included bar chart/pie chart/ to represent data provided graphically
and included well described information about what is represented in the charts. 7-10
Task-6 contains 12 marks
Criteria Marks
Out of 12
Fail
Not Included bell curves based on data provided 0-1
Pass
Included bell curves based on data provided
1-6
Good
Included bell curves based on data provided and
Described information represented in the charts briefly
6-10
Excellent
Included bell curves based on data provided and
Well described information represented in the charts briefly 10-12

Task-7 contains 10 marks
Criteria Marks
Out of 10
Fail
Not Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis 0-1
Pass
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on mean and variance analysis test. Yet some errors exists. 1-5
Good
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis. Good statistical justification of result based on mean and variance analysis test. 6-7
Excellent
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis. Excellent statistical justification of result based on mean and variance analysis test. 7-10
Task-8 contains 10 marks
Criteria Marks
Out of 10
Fail
Not Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis 0-1
Pass
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test 1-5
Good
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test supported by normality test 6-7
Excellent
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test supported by normality test. Results findings and justifications done excellent manner. 7-10
Task-9 contains 10 marks
Criteria Marks
Out of 10
Fail
Not Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis 0-1
Pass
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test 1-5
Good
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test supported by normality test 6-7
Excellent
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test supported by normality test. Results findings and justifications done excellent manner. 7-10
Task-10 contains 10 marks
Criteria Marks
Out of 10
Fail
Not Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis 0-1
Pass
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test 1-5
Good
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test supported by normality test 6-7
Excellent
Inclusion of hypothetical statement considering null hypothesis and alternative hypothesis and statistical justification of result based on correlation analysis test supported by normality test. Results findings and justifications done excellent manner. 7-10
Task-11 contains 15 marks
Criteria Marks
Out of 15
Fail
Not Provided conclusion based on statistical findings done based on hypothetical testing. 0-1
Pass
Provided conclusion based on statistical findings done based on hypothetical testing. 1-5
Good
Provided conclusion based on statistical findings done based on hypothetical testing. The conclusion should comprise of sub conclusions of question no 07, 08, 09 and 10. 5-10
Excellent
Provided conclusion based on statistical findings done based on hypothetical testing. The conclusion should comprise of sub conclusions of question no 07, 08, 09 and 10. The student provided recommendation to support improvements of the organization. Applications of suitable regression analysis findings are highly anticipated.
10-15

Submission Guidelines
Report Structure:
• Executive Summery
• Table of contents, Table of Figures, Table of Tables
• Introduction of the Organization & its operational environment /Scenario
• Data Analysis and Discussion
• Conclusion
• Future Recommendation
• Gantt chart & its Description
• Referencing
• Appendix (Appendix A, Appendix B, etc.) for Group meetings, Samples of Questionnaire
Report Format:
? Submission format Report
? Paper Size: A4
? Words: 3000 words
? Printing Margins: LHS; RHS: 1 Inch
? Binding Margin: ½ Inch
? Header and Footer: 1 Inch
? Basic Font Size: 12
? Line Spacing: 1.5
? Font Style: Times New Roman
? Referencing should be done strictly using Harvard system