Course Hero Logo

Qualitative charts can be displayed both horizontally

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 11 - 14 out of 94 pages.

Qualitative charts can be displayed both horizontally and verticallyQualitative charts display categorical dataHistograms use bar charts that are separated for discrete data or joinedtogether for continuous dataHorizontal Bar Chart– display the bars in a horizontal directionRight click bar chart andChange Chartto horizontal bar chartCustomize options to include titles and remove legendClustered Bar Chart– charts that group several values side by side within thesame category in a vertical directionTEAMPOINTS SCORED20092010Green Bay Packers461388Minnesota Vikings470281Chicago Bears327334Detroit Lions2623621. Insert Data into chart form, like the one shown aboveHighlight data (teams, years, and scores)Insertand thenChartand thenClustered ColumnCustomize to include vertical, horizontal, and top titlesStacked Bar Chart– a chart that groups several values in a single column withinthe same category in a vertical directionCompare same team in two yearsSame instructions as clustered bar chart, but choose diff chart typeWhen to Choose a Clustered OR Stacked?Depends on purpose of chartClustered = comparing data within categoriesStacked = displaying totals in each categoryPareto ChartsPareto Charts– bar charts that show the frequency of the categories that causequality control problemsShow categories in a decreasing order-Most problematic categories shown firstPlot cumulative relative frequency as a line on the chart (ogive)Histograms that show (in decreasing order) the frequency of the
categories that cause problemsExample: QVC records customer reasons for product returnsREASON FOR RETURNFREQUENCYProduct Defective46Disappointed with Product22Product no longer wanted14Late delivery of product5Other3Calculate Relative / Cumulative FrequenciesConstructing your Pareto ChartHighlight A1:A6CTRL and highlight C1:C6 (relative frequency)CTRL and highlight D1:D6 (cumulative frequencyInsertCombo Chartand make sure CUMULATIVE data is the line andRELATIVE data is the barMake sure max of vertical axis is 1.0Select major unit of axis to be 0.2 (not 0.1)Select Number > Category > Percentage > change 2 to 0 in the DecimalPlaces boxAdd Data LabelsPie ChartsPie Charts– an excellent tool for comparing proportions for categorical data;each category occupies a segment of the pie that represents the relativefrequency of that categoryExample: Number of computers shipped in US during 2009COMPANUNITSSHIPPEDHP4228Dell3996Acer2076Apple1135Toshiba1005Others2837
Constructing a Pie ChartHighlight cells with data (including titles)InsertandPie Chartand make sure picking 2-D optionMake sure percentages (with only one decimal point) are inside the piepieces (auto-fill in Google Docs)Some notes on pie chartsAll categories in the data set MUST be included in the pie-

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 94 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Donnelly

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture