Paper , Order, or Assignment Requirements

Scenario

You are Vic Rankin, and you work as an analyst for a company called Business Intelligence (BI). BI are data

analytics research service consultants that provide data modelling solutions to large organisations and

governments, as well as supporting various niche research projects across a variety of industry sectors.

Australian rural communities make a considerable contribution to the Australian economy yet very little

research has been done on the specific business communities that support the rural sector. For example, little

is known about the market place confidence and expectation of businesses that exist in the townships and small

rural cities that support our urban communities.

BI has been contracted because some rural municipal authorities have identified a need to focus expenditure

and related activities to assist in business growth. One such municipal authority is the Ballarat City Council. In an

effort to understand the marketplace confidence of the Ballarat businesses that support their local community,

BI has taken a random sample of 150 businesses. As well as asking them for useful demographic characteristics,

BI have asked questions about trading patterns, business confidence and business expectations.

You have received an email from the Ballarat City Council that contains specific questions that you must answer.

In an effort to begin to develop a basic understanding of the Ballarat business community we would like some

summary information. Regarding the data you recently collected on business confidence and expectation,

please provide me with the answers to the following questions. Your responses will assist us in determining

where the Councils’ resources might best be directed.

1. Regarding the age and number of employees of businesses in Ballarat.
2. Can you provide an overall summary of the age of businesses?
3. Can you also provide a summary on the number of people that these businesses employ?
4. There are 5,750 registered businesses in the Ballarat region. Please provide an estimate of the

total number of employees for all registered businesses combined.

2. Does the age of a business appear to have any effect on the number of people employed?
3. We know that the current economic climate is not favourable and so we are very interested to learn if this

is reflected in the attitudes of local businesses.

1. Can you please summarise the level of confidence in the local region’s business environment for

the next financial year?

1. Further, can you please summarise whether or not businesses have a growth strategy?
2. Is there any evidence of a relationship between confidence in the local region’s business environment for

the next financial year and having a growth strategy?

5. Lastly, we are interested to see if:
6. The amount spent on training per person each year is affected by the number of employees in the

business.

1. The amount a manager earns is affected by the manager’s age.