Question: Businesses in San Pedro

• Use "Hoovers San Pedro Business Data.xls"
• Use Excel’s Data Analysis for this section.
• ONLY submit outputs of the Descriptive Statistics, graphs and the interpretations.

a. Briefly interpret the descriptive statistics of "Annual Sales ($ million)".

b. Briefly interpret the descriptive statistics of "Number of Employees".

c. Using "Annual Sales ($ million)", create 3 categories of businesses in San Pedro: Large (sales 3 million or more); medium (1 million or more but less than 3 million); small (less than a million). Create a Pie Chart to summarize the data (% frequencies). Comment.

d. Using "Number of Employees", create 3 categories of businesses in San Pedro: Large (100 or more); medium (20 or more but less than 100); small (less than 20). Create a Pie Chart to summarize the data (% frequencies). Comment.

e. Communities are often interested in labour-intensive businesses because these types of business oftentimes stimulate the economy more than labour-poor businesses. Create a "Sales-to-Employee" ratio (enter = 1000,000*Sales/Number of Employees; this is sales-per-employee in $). A more labor-intense business will have lower sales-to-employee ratio. Create a pie chart of 3 categories of labor-intensity: High (Below $40,000); Medium (from $40,000 but less than $100,000); Low ( $100,000 or more). Comment.

f. Is labor-intensity related to the type of industry? Clearly explain your answers.

g. Propose public policies that help promote more employment in San Pedro. Explain why your propositions might work and why they might not work!

Price: $2.99

Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document