BML224: Data Analysis for Research
BML224: Data Analysis for Research
Dataset Guide 2
Introduction The following guide provides information relating to a series of variables in a file called EXAMFILE2010. This file relates to the results of a survey of 600 retail businesses in Hampshire and West Sussex, regarding their attitudes to e-‐commerce, marketing and sustainable business management. The survey also looked at the characteristics of businesses and the motivations influencing business strategy. An initial analysis of the results suggest that businesses in the West Sussex are more pro-‐active in terms of developing e-‐commerce, and that the size of business, business motivations, previous occupations, and perceived value of e-‐commerce are all important factors influencing business strategy. Businesses have also noticed the impact of recession, however there is a clear difference in terms of how businesses have adapted to recession. Please read through this guide carefully and familiarise yourself with the different variables. This dataset will be used as the basis of in-‐class activities using SPSS. The Assessment file can be downloaded from the BML224 homepage on Moodle.
Assessment Guide -‐ 1
BML224: Data Analysis for Research
Data Fields (in alphabetical order)
Details
Ref No.
Reference number of the establishment
Data Type For indexing only
Section 1: Entrepreneurial and Business Profile AGE
Age of the entrepreneur
AREA
Area Code: 1: West Sussex 2: Hampshire
AGECAT
Age of the entrepreneur (by category): 1: 20 to 30 2: 31 to 40 3: 41 to 50 4: 51 to 60 5: 61 to 70 6: 71+
EMPLOYEES
Number of Employees (by category): 1: 1 to 5 2: 6 to 10 3: 11 to 15 4: 16 to 20 5: 21+
LENGTHCAT
Length of business ownership (by category): 1= up to 5 years; 2=over 5 years
OCC
Previous Occupation (by category): 1: Managers and Administrators 2: Professional Occupations 3: Clerical and Secretarial 4: Sales 5: Manual
OWNER
Ownership/management status of the businesses (by category): 1: Owner and Manager 2: Manager
PROFIT08
Annual profit 2008
PROFITRANK08
Rank of business based on 2008 profit
PROFIT09
Annual profit 2009
PROFITRANK09
Rank of business based on 2009 profit
Assessment Guide -‐ 2
BML224: Data Analysis for Research
RECESSION
Whether the business has noticed a change in consumer retail spend (by category): 1: Yes 2: No
RESPONSE
Business Response to the Recession (by category): 1: Pro-active 2: Re-active
SIZE
Size of the business by Profit (by category): 1: £0 to £9,999 2: £10,000 to £19,999 3: £20,000 to £29,999 4: £30,000 to £39,999 5: £40,000 to £49,999 6: £50,000 to £59,999 7: £60,000+
TOWN
Name of Town: Chichester [West Sussex] Worthing [West Sussex] Portsmouth [Hampshire] Winchester [Hampshire]
TOWNCODE
Town - Coding Scheme: 1: Chichester [West Sussex] 2: Worthing [West Sussex] 3: Portsmouth [Hampshire] 4: Winchester [Hampshire]
Assessment Guide -‐ 3
BML224: Data Analysis for Research
Section 2: Sustainable Business Management CTAUDIT07
Carbon Trust Audit Score in 2007 [Refers to a business audit conducted by the Carbon Trust at the end of which the business gets a carbon score – the higher the score the more the business is doing to off-set its carbon footprint]
CTRANK07
Rank of business based on Carbon Trust Audit Score
CTAUDIT09
Carbon Trust Audit score in 2009 [Refers to a business audit conducted by the Carbon Trust at the end of which the business gets a carbon score – the higher the score the more the business is doing to off-set its carbon footprint]
CTRANK09
Rank of business based on Carbon Trust Audit Score
CTCHANGE
Change in Carbon Trust Audit Score 2007-2009
CARBONTRUST
Recipient of free Carbon Trust audit training (by category): 1: Yes 2: No
CTVALUE07
Business attitudes to the value of the Carbon Trust Audit in 2007: 1: Low Value to 10: High Value
CTVALUE09
Business attitudes to the value of the Carbon Trust Audit in 2009: 1: Low Value to 10: High Value
INVEST
The level of actual investment in off-setting the carbon footprint of the business
INVESTRANK
Rank of business based on carbon off-setting investment
MEMBER
Member of Hampshire and West Sussex Sustainable Business Partnership (by category): 1: Yes 2: No
PRODUCER
Attendance at a University of Chichester ‘Profitability through Sustainability’ course (by category): 1: Attendee 2: Non-Attendee
Assessment Guide -‐ 4
BML224: Data Analysis for Research
SAVINGS
Percentage reduction in energy costs derived as a result of Carbon Trust energy audit
SAVINGSRANK
Rank of business based on the reduction in energy costs derived as a result of Carbon Trust energy audit
SUPPLY08
Percentage of goods and services sourced locally in 2008
SUPRANK08
Rank of business based on the percentage of goods and services sourced locally in 2008
SUPPLY09
Percentage of goods and services sourced locally in 2008
SUPRANK09
Rank of business based on the percentage of goods and services sourced locally in 2009
SCHANGE
Change in the use of locally sourced goods and services between 2008 and 2009
Assessment Guide -‐ 5
BML224: Data Analysis for Research
Section 3: E-Commerce, Marketing, and Customer Service ATTEND
Attendance on Business Link improving retail competitiveness workshop (by category): 1: Attendee / 2: Non-Attendee
BASKET
Percentage of sales taken online in 2009
BLINK07
Perceived value of Business Link retail support in 2007: 1: Low to 10: High
BLINK09
Perceived value of Business Link retail support in 2009: 1: Low to 10: High
GAIN
Percentage change in sales through online shopping basket 2008-2009
INTQUAL07
Businesses perceived importance of online retail presence in 2007: 1: Low to 10: High
INTQUAL09
Businesses perceived importance of online retail presence in 2009: 1: Low to 10: High
MARKETING07
Percentage of net profit invested into wider business development in 2007
MARKETING09
Percentage of net profit invested into wider business development in 2009
ONLINE
Online Retailer (by category): 1: Yes 2: No
SERVICE07
Perceived consumer expectations of customer service in 2007: 1: Low to 10: High
SERVICE09
Perceived consumer expectations of customer service in 2009: 1: Low to 10: High
Assessment Guide -‐ 6