Standard Course Week 4 Working with Graphs Charts, Histograms, Errors in Graphing Horizontal bar charts; Pie charts. Designing and using histograms. Misleading graphs: Disparate magnitudes; Truncating the ordinate; Highlighting non-random sections. LEARNING OBJECTIVES FOR THIS WEEK Distinguish between cases suitable for horizontal bar charts vs vertical column charts Create bar and column charts using WORD & EXCEL Identify requirements for valid pie charts Create pie charts Create clustered and stacked bar charts Manage figure & table numbers in WORD Edit graphics in EXCEL Create frequency distributions and histograms using EXCEL Choose a reasonable number of X-axis values for charts Cope with disparate quantities Use logarithmic scales on the ordinate where appropriate Avoid truncating the ordinate Avoid selecting non-random sections of a data series Edit Students can manually mark this item complete: LEARNING OBJECTIVES FOR THIS WEEKDistinguish betwe... THIS WEEK'S TEXTBOOK CHAPTER Edit Students can manually mark this item complete: THIS WEEK'S TEXTBOOK CHAPTER Statistics Text Chapter 4 -- Charts, histograms, errors URL Edit title Edit Students can manually mark this item complete: Statistics Text Chapter 4 -- Charts, histograms, errors Guidelines on using charts effectively File Edit title Edit Students can manually mark this item complete: Guidelines on using charts effectively Extracts from Chapter 4 in a PDF file & a PPTX version. DISCUSSIONS Edit Students can manually mark this item complete: DISCUSSIONS Week 4 Discussions Forum Edit title Edit Visible groups (Click to change) Students can manually mark this item complete: Week 4 Discussions Answer questions and post interesting materials here. REVIEW Edit Students can manually mark this item complete: REVIEW Data visualization -- PowerPoint File Edit title Edit Students can manually mark this item complete: Data visualization -- PowerPoint Excellent guide by Prof Jolley on effective use of graphical representations in business. Data visualization -- PowerPoint as PDF File Edit title Edit Students can manually mark this item complete: Data visualization -- PowerPoint as PDF qm213_wk04_review_questions.pdf File Edit title Edit Students can manually mark this item complete: qm213_wk04_review_questions.pdf Week 4 review questions to prepare for your quiz on histograms. Excel 2010 Statistics #15: Frequency Distributions, Histograms URL Edit title Edit Students can manually mark this item complete: Excel 2010 Statistics #15: Frequency Distributions, Histograms HOMEWORK ASSIGNMENTS Edit Students can manually mark this item complete: HOMEWORK ASSIGNMENTS qm213_homework_wk04_part_1.xlsx File Edit title Edit Students can manually mark this item complete: qm213_homework_wk04_part_1.xlsx Lots of practice in creating histograms using Data Analysis | Histogram function qm213_homework_wk04_part_2.pdf File Edit title Edit Students can manually mark this item complete: qm213_homework_wk04_part_2.pdf Yet more practice with histograms and graphs. qm213_homework_wk04_part_2_hints.xlsx File Edit title Edit Students can manually mark this item complete: qm213_homework_wk04_part_2_hints.xlsx In case you're stumped. qm213_homework_wk04_part_3.xlsx File Edit title Edit Students can manually mark this item complete: qm213_homework_wk04_part_3.xlsx Practice making various graphs including scattergrams. HOMEWORK UPLOADS There is no automated grading of homework this week because it's too difficult to create questions referring to graphs. Instead, you will upload all your completed homework files for credit. Edit Students can manually mark this item complete: HOMEWORK UPLOADS There is no automated grading of... hu04 Assignment Edit title Edit Separate groups (Click to change) Students can manually mark this item complete: hu04 UPLOAD YOUR COMPLETED WEEK 4 EXERCISES FILES HERE qm213_homework_... wk04_part_1.xlsx wk04_part_2.docx wk04_part_3.xlsx Do NOT upload archive (ZIP, RAR, etc.) files because they force the prof to open them to extract the files. QUIZ Edit Students can manually mark this item complete: QUIZ q04 Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: q04 Graphs. 25 questions, 50 minutes, 1 try. q04a Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: q04a q04r Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: q04r 35 questions, 35 minutes, 1 try. You must complete q04 before taking q04r. q04ar Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: q04ar EXTRA-CREDIT WORK Edit Students can manually mark this item complete: EXTRA-CREDIT WORK AAUP salary statistics for Vermont File Edit title Edit Students can manually mark this item complete: AAUP salary statistics for Vermont From American Association of University Professors 2012-3 Report. Can be used for extra credit by making graphs of interesting aspects of the data. q04x-p1 Assignment Edit title Edit Visible groups (Click to change) Students can manually mark this item complete: q04x-p1 Upload < AAUP salary statistics for Vermont File > extra-credit work (one file). Real-estate newsletter File Edit title Edit Students can manually mark this item complete: Real-estate newsletter Example of how graphs are used in the real world. For extra credit, you can try creating variations on the graphs using the data shown in the newsletter. Would be interesting to analyze the effects of different arrangements of the data (e.g., stacked vs clustered bars). q04x-p2 Assignment Edit title Edit Visible groups (Click to change) Students can manually mark this item complete: q04x-p2 Upload < Real-estate letter > extra-credit work (one file).