Question: 200032 STATISTICS FORBUSINESS(INTERNAL) ASSIGNMENT DATA SET:008 The assignment will require you to use Excel to organise and summarise data graphically and numerically. All calculations and
200032 STATISTICS FORBUSINESS(INTERNAL) ASSIGNMENT DATA SET:008
The assignment will require you to use Excel to organise and summarise data graphically and numerically. All calculations and statistical analyses must be performed using Excel.
The assignment will require you to use Excel to organize and summaries data graphically and numerically. All calculations and statistical analyses must be performed using Excel.
| Profit | Type | Employees | Age | Location |
133000 | 1 | 32 | 10.5 | 1 |
| 147000 | 1 | 28 | 16.2 | 2 |
| 188000 | 1 | 18 | 9.4 | 2 |
| 137000 | 1 | 22 | 9.4 | 2 |
| 83000 | 3 | 11 | 7.6 | 1 |
| 109000 | 1 | 10 | 8.0 | 1 |
| 174000 | 1 | 19 | 11.1 | 1 |
| 101000 | 1 | 28 | 10.2 | 1 |
| 70000 | 1 | 17 | 8.9 | 1 |
| 128000 | 1 | 16 | 8.5 | 1 |
| 98000 | 1 | 17 | 15.2 | 2 |
| 75000 | 1 | 18 | 10.2 | 1 |
| 216000 | 1 | 14 | 17.3 | 2 |
| 158000 | 1 | 25 | 10.4 | 1 |
| 57000 | 3 | 29 | 11.4 | 2 |
| 102000 | 2 | 27 | 23.0 | 2 |
| 99000 | 3 | 15 | 9.8 | 1 |
| 70000 | 1 | 18 | 9.8 | 1 |
| 71000 | 3 | 17 | 9.6 | 1 |
| 258000 | 1 | 21 | 9.6 | 2 |
| 155000 | 2 | 22 | 13.4 | 2 |
| 63000 | 3 | 20 | 8.9 | 2 |
| 125000 | 2 | 25 | 20.4 | 2 |
| 64000 | 3 | 19 | 12.8 | 2 |
| 152000 | 3 | 23 | 9.3 | 2 |
| 83000 | 1 | 12 | 9.4 | 1 |
| 93000 | 2 | 23 | 13.7 | 1 |
| 98000 | 3 | 10 | 11.3 | 2 |
| 128000 | 3 | 23 | 13.8 | 2 |
| 226000 | 1 | 18 | 15.4 | 2 |
| 99000 | 1 | 19 | 9.6 | 1 |
| 73000 | 3 | 20 | 7.1 | 1 |
| 58000 | 3 | 23 | 9.6 | 1 |
| 141000 | 2 | 29 | 20.9 | 2 |
| 94000 | 3 | 21 | 6.4 | 1 |
| 87000 | 2 | 24 | 14.6 | 2 |
| 9000 | 2 | 13 | 14.6 | 1 |
| 123000 | 2 | 30 | 19.6 | 2 |
| 85000 | 1 | 13 | 11.0 | 1 |
| 63000 | 1 | 20 | 11.4 | 1 |
| 99000 | 1 | 10 | 9.9 | 1 |
| 20000 | 1 | 21 | 9.4 | 1 |
| 144000 | 1 | 18 | 10.8 | 1 |
| 54000 | 1 | 15 | 9.3 | 1 |
| 87000 | 3 | 33 | 8.5 | 1 |
| 125000 | 2 | 17 | 16.4 | 2 |
| 125000 | 1 | 16 | 9.6 | 1 |
| 152000 | 1 | 20 | 10.0 | 2 |
| 105000 | 1 | 21 | 9.8 | 1 |
| 104000 | 2 | 25 | 20.8 | 2 |
| 87000 | 2 | 23 | 14.0 | 1 |
| 130000 | 2 | 20 | 16.2 | 2 |
| 127000 | 2 | 16 | 14.0 | 2 |
| 135000 | 3 | 25 | 8.5 | 2 |
| 217000 | 1 | 13 | 10.3 | 2 |
| 154000 | 2 | 22 | 21.4 | 2 |
| 15000 | 1 | 15 | 8.2 | 1 |
| 105000 | 1 | 19 | 11.0 | 1 |
| 156000 | 1 | 17 | 13.6 | 2 |
| 170000 | 1 | 13 | 15.4 | 2 |
interpretation of data
A study was commissioned to investigate the characteristics of local businesses. Data was collected on 70 local businesses and the following variables recorded:
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
|---|---|---|---|---|
| Profit | Type | Employees | Age | Location |
| What was your 2014 profit? | Is the business privately held, publicly traded or a franchise? (Private = 1, Public = 2, Franchise = 3) | How many employees work at your business? | How old is the company (in years)? | Where is the company? (1 = Parramatta CBD, 2 = Sydney CBD) |
Recorded variables (2018) created by Western Sydney University Online
Using the information you have been provided, answer the following questions:
QUESTION 1
Calculate a 95% confidence interval for the unknown population mean business age.
QUESTION 2
Test, at the 1% level of significance, whether the average business has more than 15 employees.
QUESTION 3
Test, at the 5% level of significance, whether the average profit in 2014 differs between businesses located in Parramatta CBD or located in Sydney CBD. You may assume that the unknown population standard deviations for Parramatta and Sydney businesses are equal.
QUESTION 4
Test, at the 5% level of significance, whether location (Parramatta or Sydney CBD) of the business is related to type of business (privately held, publicly traded or franchise).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help