Spread Sheet Week 3

Week # 3 - Chapter # 2 Assignment

This week we cover the levels 1 and 2 of Chapter Two “Solving Problems with Statistical Analysis Tools” of your textbook. Before you start on the Excel exercises be sure to read and make sure you understand the Chapter Introduction and VERY IMPORTANT, the Case Scenario on page 79. Power Points are available in Blackboard Lectures and, video tutorials guiding you through the Learning part of each level of each chapter are available on youtube.com. See your course Syllabus for the link. WATCH THE VIDEOS-- WATCH THE VIDEOS -- WATCH THE VIDEOS. Use the Chapter # 2 – Videos presentation to see the videos if you prefer. Let's get started: ==========================================================================================

Week # 3 - Chapter # 2 Assignment

Level 1: Objectives • Understand basic concepts related to statistics (Mean, Median, Mode and Standard

Deviation) (page 80 – 84) • Specify the precision of values using the ROUND function (page 84 - 88) • Copy and paste information in a worksheet using Paste Special options (Page 90) • Calculate basic statistics: arithmetic mean, mode, median, standard deviation (page 93 -

94) • Manage large worksheets by freezing panes and splitting the window (page 95 - 100)

Level One: LEARNING

The material covered in Level 1 (pages 80-100) Use Statistical Functions to compare Data Values – Understanding the fundamentals of Statistics. The CH02 Level 1 Figures.xlsx file in Lectures (Student Data Files Chapter Two) replicates all the Figures in this section so you can easily follow along with the textbook discussions You should read learning material on pages 80-100 and the youtube.com video tutorial for this level. Use the attached presentation in Level 1 to see the video Level 1: “Using Statistical Functions to Compare Data Values” Or use the link: https://www.youtube.com/watch?v=pfe5H446_LY&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d&in dex=4 After you, understand the material: Level One: PRACTICE:

Using the Week # 3 - Chapter 2 - Exercises.pdf Make the Exercise Ch2-1: Level 1 – Analyzing Sales for Crèmes Ice Cream

Post your completed file to Blackboard for review and grading. The file Name should be 2-1-Crème-Current-Sales-Analysis-Your-Name.xlsx

POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (40 POINTS)

==================================================================

Week # 3 - Chapter # 2 Assignment

Level 2: Objectives • Use the Quick Analysis tool to aggregate data (page 102 – 105) • Evaluate the rank of each value in a data set (page 105 – 107) • Determine the highest and lowest values in a data set (page 107 – 110) • Determine the number of items that meet specified criteria (page 111 – 116) • Determine a total value for items that meet specified criteria (page 116 – 121)

Level Two: LEARNING The material covered in Level 2: Organizing and Evaluating Different Data Groupings on pages 102 to 121. The CH02 Level 2 Figures.xlsx file in Lectures (Student Data Files Chapter Three) replicates all of the Figures in this section so you can easily follow along with the textbook discussions. You should read the learning material covered on pages 102-121 and the youtube.com video tutorial for this level. Use the attached presentation in Level 2 to see the video Level 2: Organizing and Evaluating Different Data Groupings Or use the link: https://www.youtube.com/watch?v=NJYf4kgRtCY&list=PLnz4OKywJPqsAcTWt_cFbq8pArR8auh8d&in dex=5 After you, understand the material: Level Two: APPLYING

Using the Week # 3 - Chapter 2 - Exercises.pdf Make the Exercise Ch2-2: Level 1 – Level 2- Analyzing Demographic Data for Your Restaurant. Post your completed file to Blackboard for review and grading. The file Name should be 2-2-YourRestaurante-Demog-Analysis-Your-Name.xlsx. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (40 POINTS)

==================================================================

Week # 3 - Chapter # 2 Assignment

Let me know if there is anything you don't understand -- the earlier the better. ALWAYS attach a copy of yours excel file clearly indicating where you have a problem.

The solution files that you need to attach are: 2-1-Crème-Current-Sales-Analysis-Your-Name.xlsx (40 points) 2-2-YourRestaurante-Demog-Analysis-YourName.xlsx (40 points)

After you understand the material and complete the exercises: Answer the questions in the Practical Test – Chapter# 2 (20 POINTS)