Assignment Attached
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 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. 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 FemalesMales 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!BrianaProductivity SitesSocial Networking SitesPatProductivity SitesSocial Networking Sites 1Monday032Monday062 Tuesday2281Tuesday110 Wednesday9211Wednesday545 Thursday0198Thursday2038 Friday0249Friday115 Saturday2266Saturday1936 Sunday2308Sunday032 FemalesMales JoyProductivity SitesSocial Networking SitesBeckhamProductivity SitesSocial Networking Sites 2Monday4076Monday67435 Tuesday2671Tuesday61240 Wednesday3843Wednesday61479 Thursday982Thursday29107 Friday2857Friday20967 Saturday30118Saturday82240 Sunday40117Sunday109122 FemalesMales HeatherProductivity SitesSocial Networking SitesJalenProductivity SitesSocial Networking Sites 3Monday27114Monday1774 Tuesday21103Tuesday762 Wednesday3992Wednesday16115 Thursday4167Thursday105353 Friday34113Friday78293 Saturday15116Saturday158422 Sunday32114Sunday906h 37 min FemalesMales ArianaProductivity SitesSocial Networking SitesJ. BlackProductivity SitesSocial Networking Sites 4Monday5h 10m0mMonday58m1h 13m Tuesday0m 23mTuesday46m1h 3m Wednesday4h 40m 3m Wednesday1h 25m52m Thursday2h 35m 2h 28mThursday55m1h 12m Friday5h 5m14mFriday41m1h 42m Saturday4m4h 46mSaturday36m2h 1m Sunday13m12mSunday1h 7m1h 22m FemalesMales KaylaProductivity SitesSocial Networking SitesMichaelProductivity SitesSocial Networking Sites 5Monday0m3h 8mMonday42 min56 min Tuesday12m7h 12mTuesday27 min18 min Wednesday0m2h 11mWednesday35 min1 hr 33 min Thursday10m5h 29mThursday1 hr 7 min2 hr 9 min Friday26m4h 3mFriday33 min6 hr 7 min Saturday11m7h 6mSaturday14 min42 min Sunday18m1h 31mSunday10 min29 min FemalesMales AdaProductivity SitesSocial Networking SitesBrandonProductivity SitesSocial Networking Sites 6Monday321hr 23mMonday05 hr Tuesday92hr 19mTuesday07 hr Wednesday01hr 13mWednesday07 hr Thursday28m3hr 5mThursday08 hr Friday5h 2m1h 46mFriday05 hr Saturday30m2h 45mSaturday06 hr Sunday1h 25m3h 5 mSunday09 hr FemalesMales CarrieProductivity SitesSocial Networking SitesMikeProductivity SitesSocial Networking Sites 7Pr49m1hr57mMonday03 hr 4 min Tuesday01h1mTuesday01 hr 6 min Wednesday11m1hr23mWednesday21 min4 hr 2 min Thursday4hr5m59mThursday02 hr 3 min Friday3hr38m32mFriday02 hr 14 min Saturday01hr57mSaturday02 hr 10 min Sunday37 m3 hr 22 m Sunday01 hr 16 min FemalesMales paytonProductivity SitesSocial Networking SitesPrestonProductivity SitesSocial Networking Sites 8Monday1 hour 4 hoursMonday27 m5 hr 30 m Tuesday3 hour1 hourTuesday10 m3 hr Wednesday30 min5 hourWednesday5 hr 10 m4 hr 59 m Thursday3 hours3 hoursThursday5 hr 24 m3 hr 56 m Friday4 hours45 minFriday5 hr 51 m3 hr 4 m Saturday01 hourSaturday1 m2 hr 41 m Sunday01 hourSunday43 m3 hr 45 m FemalesMales MaggieProductivity SitesSocial Networking SitesTravisProductivity SitesSocial Networking Sites 9Monday1hr 9 min4 hr 49 minMonday3m2h 12m Tuesday1 hr 40 min7 hr 45 minTuesday5m4h 41m Wednesday1 hr 7 min4 hr 48 minWednesday2m4h 8m Thursday40 min9 hr 32 minThursday3m2h 46m Friday47 min4 hr 2 minFriday7m1h 57m Saturday1 hr 53 min4 hr 51 minSaturday4m43m Sunday30 min1 hr 43 minSunday2m1h 17m FemalesMales CheyenneProductivity SitesSocial Networking SitesAveryProductivity SitesSocial Networking Sites 10Monday0 min3 hr 4 minMonday0m2h 25m Tuesday0 min3 hr 12 minTuesday0m3h 19m Wednesday0 min1 hr 17 minWednesday0m2h 51m Thursday1 hr 10 min3 hr 55 minThursday0m2h 19m Friday0 min3 hr 55 minFriday0m2h 17m Saturday0 min3 hr 25 minSaturday11m4h 4m Sunday0 min3 hr 46 minSunday0m2h 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 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. 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 FemalesMales 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!BrianaProductivity SitesSocial Networking SitesPatProductivity SitesSocial Networking Sites 1Monday032Monday062 Tuesday2281Tuesday110 Wednesday9211Wednesday545 Thursday0198Thursday2038 Friday0249Friday115 Saturday2266Saturday1936 Sunday2308Sunday032 FemalesMales JoyProductivity SitesSocial Networking SitesBeckhamProductivity SitesSocial Networking Sites 2Monday4076Monday67435 Tuesday2671Tuesday61240 Wednesday3843Wednesday61479 Thursday982Thursday29107 Friday2857Friday20967 Saturday30118Saturday82240 Sunday40117Sunday109122 FemalesMales HeatherProductivity SitesSocial Networking SitesJalenProductivity SitesSocial Networking Sites 3Monday27114Monday1774 Tuesday21103Tuesday762 Wednesday3992Wednesday16115 Thursday4167Thursday105353 Friday34113Friday78293 Saturday15116Saturday158422 Sunday32114Sunday906h 37 min FemalesMales ArianaProductivity SitesSocial Networking SitesJ. BlackProductivity SitesSocial Networking Sites 4Monday5h 10m0mMonday58m1h 13m Tuesday0m 23mTuesday46m1h 3m Wednesday4h 40m 3m Wednesday1h 25m52m Thursday2h 35m 2h 28mThursday55m1h 12m Friday5h 5m14mFriday41m1h 42m Saturday4m4h 46mSaturday36m2h 1m Sunday13m12mSunday1h 7m1h 22m FemalesMales KaylaProductivity SitesSocial Networking SitesMichaelProductivity SitesSocial Networking Sites 5Monday0m3h 8mMonday42 min56 min Tuesday12m7h 12mTuesday27 min18 min Wednesday0m2h 11mWednesday35 min1 hr 33 min Thursday10m5h 29mThursday1 hr 7 min2 hr 9 min Friday26m4h 3mFriday33 min6 hr 7 min Saturday11m7h 6mSaturday14 min42 min Sunday18m1h 31mSunday10 min29 min FemalesMales AdaProductivity SitesSocial Networking SitesBrandonProductivity SitesSocial Networking Sites 6Monday321hr 23mMonday05 hr Tuesday92hr 19mTuesday07 hr Wednesday01hr 13mWednesday07 hr Thursday28m3hr 5mThursday08 hr Friday5h 2m1h 46mFriday05 hr Saturday30m2h 45mSaturday06 hr Sunday1h 25m3h 5 mSunday09 hr FemalesMales CarrieProductivity SitesSocial Networking SitesMikeProductivity SitesSocial Networking Sites 7Pr49m1hr57mMonday03 hr 4 min Tuesday01h1mTuesday01 hr 6 min Wednesday11m1hr23mWednesday21 min4 hr 2 min Thursday4hr5m59mThursday02 hr 3 min Friday3hr38m32mFriday02 hr 14 min Saturday01hr57mSaturday02 hr 10 min Sunday37 m3 hr 22 m Sunday01 hr 16 min FemalesMales paytonProductivity SitesSocial Networking SitesPrestonProductivity SitesSocial Networking Sites 8Monday1 hour 4 hoursMonday27 m5 hr 30 m Tuesday3 hour1 hourTuesday10 m3 hr Wednesday30 min5 hourWednesday5 hr 10 m4 hr 59 m Thursday3 hours3 hoursThursday5 hr 24 m3 hr 56 m Friday4 hours45 minFriday5 hr 51 m3 hr 4 m Saturday01 hourSaturday1 m2 hr 41 m Sunday01 hourSunday43 m3 hr 45 m FemalesMales MaggieProductivity SitesSocial Networking SitesTravisProductivity SitesSocial Networking Sites 9Monday1hr 9 min4 hr 49 minMonday3m2h 12m Tuesday1 hr 40 min7 hr 45 minTuesday5m4h 41m Wednesday1 hr 7 min4 hr 48 minWednesday2m4h 8m Thursday40 min9 hr 32 minThursday3m2h 46m Friday47 min4 hr 2