Background

For the study looking at the effect of COVID rates on employment within Australia, I am using the following two economic models.

Unemployment rate=01CPI+2Covid rates 3GDP +4labor productivity

and

Employment rate=0+1CPI2Covid rates +3GDP 4labor productivity

I have attached a linked to my google sheets for the data that I compiled. I'm unsure if this is correct though but feel free to let me know.

https://docs.google.com/spreadsheets/d/1gkGq-YfdQh1qZkcESwXrzInmwjT80X5kSRTwyGg_g-Q/edit?usp=sharing

Question 2

My hypothesis would be there is a positive correlation between COVID rates and unemployment. Assuming this how do I test for model fit, overall significance, collinearity, heteroskedasticity and significance of independent variables?

Question 3

On STATA, I was having trouble generating tests as I keep getting this error 'options not allowed in bound factor variable lists'. Can you edit my data to make it work or What commands would I use to gain the results for the following tests?

• R-Square
• Adjusted R-Square
• Overall Significance
• Normality of Errors (Adjusted Chi-Square)
• Mean VIF
• Ramsey Reset Test
• Breusch-Pagan
• White Test
• Durbin Watson
• AIC
• BIC

Question 3

If you were able to run the tests, could you let me know the results or how to replicate them?

Question 4

Could you provide an analysis of these results so I could understand what is happening?

Thank you.