• Study Chapter 1 and Appendix A1 of Basic Excel Skills before starting this assignment
• PLE case study provides a great exercise to simulate your business analytics skills in reality. It is not uncommon (actually always!) for the analysts to review more data than actually needed to perform problem-solving. However, after recognizing, defining, and structuring the problems, analysts would develop a better idea of what data to use/ not to use. Therefore, it is the analysts' responsibility to decide what data may/may not be useful. While, the attached spreadsheet file has multiple sheets, not all of them are useful to do the preliminary analysis asked by your supervisor, Elizabeth Burke (read the textbook for more details, Page 31-32). In your coherent report, you would justify the reasons for choosing the raw data and present the results in a readable manner. Your spreadsheet file should speak for itself as it contains formulas in each cell.

To submit:

Show your analyses in the attached excel shell file and summarize the analyses in a coherent written report (word file). Attach both for submission to receive full points.

Name your submissions: Lastname_Firstname_Ch01_PLE.xlsx and Lastname_Firstname_Ch01_PLE.docx