Excel provides many different ways in which to analyze data. Discuss the differe
ID: 3662912 • Letter: E
Question
Excel provides many different ways in which to analyze data. Discuss the different methods by which you can analyze data in your spreadsheet. That is, try an Internet search for "data analysis with excel" or use some of the methods you learned in this week's lesson. P.S. Please don't use the same methods. Show your research and creativity skills.
Assume the role of a regional manager for a retail organization looking at ways to analyze the large amounts of sales data you have. Give some examples.
how will you determine where to start and what tools can you use within Excel to help you organize everything and make decisions?
Explanation / Answer
After reading so many things and my personal experince with excel sheet i have listed mayjarly about pivot table and charts for analysing large amount of sales data..
The pivot table is one of the single most powerful tools in the Excel repertoire. It is frequently used for large data analysis.
You can use the pivot table as an interactive data summarisation tool to automatically condense large datasets into a separate, concise table.
You can use it to create an informative summary of a large dataset or make regional comparisons between brand sales.
Pivot tables do not have to be intimidating – far from it – and we are here to help you unlock one of the real hidden power tools of Excel.
To demonstrate the power of pivot tables, we will be using the UK Government dataset 2013 UK Fleet Landings by ICES Rectangle which can be
downloaded via the linked page, if you want to play along at home.
Filtering Your Data
Feel free at this point to play around with the different fields, learn which varieties of data produce concise correlation,
which data fields need tweaking to reveal their secrets and to comprehend the value actions of filter settings.
Size Matters
For this example, we used a small proportion of a relatively large dataset. Pivot tables work best when they have several thousand individual records, multiple data fields and a range of duplicate numerical figures. That is not to say their relevance is strictly associated with large datasets but, when dealing with a massive amount of raw data, nothing can beat the pivot table in ease of use, data filtering or its concise summarising facilities.
Basics of PivotTables
PivotTables allow you to consolidate large amounts of data with similar fields and analyze the
consolidated data or just summarize the consolidated data. The PivotTable tool in Excel gives you an easy
way to create a PivotTable for your data. Please note that the data must have at least 1 field in common
otherwise, the consolidation will not work and spelling errors in the data will produce incorrect
PivotTables.
Basics of Charts
Charts are used to graphically represent data. The PivotChart tool in Excel provides a simple way to
create a PivotTable and an accompanying chart. Remember, a chart is only as good as the data or the
summary table (PivotTable). If you try to cram too many fields into a chart, you will end up with a noninformative
chart. You want to keep it simple and informative.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.