BUS8375 - Research and Data Analysis

Assignment 2 (In-Class) - Quantitative Data Analysis

Instructions:

Review the data that has been collected from the Snack Survey that was run in class. Using this data, complete the following:

1. For the question "In an average week, how many snacks would you consume in addition to your main meals":
   1. Create a frequency distribution table using four (4) equal intervals (1 pts)
   2. Draw a histogram to present the results from your table (3 pts)
   3. Summarize the data in the histogram in two or less sentences (i.e. what is the histogram telling us?). (1 pts).

1. Draw a pie-chart summarizing the "most common reasons you choose to snack". (3 pts) Summarize data in the pie-chart in two or less sentences (i.e. what is the chart telling us). (1 pts)

1. Draw a scatterplot showing number of snacks in an average week on the X axis and maximum price per snack on the Y axis. (3 pts) Summarize the data in the scatterplot in two sentences or less (i.e. what is the graph telling us).

1. Code the question, "I feel less guilty about snacking". Calculate the Mode, Median, and Mean for your coded response.

1. 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?"
2. Manually calculate the standard deviation in excel (be sure to show your work).
3. 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.
4. 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?

What Section a . What gender div How often do you In an average we Think about the. Which of the fo . I am snacking c. I feel more guil . I eat more salty. I am snacking c. I eat more swee. I feel less guilt. If you were to p Agree Strongly Disagree 5 Section 10 5 I am hungry or thirsty Disagree Disagree Chips Agree Agree Male Once a day 3 Out of boredom:Snac Neutral Disagree Neutral Agree Agree Disagree Pizza 0 Section 10 Female Once a day Neutral Agree Strongly Agree Neutral Vadapay It is a typical Indian snack Disagree 2 Section 10 Male A few days a week 15 I crave sweet snacks; Agree Doughnuts 13 Section 10 5 I am hungry or thirsty Neutral Strongly Disagree Neutral Neutral Disagree Mal Once a week or less Neutral 15 I need energy:Snack: Strongly Agree Strongly Disagree Strongly Disagree Strongly Disagree Neutral Strongly Disagree Subway Toasted Bread with vegetables 36 Section 21 Male Once a week or less 20 I am hungry or thirsty Disagree Neutral Strongly Agree Agree Neutral Agree Chips 3 Section 10 Male A few days a week Muffin A few days a week 10 It is a habit of mine: Neutral Disagree Disagree Strongly Disagree Disagree Neutral 7 Section 10 Male 20 I am hungry or thirsty Strongly Disagree Neutral Disagree Neutral Strongly Disagree Strongly Disagree Timbits 4 Section 10 Female Multiple times a day Strongly Disagree Agree Strongly Agree Agree Samosa 5 Section 10 Male Multiple times a day 20 I crave sweet snacks; Agree Strongly Disagree Disagree Strongly Disagree Strongly Disagree Strongly Disagree Apples 10 I need energy:Snack: Strongly Agree Strongly Disagree 26 Section 21 Female A few days a week Disagree Disagree Neutral Neutral Sandwich Disagree 27 Section 21 Male Once a week or less 10 I am hungry or thirsty Agree 0 It is a habit of mine;S Neutral Disagree Agree Neutral Disagree Agree Chips 40 Section 21 Male Once a day Disagree Neutral Strongly Disagree Strongly Disagree Agree Pop corn 15 Section 21 Female Once a week or less 6 I am hungry or thirsty Agree Neutral Agree Agree Disagree Neutral Chicken Burger 8 Section 10 Female A few days a week 21 I am hungry or thirsty Disagree Strongly Disagree Strongly Disagree Disagree Strongly Disagree Strongly Agree Lays 20 Section 10 Female A few days a week 11 I am hungry or thirsty Disagree Strongly Disagree Strongly Disagree Strongly Disagree Strongly Disagree Strongly Agree Biscuits 30 Section 21 Male A few days a week 3 Out of boredom; Strongly Agree Neutral Neutral Neutra Neutral Neutra Pizza 35 Section 21 Male A few days a week 15 I am hungry or thirsty Neutral 10 Out of boredom;Snac Neutral Disagree Agree Neutral Disagree Neutral Chips 1 Section 10 Female Once a day Disagree Disagree Chips 9 Section 10 Male Once a day 0 I crave sweet snacks; Neutral Neutral Agree Agree Strongly Disagree Neutral Strongly Disagree Strongly Disagree Strongly Disagree Chocolate 24 Section 21 Male Multiple times a day 3 It is a habit of mined . Strongly Disagree Neutral Neutral Disagree _ay's Disagree Neutral 47 Section 21 Male A few days a week 10 I crave sweet snacks; Agree Neutral Neutral Strongly Disagree Pizza F G O O O J J O O O) C C C J C C 0 8 A A A WW WW NNNN NNNN_ Strongly Disagree Neutral 6 Section 10 Female Once a day 0 I crave sweet snacks; Neutra Agre Agree Agree Agree Agree Nutella 7 Section 10 Male Multiple times a day 5 I need energy:Snack: Agree Pretzels 10 I am hungry or thirsty Strongly Disagree Neutral Agree Strongly Agree Disagree Strongly Agree 22 Section 10 Male Once a day Neutral Chips 29 Section 21 Female Multiple times a day 15 Snacks are easily avi Neutral Neutral Neutral Neutral Neutral Strongly Agree Chips 39 Section 21 Female Once a day 20 I crave sweet snacks; Strongly Agree Strongly Disagree Strongly Disagree Disagree Strongly Agree Agree Neutral Agree Neutral Strongly Disagree Pastries 41 Section 21 Female Once a day 15 I need energy| am hu Disagree Strongly Disagree Strongly Disagree Strongly Disagree Strongly Disagree Samosas 42 Section 21 Female Once a day 5 I need energy:Snack: Neutral Disagree Strongly Disagree Female 20 I crave sweet snacks; Disagree Strongly Agree Neutral Agree Strongly Agree Pizza 2 Section 10 Multiple times a day Disagree Agree Agree Neutral Agree Toasted begal with hash brown 8 Section 10 vale Once a day 6 I am hungry or thirsty Disagree Neutral Neutra Disagree Agree Peanut butter sandwich Disagree 9 Section 10 Male Once a day 3 Snacks are easily avi Agree Neutra Disagree Disagree Cheetos 11 Section 10 Male Once a day 10 Snacks are easily aw Disagree Strongly Disagree Disagree Agre Agre Neutral Strongly Disagree Neutral Potato chips 34 Section 21 Male Once a day 51 I am hungry or thirsty Neutral Strongly Agree Neutral Neutral Neutral Disagree Cookies 43 Section 21 Male Once a day 8 I am hungry or thirsty Agree Disagree Neutral 16 Section 10 Once a day 11 I am hungry or thirsty Agree Neutral Neutral Disagree Namkin Indian snack Female French Fries 20 Snacks are easily avi Neutral Agree Neutral Disagree Agree Disagree 21 Section 10 Male Once a day Strongly Agree Disagree Disagree Neutral Disagree Popcorn, Candies, Biscuits 38 Section 21 Female Multiple times a day 30 I crave sweet snacks; Neutral 50 I crave sweet snacks; Strongly Agree Disagree Strongly Disagree Strongly Disagree Neutral Strongly Agree Khakra 32 Section 21 Female Multiple times a day Neutral Neutral Chip 4 Section 10 Female Once a day 30 Out of boredom; Neutral Neutral Neutral Neutral Strongly Disagree Biscuit 44 Section 21 Female Multiple times a day 14 15 I crave sweet snacks; Strongly Agree Disagree Neutral Strongly Disagree Strongly Disagree 20 12 I need energy! am hu Neutral Neutra Agree Neutral Jeutral Neutral Snack healthy bars 46 Section 21 Female Multiple times a day khakra poha Multiple times a day 30 60 I am hungry or thirsty Neutral Disagree Disagree Neutral Neutral Neutral 37 Section 21 Female 23 Section 21 Male Never 25 Section 21 Female Never 28 Section 21 Male Never 31 Section 21 Male Never 33 Section 21 Male Never