BADM298 Business Analytics
Comprehensive Project
The following assignment should be completed for BADM298 in Microsoft Excel, Access and Word 2016.
For this project, you create a 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
ands 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 na
ative 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.
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:
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 name_first initial]_CP.accdb (Refer to Module 3 and Excel Project 4-1 for help).
3. Import your ACCESS file into an EXCEL worksheet. Use this worksheet to continue your assignment. Name the file [last name_first initial]_CP.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: Write two pages (double-spaced) summarizing the characteristics of your sample, your conclusions regarding your survey (or a comparison and/or contrast of results). From a manaerial perspective, 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?
Please type any information required and LABEL your work according to the requirements above. All statistical analysis, graphs and charts must be in Excel. Neatness, proofreading and spelling accuracy do matter. All assignment submissions must be done through Blackboard. Assignments must be submitted BEFORE 11:59pm EST on their respective due dates.
Comprehensive Project
Females Males
tc={1F08BEF5-07D3-40ED-8255-E3BB500BB264}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https:
go.microsoft.com/fwlink/?linkid=870924
Comment:
This is for our last project. The directions say ask friends which everyone is free to ask anyone they like, but I thought this might be a quick way for everyone to add their own screen times and have everything gathered in one easy location.
Reply:
Also, feel free to edit these charts! This is very generic and if I missed any data that needs to be included just stick it in there! Briana Productivity
Sites Social
Networking
Sites Pat Productivity
Sites Social
Networking
Sites
1 Monday 0 32 Monday 0 62
Tuesday 2 281 Tuesday 1 10
Wednesday 9 211 Wednesday 5 45
Thursday 0 198 Thursday 20 38
Friday 0 249 Friday 1 15
Saturday 2 266 Saturday 19 36
Sunday 2 308 Sunday 0 32
Females Males
Joy Productivity
Sites Social
Networking
Sites Beckham Productivity
Sites Social
Networking
Sites
2 Monday 40 76 Monday 67 435
Tuesday 26 71 Tuesday 61 240
Wednesday 38 43 Wednesday 61 479
Thursday 9 82 Thursday 29 107
Friday 28 57 Friday 209 67
Saturday 30 118 Saturday 82 240
Sunday 40 117 Sunday 109 122
Females Males
Heather Productivity
Sites Social
Networking
Sites Jalen Productivity
Sites Social
Networking
Sites
3 Monday 27 114 Monday 17 74
Tuesday 21 103 Tuesday 7 62
Wednesday 39 92 Wednesday 16 115
Thursday 41 67 Thursday 105 353
Friday 34 113 Friday 78 293
Saturday 15 116 Saturday 158 422
Sunday 32 114 Sunday 90 6h 37 min
Females Males
Ariana Productivity
Sites Social
Networking
Sites J. Black Productivity
Sites Social
Networking
Sites
4 Monday 5h 10m 0m Monday 58m 1h 13m
Tuesday 0m 23m Tuesday 46m 1h 3m
Wednesday 4h 40m 3m Wednesday 1h 25m 52m
Thursday 2h 35m 2h 28m Thursday 55m 1h 12m
Friday 5h 5m 14m Friday 41m 1h 42m
Saturday 4m 4h 46m Saturday 36m 2h 1m
Sunday 13m 12m Sunday 1h 7m 1h 22m
Females Males
Kayla Productivity
Sites Social
Networking
Sites Michael Productivity
Sites Social
Networking
Sites
5 Monday 0m 3h 8m Monday 42 min 56 min
Tuesday 12m 7h 12m Tuesday 27 min 18 min
Wednesday 0m 2h 11m Wednesday 35 min 1 hr 33 min
Thursday 10m 5h 29m Thursday 1 hr 7 min 2 hr 9 min
Friday 26m 4h 3m Friday 33 min 6 hr 7 min
Saturday 11m 7h 6m Saturday 14 min 42 min
Sunday 18m 1h 31m Sunday 10 min 29 min
Females Males
Ada Productivity
Sites Social
Networking
Sites Brandon Productivity
Sites Social
Networking
Sites
6 Monday 32 1hr 23m Monday 0 5 h
Tuesday 9 2hr 19m Tuesday 0 7 h
Wednesday 0 1hr 13m Wednesday 0 7 h
Thursday 28m 3hr 5m Thursday 0 8 h
Friday 5h 2m 1h 46m Friday 0 5 h
Saturday 30m 2h 45m Saturday 0 6 h
Sunday 1h 25m 3h 5 m Sunday 0 9 h
Females Males
Ca
ie Productivity
Sites Social
Networking
Sites Mike Productivity
Sites Social
Networking
Sites
7 Pr 49m 1hr57m Monday 0 3 hr 4 min
Tuesday 0 1h1m Tuesday 0 1 hr 6 min
Wednesday 11m 1hr23m Wednesday 21 min 4 hr 2 min
Thursday 4hr5m 59m Thursday 0 2 hr 3 min
Friday 3hr38m 32m Friday 0 2 hr 14 min
Saturday 0 1hr57m Saturday 0 2 hr 10 min
Sunday 37 m 3 hr 22 m Sunday 0 1 hr 16 min
Females Males
payton Productivity
Sites Social
Networking
Sites Preston Productivity
Sites Social
Networking
Sites
8 Monday 1 hour 4 hours Monday 27 m 5 hr 30 m
Tuesday 3 hour 1 hour Tuesday 10 m 3 h
Wednesday 30 min 5 hour Wednesday 5 hr 10 m 4 hr 59 m
Thursday 3 hours 3 hours Thursday 5 hr 24 m 3 hr 56 m
Friday 4 hours 45 min Friday 5 hr 51 m 3 hr 4 m
Saturday 0 1 hour Saturday 1 m 2 hr 41 m
Sunday 0 1 hour Sunday 43 m 3 hr 45 m
Females Males
Maggie Productivity
Sites Social
Networking
Sites Travis Productivity
Sites Social
Networking
Sites
9 Monday 1hr 9 min 4 hr 49 min Monday 3m 2h 12m
Tuesday 1 hr 40 min 7 hr 45 min Tuesday 5m 4h 41m
Wednesday 1 hr 7 min 4 hr 48 min Wednesday 2m 4h 8m
Thursday 40 min 9 hr 32 min Thursday 3m 2h 46m
Friday 47 min 4 hr 2 min Friday 7m 1h 57m
Saturday 1 hr 53 min 4 hr 51 min Saturday 4m 43m
Sunday 30 min 1 hr 43 min Sunday 2m 1h 17m
Females Males
Cheyenne Productivity
Sites Social
Networking
Sites Avery Productivity
Sites Social
Networking
Sites
10 Monday 0 min 3 hr 4 min Monday 0m 2h 25m
Tuesday 0 min 3 hr 12 min Tuesday 0m 3h 19m
Wednesday 0 min 1 hr 17 min Wednesday 0m 2h 51m
Thursday 1 hr 10 min 3 hr 55 min Thursday 0m 2h 19m
Friday 0 min 3 hr 55 min Friday 0m 2h 17m
Saturday 0 min 3 hr 25 min Saturday 11m 4h 4m
Sunday 0 min 3 hr 46 min Sunday 0m 2h 51m
BADM298 Business Analytics
Comprehensive Project
The following assignment should be completed for BADM298 in Microsoft Excel, Access and Word 2016.
For this project, you create a 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
ands 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 na
ative 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.
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:
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 name_first initial]_CP.accdb (Refer to Module 3 and Excel Project 4-1 for help).
3. Import your ACCESS file into an EXCEL worksheet. Use this worksheet to continue your assignment. Name the file [last name_first initial]_CP.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: Write two pages (double-spaced) summarizing the characteristics of your sample, your conclusions regarding your survey (or a comparison and/or contrast of results). From a manaerial perspective, 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?
Please type any information required and LABEL your work according to the requirements above. All statistical analysis, graphs and charts must be in Excel. Neatness, proofreading and spelling accuracy do matter. All assignment submissions must be done through Blackboard. Assignments must be submitted BEFORE 11:59pm EST on their respective due dates.
Comprehensive Project
Females Males
tc={1F08BEF5-07D3-40ED-8255-E3BB500BB264}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https:
go.microsoft.com/fwlink/?linkid=870924
Comment:
This is for our last project. The directions say ask friends which everyone is free to ask anyone they like, but I thought this might be a quick way for everyone to add their own screen times and have everything gathered in one easy location.
Reply:
Also, feel free to edit these charts! This is very generic and if I missed any data that needs to be included just stick it in there! Briana Productivity
Sites Social
Networking
Sites Pat Productivity
Sites Social
Networking
Sites
1 Monday 0 32 Monday 0 62
Tuesday 2 281 Tuesday 1 10
Wednesday 9 211 Wednesday 5 45
Thursday 0 198 Thursday 20 38
Friday 0 249 Friday 1 15
Saturday 2 266 Saturday 19 36
Sunday 2 308 Sunday 0 32
Females Males
Joy Productivity
Sites Social
Networking
Sites Beckham Productivity
Sites Social
Networking
Sites
2 Monday 40 76 Monday 67 435
Tuesday 26 71 Tuesday 61 240
Wednesday 38 43 Wednesday 61 479
Thursday 9 82 Thursday 29 107
Friday 28 57 Friday 209 67
Saturday 30 118 Saturday 82 240
Sunday 40 117 Sunday 109 122
Females Males
Heather Productivity
Sites Social
Networking
Sites Jalen Productivity
Sites Social
Networking
Sites
3 Monday 27 114 Monday 17 74
Tuesday 21 103 Tuesday 7 62
Wednesday 39 92 Wednesday 16 115
Thursday 41 67 Thursday 105 353
Friday 34 113 Friday 78 293
Saturday 15 116 Saturday 158 422
Sunday 32 114 Sunday 90 6h 37 min
Females Males
Ariana Productivity
Sites Social
Networking
Sites J. Black Productivity
Sites Social
Networking
Sites
4 Monday 5h 10m 0m Monday 58m 1h 13m
Tuesday 0m 23m Tuesday 46m 1h 3m
Wednesday 4h 40m 3m Wednesday 1h 25m 52m
Thursday 2h 35m 2h 28m Thursday 55m 1h 12m
Friday 5h 5m 14m Friday 41m 1h 42m
Saturday 4m 4h 46m Saturday 36m 2h 1m
Sunday 13m 12m Sunday 1h 7m 1h 22m
Females Males
Kayla Productivity
Sites Social
Networking
Sites Michael Productivity
Sites Social
Networking
Sites
5 Monday 0m 3h 8m Monday 42 min 56 min
Tuesday 12m 7h 12m Tuesday 27 min 18 min
Wednesday 0m 2h 11m Wednesday 35 min 1 hr 33 min
Thursday 10m 5h 29m Thursday 1 hr 7 min 2 hr 9 min
Friday 26m 4h 3m Friday 33 min 6 hr 7 min
Saturday 11m 7h 6m Saturday 14 min 42 min
Sunday 18m 1h 31m Sunday 10 min 29 min
Females Males
Ada Productivity
Sites Social
Networking
Sites Brandon Productivity
Sites Social
Networking
Sites
6 Monday 32 1hr 23m Monday 0 5 h
Tuesday 9 2hr 19m Tuesday 0 7 h
Wednesday 0 1hr 13m Wednesday 0 7 h
Thursday 28m 3hr 5m Thursday 0 8 h
Friday 5h 2m 1h 46m Friday 0 5 h
Saturday 30m 2h 45m Saturday 0 6 h
Sunday 1h 25m 3h 5 m Sunday 0 9 h
Females Males
Ca
ie Productivity
Sites Social
Networking
Sites Mike Productivity
Sites Social
Networking
Sites
7 Pr 49m 1hr57m Monday 0 3 hr 4 min
Tuesday 0 1h1m Tuesday 0 1 hr 6 min
Wednesday 11m 1hr23m Wednesday 21 min 4 hr 2 min
Thursday 4hr5m 59m Thursday 0 2 hr 3 min
Friday 3hr38m 32m Friday 0 2 hr 14 min
Saturday 0 1hr57m Saturday 0 2 hr 10 min
Sunday 37 m 3 hr 22 m Sunday 0 1 hr 16 min
Females Males
payton Productivity
Sites Social
Networking
Sites Preston Productivity
Sites Social
Networking
Sites
8 Monday 1 hour 4 hours Monday 27 m 5 hr 30 m
Tuesday 3 hour 1 hour Tuesday 10 m 3 h
Wednesday 30 min 5 hour Wednesday 5 hr 10 m 4 hr 59 m
Thursday 3 hours 3 hours Thursday 5 hr 24 m 3 hr 56 m
Friday 4 hours 45 min Friday 5 hr 51 m 3 hr 4 m
Saturday 0 1 hour Saturday 1 m 2 hr 41 m
Sunday 0 1 hour Sunday 43 m 3 hr 45 m
Females Males
Maggie Productivity
Sites Social
Networking
Sites Travis Productivity
Sites Social
Networking
Sites
9 Monday 1hr 9 min 4 hr 49 min Monday 3m 2h 12m
Tuesday 1 hr 40 min 7 hr 45 min Tuesday 5m 4h 41m
Wednesday 1 hr 7 min 4 hr 48 min Wednesday 2m 4h 8m
Thursday 40 min 9 hr 32 min Thursday 3m 2h 46m
Friday 47 min 4 hr 2