Business bis 155 help

User Generated

gnavn

Business Finance

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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.


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags