AU23 Project 2

docx

School

Baruch College, CUNY *

*We aren’t endorsed by this school

Course

105

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

docx

Pages

4

Uploaded by RISQUEDELI

Report
Project 2 Lillian Delgado For all problems, show your calculations or your work in Excel and explain your thinking. There is a video included in this week’s learning which can be used to help with your calculations. 1. A college professor distributed a bag of M&Ms to each student in their class. Your bag is shown below. a) Calculate the percentage of each color and show your calculations in the table. Write your answer as a decimal and round to 3 decimal places. (Example: 7/33 = 0.212 is how that should look). To calculate the percentage, I used the following formula: - (frequency of given color/Total frequency) × 100 5+6+7+8+10+18 = 54 Color Percentage Brown (5/54) x 100= 9.259% Red (6/54) x 100= 11.111% Blue (7/54) x 100= 12.983% Green (8/54) x 100 = 14.815% Yellow: (10/54) x 100 = 18.519% Orange (18/54) x 100 = 33.333% The professor asked students to submit their M&M totals in a class poll. The data is below. Note: 6 students who were in class did not submit their totals in time to be counted (maybe they were busy eating the M&Ms). b) Calculate the mean and median for the total M&Ms using the 20 numbers above. Show your calculations or add a screenshot of your work in Excel. 50+55+53+55+51.5+49+51+51+51+52+54+47.5+50+53= 723 Mean 724 14 Mean equals = 51.64 The mean number of M&Ms would be the sum of all the M&Ms divided by the total number of students: =723 = (6x50) = 1,023 Therefore, the mean number of M&Ms would increase from 51.64 to 51.15 Color Percentage Brown 9.259% Red 11.111% Blue 12.983% Green 14.815% Yellow 18.519% Orange 33.333% 50 55 53 55 51.5 49 51 51 51 52 54 47.5 50 53 0 0 0 0 0 0
Project 2 c) First, we need to calculate the total number of M&Ms for all the students, excluding those who didn't submit their total: Please see question number one. d) Which measure for the average should the professor use to describe the average number of M&Ms? Why? the median only considers the middle value(s) of a dataset and is not affected by the values of the other data points. 51.55 e) Suppose the 6 students who didn’t submit their total in class all had 50 M&Ms in their bag. How would that change the mean number of M&Ms? How would that change the median number of M&Ms? Write a sentence to explain your thinking. If the 6 students who didn't submit their total in class had 50 M&Ms in their bag, the mean number of M&Ms would change as follows: 50+55+53+55+51.5+49+51+51+51+52+54+47.5+50+53= 723 Mean 724 14 Mean equals = 51.64 The mean number of M&Ms would be the sum of all the M&Ms divided by the total number of students: 723 = (6x50) = 1,023 Therefore, the mean number of M&Ms would increase from 51.64 to 51.15 The median number of M&Ms, however, would remain the same because the middle value is still 51.5, even if we assume that the missing students all had 50 M&Ms. This is because the median only considers the middle value(s) of a dataset and is not affected by the values of the other data points. In addition to collecting total numbers, the professor collected counts for each color. The totals are below. Show your calculations for each color in the table, rounded to 3 decimal places. Qty 86 Brown Qty 88 Red Qty 286 Blue Qty 137 Green Qty 106 Yellow Qty 320 Orange (86/54) x 100 = 159.259% f) Compare the percentages from your bag to the percentages for the entire class. What changes do you notice? Which colors stayed the most consistent? Brown: Class 9.259% vs. Bag 159.259% Color Percentage Brown 159.259% Red 162.963% Blue 529.630% Green 253.704% Yellow 196.296% Orange 592.593%
Project 2 Red: Class 11.111% vs. Bag 162.963% Blue: Class 12.983% vs. Bag 529.630% Green: Class 14.815% vs. Bag 253.704% Yellow: Class 18.519% vs. Bag 196.296% Orange: Class 33.333% vs. Bag 592.593% The bag has higher percentages for Brown and Red compared to the class, significantly lower percentages for Blue and Orange, and relatively closer percentages for Green and Yellow. Orange stayed the most consistent with the class percentages. The bag shows notable variations in color distribution compared to the entire class. Brown and Red percentages are higher in your bag, while blue and orange percentages are significantly lower. Green and Yellow are closer to the class percentages. Overall, Orange remains the most consistent color between your bag and the class distribution. g) A 5-pound bulk bag of M&Ms holds approximately 2700 pieces. How many of each color should we expect to find in the bag based on the results of the percentages from the entire class? Show your calculations for each color in the table and round to 3 decimal places. Brown: (9.259% of 2700 M&Ms) ≈ (0.09259 * 2700) ≈ 249.933 M&Ms Red: (11.111% of 2700 M&Ms) ≈ (0.11111 * 2700) ≈ 300.033 M&Ms Blue: (12.983% of 2700 M&Ms) ≈ (0.12983 * 2700) ≈ 350.391 M&Ms Green: (14.815% of 2700 M&Ms) ≈ (0.14815 * 2700) ≈ 400.005 M&Ms Yellow: (18.519% of 2700 M&Ms) ≈ (0.18519 * 2700) ≈ 500.463 M&Ms Orange:(33.333% of 2700 M&Ms) ≈ (0.33333 * 2700) ≈ 900.009 M&Ms Color Approximate Number of M&Ms Brown 250 Red 300 Blue 350 Green 400 Yellow 500 Orange 900
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Project 2 If you counted 32 orange M&Ms in a sample from the bag, you could estimate the total number of M&Ms in the entire bag based on the proportion of orange M&Ms in your sample. h) Suppose a bag of M&Ms is dumped on the table and you count 32 orange pieces. Approximately how many M&Ms do you expect to be in the entire bag based on the percentages of the entire class? Write a sentence to explain your thinking and your calculations. Calculation: 0.011852 (proportion) * 2700 M&Ms (the total number of M&Ms in the bag), which gives you an estimated total of approximately 31.989 M&Ms. Proportion of orange M&Ms in your sample: (32 orange M&Ms / 2700 M&Ms) ≈ 0.011852. This proportion represents the fraction of the bag that your sample represents. The percentages of M&M colors from the class and the fact that you found 32 orange M&Ms in your sample, you can estimate that there are approximately 31.989 M&Ms in the entire 5-pound bag. This estimation is based on the proportion of orange M&Ms in your sample and the class percentages for the various M&M colors. Based on the class percentages and counting 32 orange M&Ms in a sample, we would expect approximately 31.989 M&Ms in the entire 5-pound bag. Estimated total number of M&Ms = 0.011852 x 2,700 M&Ms = 31.989 M&Ms. So, based on the percentages of the entire class and the 32 orange M&Ms in your sample, you would expect approximately 31.989 M&Ms in the entire 5-pound bag