Reference no: EM133025283

BADM299 Business Analytics

Comprehensive Project 

The following assignment should be completed for BADM299 in Microsoft Excel, Access and Word 2016.

For this project, you createa database and 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 twenty friends, ten male and ten female, who use an iPhone and report your results using Access, 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 7 days. Indicate the dates covered and ask all twenty friends about the same 7 days. This has been done for you. See the CPSP.xlsx file on the on the Survey Results Tab.

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. This has been done for you. See the CPSP.xlsx file on the on the Survey Results Tab.

Requirements:

1. Give a description of your sample - how they were chosen, who (no names, just what group or groups they were from, i.e., classmates, teammates, etc.). From what population?

2. Compile your survey results in a table in ACCESS. Name the file [last namefirst initial]_CPSP20.accdb (Refer to Module 3 and Excel Project 4-1 [Project Four] for help).

3. Import your ACCESS file into an EXCEL worksheet. Use this worksheet to continue your assignment. Name the file [last namefirst initial]_CPSP20.xlsx (Refer to Module 1 and 2 Excel Projects for help).  

4. 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.

5. Develop appropriate Descriptive Statistics (quantitative analysis) of your data: mean, median, mode, variance, standard deviation, etc., using Excel's Data Analysis tools. 

6. Identify the center, shape and spread (and outliers, if present) based on previously developed visual graphics or descriptive statistics.

7. Compile and Present all information in a visual form in EXCEL like that of a Dashboard. 

8. SUMMARY: Writea short paragraph summarizing the characteristics of your sample, your conclusions regarding your survey (or a comparison and/or contrast of results). What did you find out? What conclusions can you make? Who would find this information useful? How would you relate this project and the tasks required to Business Analytics?  

Gender F M F M F M M F M M M F F F F M M M F F

Time on Productivity 13 12.75 10.5 10.25 10 10 9 5.75 5.75 5 4.5 3.75 3.5 3 2.75 2.5 2.5 2.25 1 1

Time on Social Media 4.5 8.5 21.75 1.75 7 2 20 8.75 9 5.5 24.25 14 14.75 5.25 20.25 3.75 28 13.25 7 7.5

Total Screen Time 38.75 21.25 46.75 12 21 12 29 27 24 10.5 45.25 40.5 49.75 24 30.5 16.5 45 20.75 15 13.25

Z-score productivity

Z-score social media