Your business report is an analysis of ASX-listed companies from various industries. The data from over 700 companies has been downloaded from S&P Capital IQ database for you and can be summarized as follows: Column A: Company Name The company name and ticker symbol for that company in parentheses after the name Column B: Exchange: Ticker This is the unique identification symbol for a publicly traded company stock (shares) Column C: Exchange The primary listing or main stock exchange where trading of the company's shares takes place Column D: Industry Classifications Industry in which the company undertakes its activities Column E: Total Debt The latest annual total debt from the balance sheet of the company in AUD Column F: Total Equity The latest annual total equity from the balance sheet of the company in AUD Column G: Revenue The latest annual revenue from the income statement of the company in AUD Column H: Cost of Goods Sold The latest annual cost of goods sold from the income statement of the company in AUD Column I: Gross Profit The latest annual gross profit from the income statement of the company in AUD Column J: Selling and Marketing Expense The latest annual selling and marketing expense from the income statement of the company in AUD Column K: Net Income The latest annual net income from the income statement of the company in AUD REQUIRED You need to address the following questions as part of your written report to the ASIC Board of Directors. 1. Is there a significant difference in the average total debt between two of the industries? For the purpose of this question you can select the sample of companies in the dataset from two separate industries to compare (please choose two industries with n>50). 2. Disregarding companies that have zero net income, do companies from all industries with higher than average net income also have lower than average total debt? For this question remove companies with zero net income before analyzing the data. 3. Is there a significant difference in the revenue amongst the healthcare, energy and materials industries companies. FUTHER INSTRUCTIONS The report covers hypothesis tests from Module 5 to Module 8. However, Module 4 which contains data collection and sampling, should be also discussed in your report. 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 findings and discuss the limitations). Your report should also include technique identification and any underlying assumptions required (with checking for the required assumptions). o Why do you use a particular technique? Consider the types of data - quantitative, qualitative or ranked? How many samples? Are these samples independent? o What are the underlying assumptions? Have you checked the assumptions? Checking for normal distribution will be done by observing the histogram and discuss its shape. If the histogram does not show normal distribution for the sample, you keep doing the test with the underlying assumptions, but need to discuss this as one of your limitations in the overall conclusion. The parameter of interests and populations must be clearly defined. Checking normal distributions by observing histograms. Histograms are obtained from Excel. Excel automatically produce the histogram with gap (default at 150%). You need to reduce the gap to 0% to improve the appearance of the histogram (right click to the histogram, then choose Format Data Series, then reduce the Gap Width to 0%). Students can see the following video recording for creating a histogram in Excel. For each of the tests, you need to state your hypothesis (Hint: The problem re-worded as a Null and Alternate Hypothesis), perform at 3 significance levels(1%, 5% and 10%), and state the decision to reject or accept the null hypothesis at each of the three significance levels. This is a computing assignment. You are expected to use Excel to perform relevant tests (t-test or F-test). Descriptive statistics can also obtained from Excel. o In the report, 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 must be performed for three levels of statistical significance (1%, 5% and 10%). Please condense all the results from testing the three significance levels into one table only. o For t-tests, 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, but not both. o The following tests are not embedded in Excel: testing for the difference between two proportions, and chi-square test. You can use Excel for calculations based on textbook formulae, then find critical values from Appendix A of the textbook