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.

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	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	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	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	2
105000	1	21	9.8	1
104000	2	25	20.8	2
87000	2	23	14	1
130000	2	20	16.2	2
127000	2	16	14	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	1
156000	1	17	13.6	2
170000	1	13	15.4	2
55000	1	24	11	1
93000	2	23	17.8	1
70000	2	33	13.4	1
100000	1	16	12.1	1
82000	1	10	9	1
74000	2	26	13.7	2
160000	2	18	19.4	2
79000	1	17	9.6	1
59000	3	22	9	1
76000	1	18	9.4	1

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.

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).