(1) What is the population Researcher A is interested in?
(2) Identify the names
(1) What is the population Researcher A is interested in?
(2) Identify the names and types of variables in the dataset.
(3) Use Microsoft Excel to conduct and present the appropriate graphic and descriiptive results on each of the following variables: Industry, Revenue, and Direct GHG Emissions, interpret and analyze these descriiptive results, and prepare a summary report
(4) Suppose Researcher A also conducted the same research in 2019, the proportion of companies that answered CDP questionnaire was 0.72 in 2019. The researcher would like to know if this proportion of companies answering CDP questionnaire has increased. You are required to:
Establish the null and alternative hypotheses
Identify the appropriate test
Produce the test results using Microsoft Excel
Write a short report based on your analysis of results
(5) Suppose Researcher A also conducted the same research in 2019, and found that the average return on assets (ROA) was 0.06 in 2019. The researcher would like to know whether the average ROA has changed. You are required to:
Establish the null and alternative hypotheses
Identify the appropriate test
Produce the test results using Microsoft Excel
Write a short report based on your analysis of results
(6) Suppose Researcher A wants to examine whether the average profitability (measured as ROA) of Industry 1 is significantly different from that of Industry 2. The researcher conducted analysis based on a sample of companies from Industry 1 and Industry 2 in the data file.
(Note: You need to replace Industry 1 and Industry 2 with real Industry first, for example, Communication Services and Energy).
You are required to:
Identify population(s) Researcher A is interested in
Based on the above subsample you selected, produce results using Microsoft Excel, conduct your analyses following detailed steps for HYPOTHESIS TESTING AND ESTIMATION method and summarize your results in a report. That is, you need to establish null and alternative hypotheses, identify the appropriate tests, produce results, interpret and analyse your results based on appropriate statistics, and prepare a short report on them.
