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 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.
Expert Solution Preview
Introduction:
Module 14 requires students to use Microsoft Excel to calculate descriptive statistics and generate graphs using a provided data worksheet. The activities require the use of the Data Analysis module and toolbar in Excel. Students are required to post their Excel file addressing all activities to the module discussion board by the stated deadline.
Answer:
For Activity 1, students need to compute descriptive statistics for the ISS by year using the provided Excel worksheet. They are encouraged to use the Data Analysis module and toolbar in Excel. Once computed, students should post the descriptive statistics for each year on the “Descriptive Statistics” sheet in the provided Excel worksheet. Excel tutorials that were found helpful should be posted as links.
For Activity 2, students need to create a bar graph with average ISS and 95% confidence bars by year. The graph should be placed on the “Figures” sheet in the Excel worksheet. Links to helpful Excel tutorials should also be posted alongside the graph.
Lastly, for Activity 3, students are required to create a line graph with average ISS and 95% confidence bars by year. Like activity 2, the graph should be placed on the “Figures” sheet in the provided Excel worksheet, and links to helpful Excel tutorials should be posted.