Please Help me with my assignment. I just need answers from 10-13. Thank you so much! Refer to Global Financial Performance Dataset which reports financial information on 148 global companies with 12 variables.

Answer the following questions:

10.

A. Conduct a test of hypothesis to determine whether the mean number of employees was different from 70 (thousands)? Use the 0.05 significance level. Show the working using the 6-step procedure of hypothesis testing.

B. Conduct a test of hypothesis to determine whether the mean total taxes is greater than $1 million dollars (or $1000 (in thousands of dollars. Use the 0.05 significance level.Show the working using the 6-step procedure of hypothesis testing.

Step 1: Statement of hypothesis:H₀: H_a:

Step 2: Seta=0.05 (decide whether 1-tail test or 2- tail test)

Step 3: Compute test statistic: Choose the correct test statistic.

Since is unknown, we use ???

Step 4: Establish CV: Refer to corresponding table. Decide the correct table.

Step 5: Decision: Reject H₀or Do not reject H₀

Step 6: Interpret:

11.

A. At the 0.05 significance level, can we conclude that there is a difference in the mean net income for the Telecommunication Services economic sector versus the Financials economic sector? Use the 6-step procedure of hypothesis testing to arrive to the conclusion.

B. At the 0.01 significance level, can we conclude that there is a difference in the mean net income for the Information Technology economic sector versus the Energy economic sector? Use the 6-step procedure of hypothesis testing to arrive to the conclusion.

12. Conduct ANOVA test of hypothesis to determine if there a difference in the mean net income of the following economic sectors: Health Care, Consumer Staples and Consumer Discretionary? Use the 0.01 significance level.

13. Create a classification variable that divides the corporations into two classes based on Gross Profit Margin.

Firms with Gross Profit Margin less than 40% are in the "low" group and coded as "0".

Firms with Gross Profit Margin greater than 40% are in the "high" group and coded as "1".

Then develop a contingency table between Economic Sector and Gross Profit Margin class.

As appeared in the Excel file, there are nine economic sectors, namely:

1. Telecommunication Services
2. Materials
3. Information Technology
4. Industrials
5. Health Care
6. Financials
7. Energy
8. Consumer Staples
9. Consumer Discretionary

At the 0.05 level of significance can we conclude that there is a relationship between Economic Sector and Gross Profit Margin?

Shareable link for the dataset: https://docs.google.com/spreadsheets/d/1bkP5JkjbSwnja9GUvBszYf2F-tqrZn8V/edit?usp=sharing&ouid=104917483027341106157&rtpof=true&sd=true It would be wonderful if you could share your sheet too after solving this so that I can study how were you able to do it. Thank you so much!