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) 6. The word document (paper) and all items (excel spreadsheets, power-point slides, etc.)
admin
1 min read
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) 6. The word document (paper) and all items (excel spreadsheets, power-point slides, etc.)
