# Standard error will be calculated by dividing the standard deviation

Review the IT data set template (attached) 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 end-of-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. 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.

No Step 3

Step 4

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?

Step 5

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.

#Standard #error #calculated #dividing #standard #deviation

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Financial Engineering to Enhance Shareholder

Create an 7 and 9 pages report in which you examine a major public company and provide a recommendation on how shareholder value could be

### Assignment 5: Law Enforcement in Europe and Mexico

Visit the OSCE (Organization for Security and Cooperation in Europe) site and select two of the hyperlinked countries to look at closely. Read the information for each

### You are caring for a patient with c-diff as part

You are caring for a patient with c-diff as part of your workload assignment. Discuss what c-diff is and how it is transmitted (how you

### Provide two different examples of how research uses hypothesis testing,

Provide two different examples of how research uses hypothesis testing, and describe the criteria for rejecting the null hypothesis. Discuss why this is important in

### Exercise 8-2 At the end of 2006, a new edition

Exercise 8-2 At the end of 2006, a new edition of the Federal Rules of Civil Procedure (FRCP) went into effect. Using a Web search

### Part1 Start your paper with an introductory paragraph (0.5 page)

Part1 Start your paper with an introductory paragraph (0.5 page) Prompt  1 Blockchain (2 pages): Explain the major components of a blockchain.  Be sure to

### 2 DQ 2 Ethnography is a research that involves observation,

2 DQ 2 Ethnography is a research that involves observation, where interaction with willing participants interact in real life with real-life experiences. Researchers are involved

### Prepare a PowerPoint presentation consisting of 5 slides not including

Prepare a PowerPoint presentation consisting of 5 slides not including the cover slide and the reference slide. Every slide needs to include 100 words in

### Human Resources: Legalization of Cannabis and the Workplace

Your grade will be based on ensuring the following questions are addressed: 1)Define the topic as it relates to the text and lectures. 2)How is

### Juan was asked by his boss to develop a forecast

Juan was asked by his boss to develop a forecast model for the WTI Spot crude oil price. Juan was eager to show off his

### You will interview someone who is different than you and

You will interview someone who is different than you and write 3-4  page  paper describing your experience.  The paper should be double – space 12

### Your team development plan in the form of a minimum

Your team development plan in the form of a minimum two-page document. Adhere to APA Style when constructing this assignment, including in-text citations and references

New questions