Initial Assignment Reference: Professor Robyn Verdery USCA (2018)
BADM298 Business Analytics
Comprehensive Project
The following assignment should be completed for BADM298 in Microsoft Excel and Word 2019. For this project, you will create a database and Excel worksheets to track daily usage of your friend’s smartphone, tablet, or smart watch. In an iPhone, there is an option under Settings, Screen time that does this for you. Some other brands have similar settings.
You will survey at least 20 friends, ten male and ten females, who use an iPhone and report your results using Excel and Word (for any narrative parts). You will ask each friend how much screen time (in hours) was spent on Productivity Sites and Social Networking Sites over the last seven (7) days. Indicate the dates covered and ask all 20 friends regarding the same week.
You will need to record your friend’s names, male or female, amount of time spent on Productivity sites and amount of time spent on Social Networking Sites and the time period covered. Your time should be recorded in hours, not minutes.
Requirements:
Compile your survey results in a table in Excel.
Develop appropriate visual quantitative and/or categorical graphs/charts of your data: bar charts, boxplots, dot plots, pie charts (at least one) and a frequency distribution and histogram for both categories (male and female) in EXCEL.
Develop appropriate descriptive statistics (quantitative analysis) of your data: mean, median, mode, variance, standard deviation, etc., using Excel’s Data Analysis tools.
Identify the center, shape and spread (and outliers, if present) based on previously developed visual graphics or descriptive statistics.
Compile and present all information in a visual form in EXCEL like that of a Dashboard.
Analysis: Write about your conclusions regarding your survey (or a comparison and/or contrast of results). What did you observe? What recommendations could you make? How did you personally compare to the rest of the surveyed individuals?