Candy Statistics - Principles of Engineering



Activity 4.1.2 Candy StatisticsIntroductionIn this activity you will describe a set of numbers and then make accurate inferences about your group of data based on incomplete information.EquipmentPackage of colored candyExcel? softwareGraduated cylinderProcedurePredict how many individual candy pieces are in your bag. ___150_______Open the candy bag.Sort the candy into categories based upon color.Tabulate and record the amount of candy per color category below. YellowRedBlueBrownGreenOrangeTotal171616181323103What was the difference in the total number you predicted versus the actual number?Fill a graduated cylinder with water to a predetermined amount.Place two individual candy pieces in the graduated cylinder.Measure the displacement in the graduated cylinder.Displacement = __________2__ / 2 = _______1____ volume of one piece of candyCalculate the volume of each candy color category and the package total volume.CandyYellowRedBlueBrownGreenOrangeTotalQuantity171616181323103Volume171616181323103Open an Excel? program and create the spreadsheet shown below. The Trial Number will correspond to the number of trials (student groups) within your class.Enter your candy categorical data into the Trial Number 1 data column. Obtain data from other groups and record the data in additional trial number columns. Calculate the mean value for each color category within the experiment.Select the cell that corresponds with the category Yellow Mean.Select Insert.Select Function.Select Average from the Insert Function dialog box. Select OK. Select the cells that contain the Yellow category data.Select OK.Select the bottom right corner of cell Yellow, Mean and drag to cell Orange, Mean. The mean should now be calculated for all color categories.Calculate the median, mode, and standard deviation for all color categories. Follow procedure steps 13a – 13i. Modify step 13d to select the required function.Calculate the package total using the SUM function.Calculate the package volume by multiplying package total by the volume of one candy. Create a ± 3? histogram for each candy color. Create a frequency distribution table for each candy color as illustrated below. Yellow Candy ? = 1.155BinFrequency (how often the value occurs within the data array)3 ?Mean + (3 ? )9.79832 ?Mean + (2 ? )8.64331 ?Mean + (1 ? )7.4883Mean6.3333-1 ?Mean - (1 ? ) 5.1783-2 ?Mean - (2 ? )4.0233-3 ?Mean - (3 ? ) 2.8683Create a histogram for each candy color using your bin and frequency data.ConclusionWhich color is most likely to occur with the same frequency in each bag? Explain your answer.Do your histograms fit a classic bell curve? Why or why not?Use the information that you developed in the lab, combine it with any additional information that you think you might need, and calculate the number of candies it would take to fill your classroom. Explain your answer mathematically. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download