Software Apps Project

The two types of charts I have chosen for this discussion are the histogram and the pivot chart.

The histogram charting function in excel is a numerical type of chart that shows a graphic explanation of statistical data. It is a bar graph of purely raw data that gives us a visual image of the data distribution. There are differences between histograms and standard bar graphs. Standard bar graphs can be rearranged in descending order, where a histogram cannot. A histogram must be presented in the order that the periods occur. The histogram is one of the seven basic tools of quality control. This type of chart would be used to show the overall factors involved in a production environment. Quality control places importance on three key areas: elements (job management, processes, identification of records), competence (knowledge, skills, experience, qualifications), and soft elements (personnel, integrity, confidence, motivation). If you would like step by step instructions on creating a histogram, click the link below.

http://support.microsoft.com/kb/214269

A pivot table is a way for us to summarize large amounts of data. This type of chart is useful for us to see the large amount of data in several user-friendly ways. A pivot table is helpful for us to summarize data by different categories and even subcategories where we can create custom calculations and formulas. We can also filter, sort and also group subsets of data to help us to center in on the information that we want to present. A pivot table can bring forth the analysis of related totals. This is helpful when you have a long list of figures to add and you want to compare different facts about each figure. Simply put, pivot tables are used to summarize, analyze, explore and present data. One of the great features of a pivot table is that you can explore them. An example of when a pivot table would be used would be to summarize sales records where the information was pulled from a database....