For this project you will be analyzing data utilizing a spreadsheet software package. The purpose of this project is to enhance and then highlight your skills at analyzing a database utilizing aspreadsheet program. This week you are supplied with one Excel Workbook that has three different databases for you to analyze (see attachments below) To get started, download this workbook and save it on your computer. These tasks requireyou to reorganize data, build charts and tables, and then explain what the data is “telling you.” Before getting started with these assignments, it may be beneficial to go into theLessonstabin the left-hand navigation panel and review some of the PowerPoint Presentations, videos, and GCFLearnFree materials prior to getting started. If you need to brush up on your Excel skills, there are some excellent (very short) lessons on Excel located in the Lessons section for weeks 5 & 6.
Start by downloading and saving the databases from the hyperlink below to your computer. Database 1 will be used for Jobs 1 through 4, Database 2 for Jobs 5 and 6, and Database 3 for Job 7. There are complete instructions inside the Workbook you will download, however, here is a short description of each “Job” you will be completing over the next two weeks: Job 1: Reorganize data by month, analyze, and report on your findings. The first worksheet tab is labeled “Database 1 & Instructions” Average Temperatures for Washington DC 1990 – 2001. Use the data in this first tab to complete Jobs 1 – 4. You will first sort the data by month and create a table and a line chart of the average temperaturesby month. Complete instructions for this project are located in the Workbook under the Raw Database 1 tab. There is aHelp Videovideo included in theLessons (Readings and Resources)section for weeks 5 & 6 (Video 1) that explains how to sort data and use a formula to obtain averages. Job 2: Analyze the same data you used in Job 1, but reorganize the databy year. In this Job, you will create a table and line chart using the annual data. Complete instructions are on the first tab marked “Database 1 & Instructions” Job 3: Create a histogram of the data in Database 1. Use the same Database; there are instructions for this project on that first worksheet tab. If you have not created a histogram before, there is a short video in theLessonssection that can help you get started. Job 4: Create a Pivot Table. Use the same database 1 to create a Pivot Table of the maximum monthly data by year. The Pivot table is an excellent way to give a visual representation of summarized data. Finally, you are asked to explain any trends you see in your table.There is a Training video included in theLessonssection for weeks 5 & 6 labeled Video 2 Jobs 5 & 6:Create Pivot Tables. For thesetwo projects you will use data found on the worksheet tab marked “Raw Database 2 & Instructions.” Here you will create two different pivot tables that analyse first bycounts and then by the average price by region. Job 7:Create a Pareto Analysis. In this final project, you will use the data on the Worksheet tab marked”Database 3 & Instructions.”Thedatabase on this page contains the suppliers, products, and order size for the Month of September. Youwill be creating and then answering questions regardingtwo Pareto chartsthat you will create. There are instructions inthe tab Marked “Database3” For how to create a Pareto chart. There is a YouTube video included in the lessons section under weeks 5 & 6 to help you through creating a Pareto analysis. There are also detailed instructions for how to create a Pareto Analysis onthe Database 3 page. Remember, save your work often and then by Sunday midnight of week 6submit only one Excel Workbook below. This workbook will includeallseven jobs.
This excelspreadsheet is the seventh project for submission to your cloud account this week and into your e-portfolio in weeks 7 & 8. Save this project using the following naming convention: JSmith_Weeks 5&6_Project7