Your electronic files, including both excel and word files, must be submitted. Please use a separate worksheet in excel for each question and label them respectively. Please type the section number of your class, name and ID of the team members on the file. 1. Researchers wanted to understand college students' usage of time. A formal survey of 3,000 students was taken and the results are summarized as follows: Activity Attending class Sleeping Socializing & recreation Studying Working, volunteering, student clubs a) Construct a bar chart, a pie chart, and a Pareto chart. b) What conclusions can you reach concerning what college students do with their time? Percentage (%) 2. Examine the data in the file "Class survey data.xls" posted in the week 5 of course portal. a) Create a descriptive statistics summary table using Data Analysis Toolpak (Add in for Excel) for survey questions 2 through 10 inclusive. b) Identify the data types of each of the 9 variables as either: categorical, numerical (continuous or discrete) c) Apply empirical rule to the feet size variable using the descriptive statistics summary table. Show your calculations and interpret your results. d) Compare males and females with respect to height: What is the mean height of males versus females? ii. 9 24 51 7 9 e) Compare the percentage of males versus the percentage of females with respect to the following characteristics: i. iv. Living (not Living) at Home with parents. Distinguish between the undergrad and graduate students as well. The importance associated with the labeling of organic foods Preference for using Facebook on a Daily Basis Create a table to compare the average # of sleep Hrs/night between gender. For each table created, provide a concluding statement with respect to the information it provides. Eg. "the above table shows that X% of females live at home whereas Y% of males not live at home. f) Create a properly labeled scatter plot between any two appropriate variables. Provide a concluding statement with respect to any possible relationships that you see in your scatter plot (i.e., this variable increases, what does the other variable do? Increase. Decrease, no change (that means no relationship between the variables). 1 3. A food processing company has developed a new ready-made meal for dinner. The file NewMealTriers.xls (posted in the week 5 of course portal) contains data on the potential customers being tracked by the company. The file contains a number of demographic variables on these customers The data also indicates