Data Set Numbers = 78

The Minister of Industry and Trade is interested in the characteristics of local businesses. He decides to concentrate on businesses in the Parramatta CBD and the Sydney CBD. He employs a research company to survey 70 local businesses. This was carried out and the following variables recorded.

Column 1 Profit What was your profit?

Column 2 Advertising How much money was spent on advertising in the financial year?

Column 3 Employee How many employees work at your business?

Column 4 Age How old is the company (in years)?

Column 5 Type Is the business privately held, publicly traded or a franchise?

(Private = 1, Public = 2, Franchise = 3)

Column 6 Location Where is the company? (1 = Parramatta CBD, 2 = Sydney CBD)

Question 1 (7 marks)

Test, at the 5% level of significance, whether the average profit 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 2 (6 marks)

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

Question 3 (7 marks)

Can we conclude, at a 5% level of significance, that a linear relationship exists between the company's Profit (y) and the amount spent on Advertising (x)?

Instructions: You must use Excel to carry out all calculations and statistical analyses. Please screenshot the excel and send