Data Cleansing and Data Summary

Details:

Now that you have identified the business problem, translated it intoan analytics problem, identified the data needs, and acquired thedata, you will use data that you have found or with the company'spermission you can use its data for analysis to resolve the analyticsproblem. Using one or more of the following software applications (IBMSPSS Modeler, SPSS Statistics, Excel, Tableau, or R), analyze the dataso that the findings can be used to address the established businessproblem in your company.

Write a 750-1,000 word paper that includes the following informationfor your data (ensure that specific screenshots of graphs, tables,etc., are provided):

Conduct an exploratory data analysis: What information is containedin the data set?

Describe key features of the data and any significant relationshipsyou find.

1. How did you verify that the data was reliable beforeproceeding?
2. What problems did you find and how did youaddress them?
3. What relationships did you find in thedata?
4. Any missing data?
5. Analyze trends with respectto any appropriate characteristics that you may havediscovered.

Supplement your description with appropriate charts/figures. Datacan be (but are not necessarily limited to) the following:

1. Line graphs
2. Pie charts
3. Bar charts
4. Scatter plots

Indicate the steps you have taken to investigate the quality of thedata and indicate any variables you have transformed or discarded as a result.

1. Provide a summary that provides a detailed overview of thetrends identified based upon the analysis.
2. Segment the dataaccordingly, if needed, to help describe the data behavior.

How are you going to summarize data samples?

1. Provide a detailed statistical summary of all informationprovided.
2. Provide the raw software files that you used forthis assignment. If R was used, provide a *.txt file of all thecommands used.

Prepare this assignment according to the guidelines found in the APAStyle Guide, located in the Student Success Center. An abstract is not required.

This assignment uses a rubric. Please review the rubric prior tobeginning the assignment to become familiar with the expectations forsuccessful completion.

Model Building

Details:

You will need to build a model that will solve the problem that youhave identified. Use one or more of the following softwareapplications: IBM SPSS Modeler, SPSS Statistics, Excel, Tableau, or R.

Write a 500-750 word paper describing your model. It will includethe following:

1. What models did you build?
2. Why did you choose thismodel(s)? Be sure that this model specifically ties back to thebusiness problem you created for the Topic 1 assignment.
3. What variables did you include or leave out and why?
4. Provide specific screenshots from the modeling software in yourpaper.

Provide the raw software files that you used for this assignment(IBM SPSS Modeler, SPSS Statistics, Excel, Tableau, or R). If R wasused, provide a *.txt file of all the commands used.

Prepare this assignment according to the guidelines found in the APAStyle Guide, located in the Student Success Center. An abstract is not required.

This assignment uses a rubric. Please review the rubric prior tobeginning the assignment to become familiar with the expectations forsuccessful completion.