BUS8375 - Research and Data AnalysisAssignment 2 - Quantitative Data AnalysisInstructions:Review the data that has been collected from the Snack Survey ( Attached). Using this data, complete the following:1) Draw a histogram to present the results for the following question "In an average week, how many snacks would you consume in addition to your main meals". Use four (4) equal intervals. (2 pts) Summarize data in the histogram in two or less sentences (i.e. what is the histogram telling us). (1 pts)2) Draw a pie-chart summarizing the "most common reasons you choose to snack". (2 pts) Summarize data in the pie-chart in two or less sentences (i.e. what is the chart telling us). (1 pts)3) Draw a scatterplot showing number of snacks in an average week on the X axis and maximum price per snack on the Y axis. (2 pts) Summarize the data in the scatterplot in two sentences or less (i.e. what is the graph telling us). (1 pts)4) Code the question, "In a typical week, how often do you snack in addition to your main meals?" and calculate the Mode, Median, and Mean for your coded response? (3 pts) What conclusion can we make based on the skewness of this data (1 pts)5) Code the Likert Scale Question "I am snacking on healthier items" and calculate the standard deviation (be sure to show your work). (2 pts) Deliverable:Submit an Excel document with your responses to the above. Please be sure to show detailed calculations. It is recommended to use one worksheet per question.Submit the assignment in the Assignment drop box, before the due date. Submissions more than 5 minutes late will be penalized 10%. Assignments received after one day late will be penalized another 10%. Late submissions will not be accepted after 2 days late.Grading:Grading for this assignment will be based upon:1. Accuracy of your response2. Calculations shown3. Explanation of resultsThe total grade for this assignment is 15 points and the assignment is worth 5% of your final grade.

nalysis Sensitive J19 C I names What Section are you in? What gender do you identify as? In a typical week, how often do you snack in addition to your main meals? John Smith most common reasons you choose to snack Section 01 I am snacking on healthier items price per snack Man Once a day Hunger NO Sarah Jones Section 02 Woman A few days a week Cravings No David Lee Section 01 Man Multiple times a day Boredom No Emily Chen Section 02 Woman Once a week or less Cravings No Michael Kim Section 01 Man Never Cravings Yes Jennifer Ng Section 02 Woman A few days a week Hunger Yes Mark Davis Section 01 Man Multiple times a day Hunger Yes 9 Lily Wong Section 02 Woman Once a day Energy boost Yes 10 Jessica Lin Section 01 Woman A few days a week Socializing Yes 11 William Tan Section 02 Man Once a week or less N/A Yes 12 Karen Lim Section 01 Woman Never N/A No 13 Daniel Lee Section 02 Man Multiple times a day Convenience Yes Once a day Energy boost Yes 14 Rebecca Tan Section 01 Woman 15 Eric Koh Section 02 Man A few days a week Hunger Yes N/A No 16 Michelle Ng Section 01 Woman Once a week or less Multiple times a day Convenience Sometimes 17 Andrew Lim Section 02 Man 18 Amanda Tan Section 01 Woman Never N/A Cravings NO 19 Steven Goh Section 02 Man Once a day A few days a week Socializing, 20 Grace Yap Section 01 Woman N/A No 21 Patrick Lee Section 02 Man Once a week or less Multiple times a day Socializing Yes 22 Ashley Tan Section 01 woman N/A Sometimes 23 Matthew Lim Section 02 Man Never Convenience No A few days a week 24 Vanessa Goh Section 01 Woman Cravings Once a day Section 02 Man N/A No 25 Justin Tan Once a week or less Woman Convenience Sometimes 26 Rachel Lee Section 01 Multiple times a day Man N/A Yes 27 Brandon Lim Section 02 Woman Never Cravings Sometimes 28 Katherine Tan Section 01 A few days a week Convenience NO 29 Jeremy Ng Section 02 Man Yes 30 Stephanie Koh Section 01 Woman Once a day N/A Once a week or less 31 Peter Tan Section 02 Man 32 33 34 + Sheet1 Sheet2 Suggestion 1 Suggestion2