please solve the Case study and prepare a short report (up to two pages, including tables and graphs) which describes the obtained results, provides answers to the questions and interpretations. Please send the report (possible formats: doc, docx,) together with the solutions in the Excel file.
all requrement are lsited in the attached files belwo.