Conduct Quantitative Analysis

User Generated

wtbyqf

Computer Science

Description

Using a method similar to the qualitative research process, you will identify an issue and use mathematical formulas or an analytic tool to derive a solution. You will construct graphs, charts, and tables as necessary to inform analysis and interpretation. Communicating key mathematical information, you will evaluate the results and draw analyses and validate them.

This project will enable a deeper understanding of how data informs solutions to practical problems with potential impact on your organization or industry.

Unformatted Attachment Preview

Project 4: Conduct Quantitative Analysis You will work on an IT data set and use IBM Watson Analytics to visualize the data, ask questions of the data, and create a dashboard. The first thing you will want to do if you are a CCA student is to read the CCA Project 4 scenario. This replaces the video and transcript that appear below this box. Now download the IT data set template and take a few minutes to review the Help Desk dataset. Note that there are two worksheets or tabs. The first worksheet (titled "IT-Help-Desk") contains the data to be analyzed. The second worksheet (titled "QR Analysis Essay") will be where you cut and paste your endof-project essay. You will use Excel to determine the average number of days the tickets are open and the distributions of the requestor's seniority, type and severity of problem, assigned priority level, and end-user satisfaction level. We'll work through these problems in the next steps. First, Open the Excel file and go to Save As to rename it. Opening and Saving an Excel Spreadsheet Use the name format YourLastName Project 4. This file contains the data that you will manipulate and analyze. You will add tabs in the next steps to build an Excel workbook for this project. To get your Excel workbook properly formatted, set the margins for landscape with narrow margins. Enter your name, date, and page number in the footer area of the sheet. Format the entire spreadsheet using Calibri 11 font. In Section 2 of the Excel spreadsheet that you have downloaded, use Excel formulas to fill in the grey boxes for seniority of requestor, type of problem, priority, satisfaction rating, and severity in the tables. You will use some Excel functions to summarize the IT data, using COUNTIF and the SUM function to do the math to complete the five tables in Section 2. In this step, you'll begin to see patterns in the data that inform the story in the student data. Now it's time to complete your analysis. What are the results showing? Answer these questions by typing into the text box. • Which types of employees are most likely and least likely to open a ticket? • Which types of problems are most and least common? • What can you tell about the satisfaction level? • What can you tell about the number of days a ticket is open? Now you will calculate mean, median, and mode for the categories of data, and derive the deviation, variance, dispersion, and distribution. You will calculate descriptive or summary statistics for the IT data set using Excel formulas and in the next step using the Toolpak. Format all the results to two decimal places. This is where it gets interesting! In Section 3 of the data sheet, use the appropriate Excel function to complete the table, calculating summary statistics on the DaysOpen data on the IT-Help-Desk tab (column 1). Use the Excel functions of =AVERAGE, =MEDIAN, =MODE, =STDEV.S, =VAR.S, =KURT, =SKEW, =MIN, =MAX, =SUM, =COUNT to derive these statistics for the three data categories. The following calculations do not have a direct Excel function but can be derived from other values calculated here: • Standard error will be calculated by dividing the standard deviation by the square root of the count. • Range is calculated by subtracting the minimum from maximum values. Next, you will use Excel's built-in Analysis Toolpak to confirm the answers of your Summary Statistics. Once you download the Toolpak, you will see "Data Analysis" in the top right corner on the Data tab. Select this and you will see a menu of choices. Choose "Descriptive Statistics" and input the information to tell Excel where to look for the information (column I), and what you would like for the output. You will create a new sheet (or tab) for this output. Label it "Summary Statistics." In the next step, you will create some charts. Where would we be without the ability to view data in charts? It is sometimes easier to grasp the context of data if we can see it captured in an image. Graphs and charts help readers digest and interpret information more quickly, consistent with the familiar adage "a picture is worth a thousand words." Let us find out what we can see in your data analysis as you work with IT data to create charts. In this step, you will add a new tab and name it "Graphs." Create the following graphs in the worksheet: • Pie charts to show the distributions of requestor's seniority and types of problem. • Bar charts to show the distributions of the severity of the problems and priority level assigned. In the next step, you will use IBM Watson Analytics to perform data discovery. https://idaas.iam.ibm.com/idaas/mtfim/sps/authsvc?PolicyId=u rn:ibm:security:authentication:asf:basicldapuser jenny.r.goldston@gmail.com JGolds2019 In the last step, you calculated some important statistical measures. This step involves introducing you to a powerful, state-of-the-art data analytics tool, IBM's Watson Analytics. This dynamic tool supports quantitative reasoning. Take some time to review Watson Analytics and complete the tutorial link at the bottom of that page. After completing the tutorial, you will be ready to apply this powerful tool to the data set in your Excel Workbook containing help desk tickets. Click the following links to learn how to set up your Watson Project folder and apply the tool to your data set. • Get Started with Watson Analytics for the IT data set • Import the IT Data into Watson Analytics • Visualize the IT Data Using Watson Analytics • Ask Questions of the IT Data Set Using Watson Analytics • Create a Dashboard Showing Your Watson Analytics Findings Now that you have completed your analysis, it is time to share what you have found. Your report should be about 750 to 1,000 words. It might be easiest to compose it in a Word document and then copy and paste what you've written in your workbook on the QR Analysis Essay tab. You can enlarge the text box to contain your essay. Reflect on what you learned from capturing the data using Excel formulas. Incorporate at least one visualization into your report. Use appropriate mathematical and statistical vocabulary. Keep in mind that you are preparing this report for the head of the department. You need to provide relevant information that will lead to recommendations to address concerns about the help desk. This report should answer the following questions: • How is the help desk department performing? • Which specific ITOwner (help desk technician) is a high performer? Which ITOwner is the lowest performer? • What relevant information about the help desk did you uncover from your analysis? • What recommendations do you have for the help desk? The primary purpose of the analysis you have just completed is to prevent misinterpretation of data. You can never assume that the end user will be able to interpret the data the way it should be understood. It is up to you. Provide concise examples to back up your recommendations. Never simply provide a raw data dump. Instead, seek to provide quantitative analysis!
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey find the attached file. It was a pleasure a serving you. Thanks and goodbye

Running Head: QUANTITATIVE ANALYSIS

Project 4: Conduct Quantitative Analysis
Name
Institution
Course
Date

1

QUANTITATIVE ANALYSIS

2
Introduction

From the quantitate analysis of the data from the company’s ticketing process, it is
evident that the process faced certain challenges which varied depending on the category of
employees, nature of employee, and the mode of accessing the ticketing system. These
challenges are clearly discussed below.
The Types of Employees that are most likely and least likely to open a Ticket
The ticketing process was open for all the employees of the company who fall in the
categories of new employees, regular employees, management level, and the executive level.
However, the number of problems registered by each category of employe...


Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags