Assume this data set you are analyzing represents a sample of the GBM/SGBM student population. For the question "What would you say, on average, is the total amount you spend on snacks for a week?"

1. Manually calculate the standard deviation in excel (be sure to show your work).
2. Assume we had a normal distribution for the data we were looking at in Question 5. Between what range (CAD $) would you expect to find 68% of the data.
3. If the data we were looking at in Question 5 represented the population instead of a sample, would you expect the standard deviation to be higher or lower than what was calculated? Why?

AutoSave @ off H ? = Snack Preference Survey-data - Protected View - Excel Search PARMINDER JEET SINGH PJ G - X File Home Insert Page Layout Formulas Data Review View Automate Help Acrobat Comments Share PROTECTED VIEW This file couldn't be verified by Microsoft Defender Advanced Threat Protection. Unless you need to edit, it is safer to stay in protected view. Enable Editing X E40 vi X fx 14 B C D G H M N P Q R S T U V What Section are your What gender do you How often do you s | In an average week .I Think about the typ Which of the follow |I am snacking on hey I feel more guilty al . I eat more salty sna I am snacking on les I eat more sweet sn I feel less guilty abov If you were to pick 5 Section 15 Man Once a day 5 I am hungry or thirsty;I Disagree Agree Agree Agree Strongly Disagree Disagree Chips 0 Section 15 Woman Once a day 3 Out of boredom;Snack Neutra Disagree Neutral Agree Agree Disagree Pizza 12 Section 15 Man A few days a week 15 I crave sweet snacks;I I Agree Disagree Neutral Agree Strongly Agree Neutral Vadapav It is a typical Indian snack 13 Section 15 Man Once a week or less 5 I am hungry or thirsty; Neutra Neutral Strongly Disagree Neutral Neutral Disagree Doughnuts 3 Section 15 Man A few days a week 20 I am hungry or thirsty; Disagree Neutral Strongly Agree Agree Neutral Agree Chips 7 Section 15 Man A few days a week 10 It is a habit of mine; Neutral Disagree Disagree Strongly Disagree Disagree Neutral Muffin 4 Section 15 Woman Multiple times a day 20 I am hungry or thirsty;I Strongly Disagree Neutral Disagree Neutral Strongly Disagree Strongly Disagree Timbits 5 Section 15 Man Multiple times a day 20 I crave sweet snacks; It Agree Strongly Disagree Strongly Disagree Agree Strongly Agree Agree Samosa 8 Section 15 Woman few days a week 21 I am hungry or thirsty;: Disagree Neutral Agree Agree Disagree Neutral Chicken Burger 16 0 Section 15 Woman A few days a week 11 I am hungry or thirsty;: Disagree Strongly Disagree Strongly Disagree Disagree Strongly Disagree Strongly Agree Lays 19 1 Section 15 Woman Once a day 10 Out of boredom;Snack Neutral Disagree Agree Neutral Disagree Neutral Chips 9 Section 15 Man Once a day 10 I crave sweet snacks; Neutra Disagree Neutral Agree Agree Disagree Chips DO. CO V A T Q UI UI UI A A W W N N N N HK 6 Section 15 Woman Once a day 10 I crave sweet snacks; It Neutra Strongly Disagree Neutral leutral Neutral Strongly Disagree Pizza 17 Section 15 Man Multiple times a day 5 I need energy;Snacks & Agree Agree Agree Agree Agree Agree Nutella 2 Section 15 Man Once a day 40 I am hungry or thirsty;I Strongly Disagree Neutral Agree Strongly Agree Disagree Strongly Agree Pretzels 2 Section 15 Woman Multiple times a day 20 I crave sweet snacks; O Disagree Strongly Agree Neutral Agree Strongly Agree Strongly Disagree Pizza 18 Section 15 Man Once a day 6 1 am hungry or thirsty;I Disagree Disagree Agree Agree Neutral Agree Toasted begal with hash brown 19 Section 15 Man Once a day 3 Snacks are easily avail: Agree Disagree Neutral Neutral Disagree Agree Peanut butter sandwich 11 Section 15 Man Once a day 10 Snacks are easily avail: Disagree Strongly Disagree Disagree Neutral Disagree Disagree Cheetos 16 Section 15 Woman Once a day 1 I am hungry or thirsty;| Agree Neutral Disagree Neutral Disagree Neutral Namkin Indian snack 21 Section 15 Man Once a day 20 Snacks are easily avail: Neutra Agree Neutral Disagree Agree Disagree French Fries 4 Section 15 Woman Once a day 30 Out of boredom; Neutral Neutral Neutral Neutral Neutral Neutral Chips Data Ready + 100% 22.C Mostly cloudy Q Search HOW X 11:59 AM 2023-08-05