1. Build and/or transform a data set into a usable format for analysis in excel

1. Build and/or transform a data set into a usable format for analysis in excel
2. Use excel to analyze the material using charts, tables and/or pivot tables
3. Must answer the four questions:
a. Build Data Set – describe how you created the data set
b. Data Extraction and Analysis – describe how you extracted the data
c. Data Interpretation – describe what you interpreted from the data
d. Suggested Business Recommendations – make suggestions based on the data
4. Write a report (using Microsoft Word) explaining the information that is presented by your findings (your recommendation). Note, you are not explaining how you created your charts, tables and/or pivot tables. You must explain how your research solves a problem for management and will also add value to the company.
5. Follow APA writing and referencing guidelines (see recommended reading for effective writing in the syllabus)