Module 1 Activities-F2F PDF

Module 1-Terminology and Graphing Part 1: Terminology of Statistics & Excel Basics 1. Do the following exercises collaboratively with up to five people per group. Access for free at: https://openstax.org/books/introductory-statistics/pages/1-1-definitions-of-statistics-probability- and-key-terms...

Module 1-Terminology and Graphing Part 1: Terminology of Statistics & Excel Basics 1. Do the following exercises collaboratively with up to five people per group. Access for free at: https://openstax.org/books/introductory-statistics/pages/1-1-definitions-of-statistics-probability- and-key-terms You want to determine the average (mean) number of glasses of milk college students drink per day. Suppose yesterday, in your English class, you asked five students how many glasses of milk they drank the day before. The answers were 1, 0, 1, 3, and 4 glasses of milk. State the a) Population College students b) Sample Five college students asked c) Parameter Average number of glasses of milk drank per day by all college students d) Statistic Average number of glasses of milk drank by the five students e) Variable Number of glasses of milk drank f) Data 1, 0, 1, 3, 4 1 2. You are interested in determining the average (mean) number of times individuals over the age of 25 check their phones per day. While at the Apple store, you survey 35 people on how often they look at their phone per day. The mean number of times reported was 22. State the a) Population Individuals over the age of 25 b) Sample The 35 people surveyed c) Parameter Average number of times individuals over the age of 25 look at their phones d) Statistic Average of 22 times e) Variable Times looked at phone Part 2: Graphing and Excel Before beginning this part, you will want to download the Excel calculator from the course homepage. 1. Given the following data (Exam 1 data): 36, 46, 47, 51, 63, 66, 70, 71, 75, 76, 81, 84, 86, 91, 95, 96, 96, 97, 98, 98, 99, 100, 100 a. Find the class width using 5 classes: 13 b. Fill in the frequency table below: Bin Class Limits Class Midp Freque Cumulativ Relative Rel Boundaries oint ncy e Freq Freq Cumul Freq 1 36 48 35,5 48,5 42 3 3 13,04% 13,04% 2 49 61 48,5 61,5 55 1 4 4,35% 17,39% 3 62 74 61,5 74,5 68 4 8 17,39% 34,78% 4 75 87 74,5 87,5 81 5 13 21,74% 56,52% 5 88 100 87,5 100,5 94 10 23 43,48% 100,00% 2  c. Graph the histogram below (be sure to label everything). Frequency Histogram 7 6 5 4 3 2 1 0 53 62 71 80 89 98 d. Graph the Ogive below (be sure to label each data point). Ogive 25 20 15 10 5 0 48,5 57,5 66,5 75,5 84,5 93,5 102,5 3  2. Repeat the process in #1 for the Exam 2 Data: 49, 51, 51, 53, 54, 58, 59, 62, 63, 64, 66, 69, 73, 75, 82, 82, 83, 85, 86, 93, 94, 98, 99. a. Find the class width using 6 classes: 9 b. Fill in the frequency table below Bin Class Limits Class Midp Freque Cumulativ Relative Rel Boundaries oint ncy e Freq Freq Cumul Freq 1 49 57 48,5 57,5 53 5 5 21,74% 21,74% 2 58 66 57,5 66,5 62 6 11 26,09% 47,83% 3 67 75 66,5 75,5 71 3 14 13,04% 60,87% 4 76 84 75,5 84,5 80 3 17 13,04% 73,91% 5 85 93 84,5 93,5 89 3 20 13,04% 86,96% 6 94 102 93,5 102,5 98 3 23 13,04% 100,00% c. Graph the histogram below (be sure to label everything). Frequency Histogram 7 6 5 4 3 2 1 0 53 62 71 80 89 98 4  d. Graph the Ogive below (be sure to label each data point). Ogive 25 20 15 10 5 0 48,5 57,5 66,5 75,5 84,5 93,5 102,5 3. Graphing Time Series. a. Using the Tesla Stock Data provided, graph a time series of Tesla Close prices from 7/1/10 to 7/1/20. Time Series 1200 1000 800 600 400 200 0 1/7/10 1/12/10 1/5/11 1/10/11 1/3/12 1/8/12 1/1/13 1/6/13 1/11/13 1/4/14 1/9/14 1/2/15 1/7/15 1/12/15 1/5/16 1/10/16 1/3/17 1/8/17 1/1/18 1/6/18 1/11/18 1/4/19 1/9/19 1/2/20 1/7/20 5  b. Using the Tesla Stock Data provided, graph a time series of Tesla High prices from 7/1/2010 to 7/1/2020 Time Series 1200 1000 800 600 400 200 0 1/7/10 1/12/10 1/5/11 1/10/11 1/3/12 1/8/12 1/1/13 1/6/13 1/11/13 1/4/14 1/9/14 1/2/15 1/7/15 1/12/15 1/5/16 1/10/16 1/3/17 1/8/17 1/1/18 1/6/18 1/11/18 1/4/19 1/9/19 1/2/20 1/7/20 i. Students often confuse time series and ogive graphs. How do these differ? A time series graph shows how data values change over time, with time on the x-axis and data values on the y-axis. An ogive graph displays cumulative frequencies, with data values on the x-axis and cumulative frequencies on the y-axis. 4. Stem and leaf plots: a. Using the Module 1 data set for the age at inauguration of US presidents, generate a stem and leaf plot with the following key: 4 | 2 = 42 Stem Leaf 4 2367899 5 01111124444555566677778 6 011124589 6  b. Using the Module 1 data set for the age at death of US presidents, generate a stem and leaf plot with the following key: 4 | 2 = 42 Stem Leaf 4 69 5 36678 6 003344567778 7 01112347889 8 01358 9 0033 5. Graphing Qualitative Data: a. Using the Module 1 data set for the Favorite Ice Cream flavors, graph a Pareto graph of this data: Bar Graph 70 60 50 40 30 20 10 0 Chocolate Strawberry Cookies and Cream Butter Pecan Vanilla i. How does the Pareto graph differ from a Bar graph? A Pareto graph is a specialized bar graph where categories are arranged in descending order of frequency or importance, often with a cumulative line to show the "80/20 rule," while a bar graph can display categories in any order and doesn't include a cumulative line. ii. What are the benefits of using a Pareto graph vs. a Bar graph? A Pareto graph highlights the most significant categories and their cumulative impact, making it easier to prioritize issues or focus areas, whereas a bar graph provides a straightforward comparison of categories without emphasizing order or cumulative effects. 7  b. Using the Module 1 data set for the Favorite Ice Cream flavors, graph a Circle graph of this data. Circle Graph Chocolate Strawberry Cookies and Cream Butter Pecan Vanilla c. When would you not want to use a circle graph to represent data? You would not want to use a circle graph (pie chart) when the data includes too many categories, has overlapping values, or requires precise comparisons. 8