Your electronic files, including both excel and word files, must be submitted. Please use a separateworksheet in excel for each question and label them respectively. Please type the section number ofyour 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 wastaken and the results are summarized as follows:ActivityAttending classSleepingSocializing & recreationStudyingWorking, volunteering, student clubsPercentage (%)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?ii.iii.iv.92451792. 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) forsurvey questions 2 through 10 inclusive.b)Identify the data types of each of the 9 variables as either: categorical, numerical (continuous ordiscrete)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 versusfemales?e) Compare the percentage of males versus the percentage of females with respect to thefollowing characteristics:i.Living (not Living) at Home with parents. Distinguish between the undergrad and graduatestudents as well.The importance associated with the labeling of organic foodsPreference for using Facebook on a Daily BasisCreate 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 concludingstatement with respect to any possible relationships that you see in your scatter plot (i.e., this variableincreases, what does the other variable do? Increase. Decrease, no change (that means norelationship between the variables).13. 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 thecompany. The file contains a number of demographic variables on these customers The data also indicateswhether they have tried the company's newly developed meal. The company wants to understand whysome potential customers tried the new meal and others are not. Does gender make a difference?Does income make a difference? In general, what distinguishes those who tried the new meal from thosewho don't? (hint: use pivot tables to explore these questions)a) Generate pivot table and bar chart to examine the effect of gender. Who do you think ismore likely to try the new meal, males or females?Show the percentages of those who tried and those who don't for males and femalesseparately. Provide a concluding statement.b) Generate pivot table and bar chart to examine the effect of LiveAlone. Who do youthink is more likely to try the new meal, those who live alone or those who don't livealone? Provide a concluding statement.

Question

Your electronic files, including both excel and word files, must be submitted. Please use a separateworksheet in excel for each question and label them respectively. Please type the section number ofyour 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 wastaken and the results are summarized as follows:ActivityAttending classSleepingSocializing & recreationStudyingWorking, volunteering, student clubsPercentage (%)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?ii.iii.iv.92451792. Examine the data in the file &#34;Class survey data.xls&#34; posted in the week 5 of course portal.a) Create a descriptive statistics summary table using Data Analysis Toolpak (Add in for Excel) forsurvey questions 2 through 10 inclusive.b)Identify the data types of each of the 9 variables as either: categorical, numerical (continuous ordiscrete)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 versusfemales?e) Compare the percentage of males versus the percentage of females with respect to thefollowing characteristics:i.Living (not Living) at Home with parents. Distinguish between the undergrad and graduatestudents as well.The importance associated with the labeling of organic foodsPreference for using Facebook on a Daily BasisCreate 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.&#34;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 concludingstatement with respect to any possible relationships that you see in your scatter plot (i.e., this variableincreases, what does the other variable do? Increase. Decrease, no change (that means norelationship between the variables).13. 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 thecompany. The file contains a number of demographic variables on these customers The data also indicateswhether they have tried the company's newly developed meal. The company wants to understand whysome potential customers tried the new meal and others are not. Does gender make a difference?Does income make a difference? In general, what distinguishes those who tried the new meal from thosewho don't? (hint: use pivot tables to explore these questions)a) Generate pivot table and bar chart to examine the effect of gender. Who do you think ismore likely to try the new meal, males or females?Show the percentages of those who tried and those who don't for males and femalesseparately. Provide a concluding statement.b) Generate pivot table and bar chart to examine the effect of LiveAlone. Who do youthink is more likely to try the new meal, those who live alone or those who don't livealone? Provide a concluding statement.

Accepted Answer

“Since you have asked multiple questions, we will solve the first question for you. If you want any…