Give a brief introduction of the firm provided, including basic background information and issues…
As abusiness analyst, you work in a large personal care company Boween Pty Ltd. You are required to conduct a research and write a report to your departmentsupervisor. You report needs to include the following focus: 1) Give a brief introduction of the firm provided, including basic background information and issues to address. 2) How much sales do you expect to generate in the overseas market in the 2nd quarter of 2020based on the least squares line? In your work, you need to include your excel calculation for covariance, correlation coefficient between selling expense and sales as well as a plotted scatter diagram. Briefly comment on the relationship between selling expense and sales. 3) The company wants to find out whether the consumer will consume more than 7bottles of liquid hand wash in the next quarter. Identify an appropriate statistical test and hypothesis, carrying out your analysis using a significance level of ? =0.05.Show details of your work. 4) Provide a sales forecast report for 2nd half of 2020 based on your analysis from the data provided and your revised estimate of the probabilities of each scenario that is based on the new market information.
Attachments: