Instructor’s Manual Materials to Accompany EXPLORING MICROSOFT® OFFICE 2013, VOLUME 1 EXCEL CHAPTER 8: STATISTICAL FUNCTIONS Available Instructor Resources Resource File Name Found Student Data various Online Instructor Resource Center Solution Files various Online Instructor Resource Center Answer Keys Online Instructor Resource Center Matching e08_answerkey_match Multiple Choice e08_answerkey_mc Concepts Checks e08_answerkey_concepts Scorecards e08b1Tips_scorecard Online Instructor Resource Center Scoring Rubrics e08b1Tips_rubric Online Instructor Resource Center Annotated Solution File e08b1Tips_annsolution Online Instructor Resource Center Scripted Lecture (Script) e08_script Online Instructor Resource Center Scripted Lecture Solution e08_script_solution Scripted Lecture Data e08_script_data PowerPoint Presentation e08_powerpoints Online Instructor Resource Center Testbank e08_testbank Online Instructor Resource Center Instructor's Manual (lesson plans incl.) e08_instructormanual Online Instructor Resource Center Assignment Sheet e08_assignsheet Online Instructor Resource Center Prepared Exam (Chapter & App) Online Instructor Resource Center Prepared Exam-Chap instruction e08_exam_chap_instruction Prepared Exam-Chap solution e08_exam_chap_solution Prepared Exam-Chap Data e08_exam_chap_data Prepared Exam-Chap Annotated Sol. e08_exam_chap_annsolution Prepared Exam-Chap Scorecard e08_exam_chap_scorecard Prepared Exam-App instruction e08_cumexam_instruction Prepared Exam-App solution e08_cumexam_solution
Prepared Exam-App Data e08_cumexam_data Prepared Exam-App Annotated Sol. e08_cumexam_annsolution Prepared Exam-App scorecard e08_cumexam_scorecard File Guide e08_file_guide Online Instructor Resource Center Instructor Resource Card e08_ircard Online Instructor Resource Center Objective Map e08_objectivesmap Online Instructor Resource Center Online Chapter Review e08_chapt_checklist Companion Website for Students Grader Project Grader-instruction e08_grader_instruction Online Instructor Resource Center Grader-solution e08_grader_solution Grader-data e08_grader_data Grader-annoted. Solution e08_grader_annsolution Grader-scorecard e08_grader_scorecard Additional Projects (Practice & Mid Level) Online Instructor Resource Center Additional Proj-Practice instruction e08_p_addproject_instruction Additional Proj- Practice solutions e08_p_addproject_solution Additional Proj-Practice Data e08_p_addproject_data Additional Proj-Practice Ann Sol. e08_p_addproject_annsolution Additional Proj-Practice Scorecard e08_p_addproject_scorecard Additional Proj-Mid Level instruction e08_ml_addproject_instruction Additional Proj-Mid Level solutions e08_ml_addproject_solution Additional Proj-Mid Data e08_ml_addproject_data Additional Proj-Mid Level Ann Sol. e08_ml_addproject_annsolution Additional Proj-Mid Level Scorecard e08_ml_addproject_scorecard CHAPTER OBJECTIVES When students have finished reading this chapter, they will be able to: Use conditional math and statistical functions Calculate relative standing with statistical functions Measure central tendency Load the Analysis ToolPak Perform analysis using the Analysis ToolPak Perform analysis of variance (ANOVA) Calculate COVARIANCE Create a histogram