Description
You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two thousand records of data. Explain how you would use Excel to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations.
Explanation & Answer
Steps are as follows:
1) Converting the data into .csv file and than importing it in excel
2) Creating fields for data as a column
3) Inserting the relevant data against each column
4) Using formulas that are required to find new parameters whose inputs are available as basic data
5) Finding statistical summary and statistical analysis of relevant parameters whose analysis needs to be presented
6) Based on kind of data, drawing one or combination of plots plots such as histograms, pie chart, bar chart, scatter plots, area and others to represent the data and summary.
7) Importing results and plots in word and writing conclusion based on these data in Microsoft Word.
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Aftermath
by Rhidian Brook
The Lost Man
by Jane Harper
The 7 Habits of Highly Effective People
by Stephen R. Covey
Girl Stop Apologizing
by Rachel Hollis
The Call of the Wild
by Jack London
Fools Crow
by James Welch
The Rhythm Section
by Mark Burnell
Persuasion
by Jane Austen
The Trial
by Franz Kafka