In: Accounting
This paper aims to test the module ILOs using a practical real-life case-study. In this case study, you are going to play the role of an analyst for one of the corporates, let us call it Company-Z. Therefore, let us first introduce the case-study random variables: is the Company-Z monthly revenue along the period Pre-COVID-19(January 2018 to December 2019); is the same Company-Z monthly revenue but during the period Post-COVID-19(March 2020 to September 2020); is the monthly operations cost during the period Pre-COVID-19(January 2018 to December 2019); while is the same monthly operations cost but during the period Post-COVID-19(March 2020 to September 2020). Accordingly, in your analysis, you will depend on two main random variables over two time series. The first random variable is the Company-Z monthly revenue , and the second random variable is the Company-Z monthly operations cost . The two random variables were chosen over two periods of time: the first is (Pre-COVID-19: January 2018 to December 2019), and the second is (Post-COVID-19: March 2020 to September 2020). Your task is to prepare a comprehensive report to the company, fulfilling specific requirements outlined below in point (3). using this data
Date | Jan/2018 | Feb/2018 | Mar/2018 | Apr/2018 | May/2018 | Jun/2018 | Jul/2018 | Aug/2018 | Sep/2018 | Oct/2018 | Nov/2018 | Dec/2018 | Jan/2019 | Feb/2019 | Mar/2019 | Apr/2019 | May/2019 | Jun/2019 | Jul/2019 | Aug/2019 | Sep/2019 | Oct/2019 | Nov/2019 | Dec/2019 | |
Pre-COVID-19 | Y1 (L.E.) | 4513.8 | 4515.1 | 4514.6 | 4515.7 | 4517.4 | 4513.8 | 4516.0 | 4514.7 | 4516.1 | 4516.6 | 4514.2 | 4515.2 | 4514.2 | 4516.8 | 4514.7 | 4516.2 | 4518.1 | 4517.1 | 4515.5 | 4515.3 | 4517.0 | 4516.1 | 4516.3 | 4515.5 |
X1 (L.E.) | 9.8 | 8.7 | 7.9 | 8.3 | 5.6 | 11.2 | 8.8 | 10.4 | 7.6 | 7.7 | 10.9 | 10.5 | 12.1 | 7.2 | 11.1 | 7.4 | 5.6 | 5.5 | 9.2 | 8.9 | 5.2 | 8.2 | 7.7 | 9.1 | |
Date | Mar/2020 | Apr/2020 | May/2020 | Jun/2020 | Jul/2020 | Aug/2020 | Sep/2020 | ||||||||||||||||||
Post-COVID-19 | Y2 (L.E.) | 2037.5 | 2036.0 | 2049.4 | 2034.7 | 2033.9 | 2037.1 | 2037.4 | |||||||||||||||||
X2 (L.E.) | 7.6 | 13.4 | 6.3 | 10.4 | 12.8 | 9.5 | 6.1 |
What is the appropriate technique to test the following two hypotheses arguing: that the population mean of the monthly operations cost is 0.9 times the value of the average monthly operations cost during the period Pre-COVID-19 , and the population mean of the monthly operations cost is 1.3 times the value of the average monthly operations cost during the period Post-COVID-19 . Write thefull analytical stepsto find the appropriate decision for both hypotheses, as well as comment on the results? use the confidence level 99 percent