Your employer is interested to know the extent to which firm turnover, the total number of employees and the number of subsidiaries affect audit fees paid by the firms in the sector.

Firm$\_$ID Turnover $(000)$ Employees Subsidiaries Audit$\_$Fee $(000)$

$1389062\mathrm{.}0092690107\mathrm{.}00$

$2340612\mathrm{.}00116831594\mathrm{.}00$

$3321900\mathrm{.}00983111100\mathrm{.}00$

$4178253\mathrm{.}003328247\mathrm{.}00$

$5155876\mathrm{.}0041473223\mathrm{.}00$

$6153812\mathrm{.}0052813294\mathrm{.}00$

$7153560\mathrm{.}195040994\mathrm{.}80$

$8127055\mathrm{.}00164524215\mathrm{.}00$

$9123958\mathrm{.}0061400167\mathrm{.}00$

$10122004\mathrm{.}001720467\mathrm{.}00$

$1197224\mathrm{.}6033642452\mathrm{.}77$

$1295457\mathrm{.}0034861096\mathrm{.}00$

$1388083\mathrm{.}00363029\mathrm{.}00$

$1482706\mathrm{.}005673112\mathrm{.}00$

$1581262\mathrm{.}6321714678\mathrm{.}43$

Use the above to answer the questions below:

Run a multiple linear regression of Audit Fee on Turnover, Employees and Subsidiaries. Based on your results, how would you write the estimated regression equation for the expected value of audit fee?

Predict the expected audit fee paid by firms with turnover of $2$ million that have $50$ employees and two subsidiaries?

What measure can be used to assess a regression$$s ability to make good predictions? Comment on the goodness of fit of the estimated regression model?

Test the null hypothesis that firm turnover has no $($linear$)$ effect on audit fees?

Test the null hypothesis that the total number of subsidiaries has no $($linear$)$ effect on audit fees?

What conclusions can you draw about the factors that affect Audit Fee? Interpret the slope coefficient$($s$)$ of the statistically significant factor$($s$)?$

Your employer asks you to produce a table with mean, median, variance and standard deviation of the variable Turnover in the dataset by using the appropriate Excel functions. Use the file audit fees to calculate the mean, median, variance and standard deviation?

Use the dataset to produce a scatter plot of the number of employees and turnover. Explain whether the plot suggests any relationship between them?