Business Analytics SPSS

BUS750 – Business Analytics

Individual Assignment Re-Sit

This Portfolio consist of IBM SPSS Project and Analytical Report should be submitted

via Blackboard on

Friday 05 th

July 2019 by 23:59.

Section One: Practical Part - Analysis of Data (60%)

For this section you will need to analyse some quantitative data using IBM SPSS Statistics and

write a report on your findings. Each question should consist of data analysis, commentary

and interpretation and should make good use of published sources to justify your choices.

You should write a well-structured and designed report of between 750 and 1000 words –

plus any diagrams and charts you produce and a list of references.

You need to use the dataset hals.sav and fluoridation.sav (available on Blackboard) using

IBM SPSS, which will include all of the following:

The directors of a medium sized company have asked you to investigate answers to several lifestyle related questions and write a short report for them. You have access to a Health and Lifestyle (HALS) survey of the health of the male employees in mid-life age or older that has recently been carried out (hals.sav). The questions you need to investigate – in some detail - are: N.B. For the first five questions you need to use your individual dataset provided.

1. What is the age distribution of the men? (Numerical and Graphical Presentation) [5 marks]

2. What proportion of men belongs to each category of own health (OWNH)? (Numerical and Graphical Presentation) [5 marks]

3. Provide numerical summary of the height and weight variables of the men? (Descriptive Statistics) [5 marks]

4. How is lung function (HYFEV) related to age, if at all? (Hypothesis Testing, Correlation and Linear Regression Analysis) [20 marks]

5. How different are the average lung functions (HYFEV) of the different social class

categories? (Hypothesis Testing, T Test) [ 10 marks]

6. Using the “Fluoridation.sav” dataset, are there a significant differences between fluoridation treatments in terms of the number of decayed, missing or filled teeth (DMFT)? (Use, for example, Non-Parametric Kruskal-Wallis One-Way ANOVA) [15 marks]

Use IBM SPSS Statistics to carry out appropriate analyses of the data “hals.sav” and “fluoridation.sav” respectively to investigate these questions in some detail, and write a report presenting your findings and explanations of what these analyses mean to the audience – who do not know much about statistics.

Details of variables of the Health Survey file (hals.sav)

SERNO Respondent’s serial number AGYRS Age in years HEIGHT Height (cm) Missing Values: 999.9 WEIGHT Calculated Nude Weight (kg) Missing Values: 999.9 BMI Body Mass Index (wt/ht2) Missing Values: 99.99 WHR Waist-Hip ratio PHYSIQUES body shape Value Label 1 lean

2 lean android

3 overweight gynoid

4 overweight ovoid SMEVER Ever Smoked? Missing Values: 9 Value Label 1 yes

2 no

ALCOHOL Units alcohol last week Missing Values: 999 SATFAT Saturated fat g/wk SCLASS Social class Value Label 1 non-manual

2 manual OWNH Own health in general Missing Values: 8 Value Label 1 EXCELLENT

2 GOOD

3 FAIR

4 POOR 8 DONT KNOW HYFEV Forced expiratory volume Missing Values: 8.88, 9.99 LOWSYS Lowest systolic BP (of three) Missing Values: 888, 999 LOWDIAS Lowest diastolic BP (of three) Missing Values: 888, 99 MSTATEGP Response to mental state questionnaire Value Label 1 good mental state

2 poor mental state

Detailed procedure

1. Download the SPSS Booklet (Statistics with SPSS) from the folder of the Weekly Materials in the Business Analytics module website and work through the booklet.

2. Find the data file “hals.sav” and “fluoridation.sav” in the Assessment Data folder of the Business Analytics module website, download and save them.

3. Work through the 6 questions above.

4. Produce the appropriate analyses.

5. Format the tables and charts well, giving them titles, labelling the axes etc. Right click the charts to edit them.

6. Write your report according to the above brief, including the charts/diagrams and

analyses from IBM SPSS Statistics, with your comments/interpretations of the analyses, explaining what they mean. Right click the charts etc to copy and paste them into your report. Make sure any graphics are labelled correctly and explicitly referred to. Use the conventional report format.

Section Two: Theoretical part – Analytics Report (Written Component) (30%)

You are required to write a short research report on Business Analytics (BA) in an area of

your choice. The overall structure should follow these lines:

 Describe your chosen sector (e.g. Finance, Government, Health, Education, Retail, Social Media) and/or function (e.g. Marketing, HRM, Supply chain management, Design, Customer Relations Management).

 Critically analyse the impact and presence of Business Analytics in relation to the sector and/or function.

 Make an informed assessment on the future of Business Analytics in your chosen sector or function.

Word count: 1000-1500

Element Description

Describe your chosen

sector or function

(10 marks)

Identify an area of your choice. You do not need to articulate the

area specifically in BA terms at this stage, but it would be useful to

give thought to the Information Systems (IS) processes that you

would assume to be in place, if it is applicable.

Critically analyse the

impact and presence of

Business Analytics in

relation to the sector or

function (10 marks)

In this section, you will need to research how the rise of BA has

changed practices and mind-sets in your sector or functional area.

You should support your treatment with examples, where possible.

In your analysis, you may discuss positive and negative impact, as

well as ethical considerations.

Make an informed

assessment on the future

of Business Analytics in

This section should be a combination of informed research and a

certain level of creativity on your part. This section should also

form the conclusion of your submission.

Element Description

your chosen sector or

function (10 marks)

 You should make good use of credible published sources and refer to any sources you use – textbooks, articles etc in the conventional manner.

 Include a list of references formatted in the Harvard Style (See University website).

Overall structure and report presentation (10 marks)

1. Deliverables  Practical – IBM SPSS Project (Data Analysis).

 Theoretical - Analytics Report (Written component).

2. Report word count guide Words excluding appendices and bibliography for the Written Component.

3. Submission The Written Component Report and IBM SPSS Project should be submitted via Blackboard

on Friday 05th July 2019.

Please ensure you are aware of the rules of Plagiarism; this is an individual submission.