Forthis assignment you have been provided several files for your analysis. Missinginformation or information that may not seem to make sense is a normaloccurrence with this type of investigation.

Case Scenario:

The company has raisedconcerns that someone is manipulating sales data. The company’s gross profit isdropping, and they cannot explain how this is possible as there has been no reductionin pricing and cost of sales have remained stable.

Assignment Tasks:

1.       For this assignment you areexpected to provide a presentation that:

      Uses the advanced excel techniques explained up to module 7 anddescribe the analysis you performed

      Identify any unusual, suspect or outliers that you notice based onyour analysis

      Describe any follow-up you would perform

      The assignment requires you to use Excel properly to perform avariety of analysis noted in this course make sure in your excel workbook youclearly identify the analysis performed and your presentation has to stand onits own and should not refer back to the excel workbook. For example, if youwish to add a table to your presentation do not just add a reference to theexcel workbook. 

2.      Using the knowledge you gained up to module 7:

a.      You will need to make assumptions about the data and state such inyour report. Make whatever assumptions you feel is necessary andstate such in your report. However, your assumptions must have some basis inreality.

b.      You are required to use ALL the tests explained in lessonmaterials thus far in the course materials excluding risk scoring, however youcan use any additional analysis techniques that you are familiar with, but allmust be completed within excel.

c.      You are required to submit your Excel workbook of the workcompleted along with a written report explaining your findings. You can chooseto use Word or PowerPoint for the presentation of your findings.

      Analysis work in Excel

Presentationof your findings in Word or PowerPoint