Microeconomics
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
Q1.[3 marks]
Create a table as shown below using Excel. Add the table Note.Using information for all Victorian LGAs,fill in the table and the three sets of question marks in the table note.Show your calculations(including the formula)for computing the 95%confidence interval for the mean number of businesses per 1,000 employed.Use 2 decimal places when filling in the table and the table note.
|
Table 1:Businesses,large businesses and business entry and exits in Victorian LGAs |
|||
|
|
Mean |
Standard Deviation |
95%Confidence Interval |
|
No.businesses per 1,000 employed |
|
|
[,260.08] |
|
No.large businesses per 1,000 employed |
|
|
|
|
No.businesses entering per 1,000 employed |
|
|
|
|
No.businesses exiting per 1,000 employed |
|
|
|
Note:
The value of the t-distribution with?? degrees of freedom that leaves?? percent in the upper and lower tails is ??.
Q2.[7 marks]
Create a table as shown below using Excel.Add the table Note.Using information for Regional Victorian LGAs and Greater Melbourne LGAs,fill in the table and the six sets of question marks in the table note.Use 2 decimal places when flling in the tables and the table note.
|
Table 2:Comparing businesses,large businesses and business entries and exits in Regional Victorian and Greater Melbourne LGAs |
||||
|
|
Regional Victoria |
Greater Melbourne |
||
|
|
Mean(SD) |
95%Confidence Interval |
Mean (SD) |
95%Confidence Interval |
|
No.businesses per 1,000 employed |
|
[,268.82] |
|
[,262.66] |
|
No.large businesses per 1,000 employed |
|
|
|
|
|
No.businesses entering per 1,000 employed |
|
|
|
|
|
No.businesses exiting per 1,000 employed |
|
|
|
|
2025-10-15