Module 14: Using Excel for Data Management and Analysis 3 Bottom Line: By the end of this module, each student will have calculated descriptive statistics and generated 2 graphs using a provided Excel data worksheet. Required Reading This module requires you to use Microsoft Excel. If you are not familiar with this program, there are many ways to get assistance with learning. A link to the Microsoft Excel basic skills page is provided. If you prefer video tutorials, feel free to search YouTube or other appropriate platforms. I encourage you to share links to videos and other resources you find particularly helpful with your classmates. Microsoft Basic Tasks in Excel https://support.office.com/en-us/article/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca The required Excel data workbook is available for download in the module folder. Recommended Resources None Module Activities NOTE: Work for all activities should be on the same Excel file. Post your Excel file addressing activities 1-3 to the module discussion board by midnight on Monday, 02 December 2019. Activity 1: Using the provided Excel worksheet, compute descriptive statistics for the ISS by year. • You will need to use the Data Analysis module and toolbar for this activity. • Post the descriptive statistics for each year to the sheet titled, “Descriptive Statistics” on the provided Excel worksheet. • Descriptive statistics for 2010 are provided as an example. • Post links to any Excel tutorial you found helpful for this activity. Activity 2: Create a bar graph showing average ISS with 95% confidence bars by year. • Place the graph onto the sheet titled, “Figures” on the provided Excel worksheet. • Post links to any Excel tutorial you found helpful for this activity • An example of a bar graph with confidence bars is in the module folder. Activity 3: Create a line graph showing average ISS with 95% confidence bars by year. • Place the graph onto the sheet titled, “Figures” on the provided Excel worksheet. • Post links to any Excel tutorial you found helpful for this activity • An example of a line graph with confidence bars in in the module folder.
Module 14: Using Excel for Data Management and Analysis 3 Bottom Line: By the end of this module, each student will have calculated descriptive statistics and generated 2 graphs using a provided Ex
Data Vi sualization Resources The Data Visualisation Catalogue (overview and informational vide os) https://datavizcatalogue.com/ Slide Chooser https://prezi.com/c2jtl7nplyy6/slide -chooser/ Chart Chooser (PDF) https://apandre.wordpress.com/dataviews/choiceofchart/ Chart Chooser (Interactive with Templates) http://labs.juiceanalytics.com/chartchooser/index.html Bullet Chart (information and li nk to create an Excel template) http://www.exceluser.com/excel_dashboards/bullet -graph.htm Bullet Chart (s tep -by -step instructions) https://www.tutorialspoint.com/advanced_excel_charts/advanced_excel_bullet_chart.htm Software Options (fees may apply) Qlik https://w ww.qlik.com/us/ Tableau https://www.tableau.com/ MedeAnalytic cs https://medeanalytics.com/ Periscope Data https://www.periscopedata.com/ HighCharts https://www.highcharts.com/ PC Magazine article listin g top 10 free d ata visualization tools (2018) https://www.pcmag.com/art icle/347315/10 -free -data -visualization -tools PC Mag azine article listing top data visualization tools (2019) (not free) https://www.pcmag.com/roundup/346417/the -best -data -visualization -tools Predictive Analytics Today review of to p 74 data visualization software options (2018) https://www.predictiveanalyticstoday.com/top -data -visualization -software/