Stock market Total assets Industry Gender-diversity Proportion of female Firm ID ROA % return % (in $mil) group board directors on board -7.75 -45.46 482 O 0.00 4.28 63.54 503 0 0.00 W 0.76 0.00 511 0.00 0.52 4.65 522 0.00 10.53 -2.76 526 0.00 7.55 9.65 528 0.00 1.36 -2.90 538 0.00 0.31 -38.30 601 0.00 22.55 -15.56 8,238 0.25 10 21.85 59.77 2,736 0.20 1 1 4.16 12.75 537 0.00 12 9.10 -31.85 550 - oo oo - - - oo- - ooo0 0 0.00 13 33.72 27.54 2,879 0.08 14 21.35 -7.47 2,919 0.25 15 15.04 -25.96 2,924 0.33 16 5.44 6.68 562 0.00 17 1.68 - 16.09 569 0.00 18 5.80 13.16 578 0.00 19 4.60 37.17 567 0.00 20 9.62 109.86 2,992 0.30 21 6.24 1 1.47 3,013 0.13 22 3.23 -35.67 568 0.00 23 5.16 -69.31 3,037 o - o 0.14 24 5.98 46.38 675 0.00II The report should have the following structure: Introduction, Statistical Analyses (where you perform hypothesis tests for each of the four questions) and Conclusions (where you summarize the ndings and discuss the limitations}. I Your report should also include technique identication and any underlying assumptions required (with checking for the required assumptions). 0 Why do you use a particular technique? Consider the types of data quantitative, qualitative or ranked? How many samples? Are these samples independent? 0 What are the underlying assumptions? Have you checked the assumptions? ' If checking for normal distribution, consider to put up the histogram and discuss the shape. ' If you found it is not annually distributed, keep doing the test with the underlying assumption, but need to discuss this as one of your limitations in the overall conclusion. 0 The parameter of interests and populations must be clearly dened. . Checking normal distributions by observing histograms o Histograms can be obtained from Excel o Excel automatically produce the histogram with gap (default at 150%). You need to reduce the gap to 0% (right click to the histogram, then choose Format Data Series, then reduce the Gap Width to 0%). . For each of the hypothesis tests, you need to perform at 3 significance levels (1%, 5% and 10%) and the decision to reject or accept the null hypothesis must refer to all 3 significance levels. . This is a computing assignment. You are expected to use Excel to perform relevant tests and run the regression analysis. A copy of Excel file showing your workings should be submitted via Blackboard. Descriptive statistics are also obtained from Excel. o You need to describe the procedure of obtaining relevant tests. o The results obtained from Excel are presented in the report. The tables must be clear to read. Each test has to be performed for 3 levels of statistical significance (1%, 5% and 10%). " Do not present 3 tables for each significant level. Please condense all the results in one table only. o For t-test and z-test, Excel reports the results for one-tailed and two-tailed tests. You need to report only the critical value of one-tailed test or two- tailed test depending your alternative hypothesis, but not both