Business bis 155 help

Business & Finance
Tutor: None Selected Time limit: 1 Day

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.

Apr 23rd, 2015

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.

Apr 23rd, 2015

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Apr 23rd, 2015
...
Apr 23rd, 2015
Dec 4th, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer