Reference no: EM133137730
DATA PREPARATION- RELATED TO ASSIGNMENT
In the assignment
Question 1. first you need to collect columns from other excel sheets/documents. There is a huge data folder in teams page you can use those or there are millions of excel data in web.
Question 2. Then you need to create a business application case (you can find the examples PART III of the text book). To do this you will create at least 3 excel sheets in an excel file. (Think that " Excel hands on .." excel file as an example, one file many sheets)
Question 3. You need to change the header and give name related to the business case / scenario.rhis scenario or case will be probably fictive if you are not working in a data centric role now.
Question 4. Then you will prepare the data for next steps (modelinS read this we blog as an example of this discipline)
Question 5. You will write a word doc that describes your business case, your headers in excel sheets, your sheets, for me. Assume me that I am head of your data analysis department and you are sending analysis file (in excel- ifile -with sheets) and a business report. So you have to send the final-clean form of everthing.
Question 6. In your analysis if you use T-tests, data transformation, any other plot describe them briefly (short) just give the references (APA style)
Attachment:- DATA PREPARATION.rar