| 1) | Comparing the colors of jelly beans in two bags: |
| a) Purchase two small bags of jelly beans with assorted colors: one bag of a big brand/name brand (Jelly Belly, Lifesavers, etc.) and one bag of a store brand/off brand (America's Choice, CVS Gold Emblem, etc.). | |
| b) [10 pts.] Create two summary tables, one for each bag. The summary table must include three columns: color, number of jelly beans (of that color), and percent. | |
| c) [10 pts.] Create two Pareto charts, one for each bag. | |
| d) [10 pts.] Create a contingency table based on row percentages with two rows (one for each brand) and three columns (red, green, other). | |
| e) [10 pts.] Create a side-by-side bar chart using the data from the contingency tables. | |
| f) [10 pts.] Write 1-2 paragraphs that summarize your findings. | |
| 2) | Using Microsoft Excel in Statistics: |
| a) Install PHStat2 on the computer you will be using for this assignment. | |
| b) Read pages 16-20 to familiarize yourself with basic commands in Microsoft Excel. If you have limited experience using Excel, you may want to read these pages with a computer in front of you, so you can practice as you read. | |
| c) [25 pts.] Exercise 2.89 (on page 69) - Use the PHStat sections on pages 74-82 to learn how various tables and graphs are created in Excel. | |
| d) [25 pts.] Exercise 3.67 (on page 132) - Use the In-Depth Excel and PHStat2 sections on pages 135-139 to learn how to compute the various quantities in Excel. | |
| 3) | Statistics on the Job: |
| a) [2 pts.] Collect data (about 8 to 15 numbers) on a numerical variable of interest in your workplace. Write the numbers in the data set, say what the data refers to (i.e. vacation days for each employee, calories for each menu item, etc.), and say if it is sample data or population data. | |
| b) [10 pts.] Create a frequency distribution with columns for frequency, percentage, cumulative frequency, and cumulative percentage. | |
| c) [10 pts.] Create a histogram of your choice (frequency, percentage, or cumulative) and a polygon of your choice (frequency, percentage, or cumulative). | |
| d) [8 pts.] Find the mean and median. Is your data symmetric, left-skewed, or right-skewed? Explain in a full sentence. | |
| e) [10 pts.] Find the variance, standard deviation, and coefficient of variation. | |
| f) [10 pts.] Write 1-2 paragraphs that summarize your findings. |
Last Modified: 7/27/13