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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more