Analytics Project 3 For this project, you will create a worksheet to analyze the amount of money spent on textbooks by concentration for USCA School of Business students using descriptive statistics in Excel. Feel free to also pull data from non-SOBA students as well. Social media can be a helpful tool when acquiring this data and has been highly effective in prior semesters. File Needed: None Completed Project File Name: [last name first initial] Project 3.xisx Create a new workbook and save it as [last nqme first initial] Project 3. Modify your workbook according to the following guidelines: - Survey a sample of USCA SOBA students (15-30) to determine their concentration, the number of books purchased, and the total amount of money spent on textbooks for the current semester. What population does this sample represent? - Record the number of students surveyed (i.e., 1,2,3, etc.), the major concentration in the SOBA, the number of books purchased and total amount spent on these books in an Excel worksheet. - Make a frequency distribution and histogram. Describe the histogram in terms of skewness and kurtosis. - Calculate the mean, median, and mode. Which is the best measure of center? Why? - Calculate the variance, standard deviation and coefficient of variation. - Standardize the data. Are there any outliers? Make a scatter plot. What does it tell you? - If you had to make recommendations to the university (e.g., the Dean of SOBA and the USCA Chancellor) based on your findings, what would you offer? Your written analysis will be weighed heavily when grading this assignment. - Bonus points: find a student who has done this assignment during a prior semester and compare the prices and quantities. How does this liken to current inflation rates? Analytics Project 3 For this project, you will create a worksheet to analyze the amount of money spent on textbooks by concentration for USCA School of Business students using descriptive statistics in Excel. Feel free to also pull data from non-SOBA students as well. Social media can be a helpful tool when acquiring this data and has been highly effective in prior semesters. File Needed: None Completed Project File Name: [last name first initial] Project 3.xisx Create a new workbook and save it as [last nqme first initial] Project 3. Modify your workbook according to the following guidelines: - Survey a sample of USCA SOBA students (15-30) to determine their concentration, the number of books purchased, and the total amount of money spent on textbooks for the current semester. What population does this sample represent? - Record the number of students surveyed (i.e., 1,2,3, etc.), the major concentration in the SOBA, the number of books purchased and total amount spent on these books in an Excel worksheet. - Make a frequency distribution and histogram. Describe the histogram in terms of skewness and kurtosis. - Calculate the mean, median, and mode. Which is the best measure of center? Why? - Calculate the variance, standard deviation and coefficient of variation. - Standardize the data. Are there any outliers? Make a scatter plot. What does it tell you? - If you had to make recommendations to the university (e.g., the Dean of SOBA and the USCA Chancellor) based on your findings, what would you offer? Your written analysis will be weighed heavily when grading this assignment. - Bonus points: find a student who has done this assignment during a prior semester and compare the prices and quantities. How does this liken to current inflation rates
