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.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS