AutoSave (O Off ) 14 . () ~ Lab 1 - Hershey Kisses Online (1) - Compatibility Mode - Word Search Mariah England ME X File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Find Arial 14 ~ A A Aav Ap AaBbCcI AaBbC AaBbC AaBbCcI AaBbCc] Gc Replace Paste B IUvab X X A DA Emphasis 1 Heading 1 1 Heading 2 1 Normal Strong Dictate Editor Select Clipboard Font Paragraph Styles Editing Voice Editor Part 1 DATA COLLECTION The following data was collected from 1 bag of Hershey Kisses@. Each Kiss@ was weighed in grams with the 4.56 G wrapper and recorded in the table below. Hershey claims that there are 368 grams of chocolate in one bag. A wrapper weighs 0.1 grams. 4.76, 4.72, 4.74, 4.55, 4.91, 4.74, 4.78, 4.71, 4.80, 4.78, 4.78, 4.75, 4.79, 4.82, 4.91, 4.83, 4.68, 4.74, 4.70, 4.80, 4.70, 4.76, 4.70, 4.83, 4.93, 4.74, 4.84, 4.82, 4.76, 4.77, 4.72, 4.78, 4.83, 4.75, 4.74, 4.68, 4.84, 4.71, 4.71, 4.76, 4.66, 4.78, 4.73, 4.74, 4.92, 4.77, 4.80, 4.79, 4.86, 4.64, 4.78, 4.70, 4.75, 4.78, 4.76, 4.83, 4.66, 4.77, 4.83, 4.78, 4.69, 4.81, 4.68, 4.78. 4.88, 4.72, 4.85, 4.85, 4.81, 4.74, 4.80, 4.82, 4.84, 4.70, 4.85, 4.70, 4.81, 4.72, 4.79, 4.63 To help you answer the questions below, use a graphing calculator or spreadsheet software such as Excel. You will be allowed to use these calculator features during tests. It will be easier to do them in Excel, but you will not be allowed to use Excel during tests. Let your instructor know if you have any questions. Part 2 DATA SUMMARIZATION AND ANALYSIS Using your spreadsheet, answer the following questions: Page 1 of 4 591 words X Text Predictions: On [ Focus + 100% O ? 10:11 AM Type here to search w X 9/3/2021AutoSave (O Off ) 14 . () ~ Lab 1 - Hershey Kisses Online (1) - Compatibility Mode - Word Search Mariah England ME X File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Find Arial 14 ~ A A Aav Ap AaBbCcI AaBbC AaBbC AaBbCcI AaBbCc] Gc Replace Paste B IU vab X X A DA Emphasis 1 Heading 1 1 Heading 2 1 Normal Strong Dictate Editor Select Clipboard Font Paragraph Styles Editing Voice Editor Part 2 DATA SUMMARIZATION AND ANALYSIS Using your spreadsheet, answer the following questions: a) What is the mean and median? (You may want to use your calculator or Excel! In Excel, you can use the average and median functions by first typing "-", the function name, and your data cells in parentheses. For example, if your data are listed in cells A2 through A70, you would type "-average(A2:A70)" to find the mean.) b) What is the range? Are you surprised at this? Why or why not? c) What could be some reasons for variation in the weights of the Kisses? Page 1 of 4 591 words Text Predictions: On [ Focus BE + 100% Type here to search O BOR 9 w ? 10:11 AM X 9/3/2021AutoSave (O Off ) 14 . () ~ Lab 1 - Hershey Kisses Online (1) - Compatibility Mode - Word Search Mariah England ME X File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Find Arial 14 ~ A" A Aav Ap AaBbCcI AaBbC AaBbC AaBbCcI AaBbCc] Gc Replace Paste IUvab X X A LA Emphasis 1 Heading 1 1 Heading 2 1 Normal Strong Dictate Editor B Select Clipboard Font Paragraph Styles Editing Voice Editor d) How many Kisses were there in the bag? e) The total net grams listed on the bag is the amount of candy that Hershey's claims is in the bag. Considering that this mass does not include the weight of the wrappers, approximately how many Kisses too many or too few are there? Give some possible explanations for this difference. Page 2 of 4 591 words Text Predictions: On Focus + 100% 10:11 AM Type here to search W ? x 9/3/2021AutoSave (O Off ) 14 . () ~ Lab 1 - Hershey Kisses Online (1) - Compatibility Mode - Word Search Mariah England ME X File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Find Arial 14 ~ A" A Aav Ap AaBbCcI AaBbC AaBbC AaBbCcI AaBbCc] Gc Replace Paste B IUvab X X A LA Emphasis 1 Heading 1 1 Heading 2 1 Normal Strong Dictate Editor Select Clipboard Font Paragraph Styles Editing Voice Editor Part 3 HISTOGRAM AND 68-95-99.7 RULE Sort your data by selecting the column of data and using the A- Z Sort Ascending command (either directly on the Data menu bar or under the Sort and Filter command on the Home menu bar). f) Construct a histogram for this data. Use at least 5 but no more than 10 bins and be as neat as possible when constructing the histogram (you may use Excel to construct your histogram or do it by hand). Remember to label your axes! When you are finished with your histogram, answer the following questions. g) Would you consider the distribution of the weights to be shaped like a normal distribution? h) In general, what would you say each Kiss approximately weighs? Explain which measure you used and why. Page 2 of 4 591 words Text Predictions: On [ Focus + 100% W ? 10:12 AM Type here to search X 9/3/2021AutoSave (O Off ) 14 . () ~ Lab 1 - Hershey Kisses Online (1) - Compatibility Mode - Word Search Mariah England ME X File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Find Arial 14 ~ A A Aav Ap AaBbCcI AaBbC AaBbC AaBbCcI AaBbCc] Gc Replace Paste B IUvab X X A DAY Emphasis 1 Heading 1 1 Heading 2 1 Normal Strong Dictate Editor Select Clipboard Font Paragraph Styles Editing Voice Editor i) What is the standard deviation for the Kisses data? You can use the stdev.s function in Excel. j) In your data set, how close is the 68-95-99.7 Rule in predicting the percent of values that fall within 1 standard deviation of the mean? ...within two? ... within three? This will require that you actually count the number of Kisses within one standard deviation of your mean and compute the percent for your data. Repeat this for two and three standard deviations. Be sure to show your work! Compare what you observed to the percentage estimated by the 68-95-99.7 Rule by writing a sentence or a few sentences. Page 2 of 4 591 words Text Predictions: On [ Focus + 100% W ? 10:12 AM Type here to search X 9/3/2021