# 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

### Question 1) Create an intervention! Choose a BEHAVIOR that leads

Question 1)  Create an intervention!  Choose a BEHAVIOR that leads to a DISEASE within a specific POPULATION and design an intervention!  Cover the following steps:

### Research what federal and state collaboration efforts (if any) exist

Research what federal and state collaboration efforts (if any) exist for the state in which you live and/or practice. Does your state currently participate in

### A case study is a qualitative research technique that aims

A case study is a qualitative research technique that aims to reveal a phenomenon through the use of a case. It can be used to

### MN7542 Financial Modelling: Determine how this information can be used

Module: MN7542 Financial Modelling Assignment  Question Read carefully the case notes below and consider the information shown in the appendix. Determine how this information can

### Instructions 1. Read the required chapters from the text Attached. 2. Write a 3page research paper outlining possible career paths

Instructions1. Read the required chapters from the text (Attached).2. Write a 3-page research paper outlining possible career paths in the field of Human Resources Management

### 10 slides Your company recently went through a global merger

10 slides  Your company recently went through a global merger or acquisition in which at least one of the parties involved was from one of

### Fundamentals of Psychology – Week #6 Assignment Maslow’s Hierarchy of Needs Write

Fundamentals of Psychology – Week #6 Assignment Maslow’s Hierarchy of Needs Write a 1-2 page paper addressing the following.  Maslow’s Hierarchy of Needs suggest

### Competencies Interpret core managerial finance concepts and data. Analyze operational budget drivers

Competencies Interpret core managerial finance concepts and data. Analyze operational budget drivers and variances. Interpret financial decision-making criteria. Evaluate financing strategies for business operations.

### Your paper should include quotations from Wallace’s “Tense Present: Democracy,

Your paper should include quotations from Wallace’s “Tense Present: Democracy, English, and the Wars over Usage” as well as at least one additional source from

### 1 ) Do a bit of research on penetration testing

1 ) Do a bit of research on penetration testing techniques. Investigate and document the following Five network penetration testing techniques, Advantages and disadvantages

### ED6008 Multimodal Learning in Early Childhood- Scenario No 2: The

Scenario No 2: The ticket Elsa came to the Nursery one morning and was very happy. She was holding a ticket on her hands and

New questions

### NR 561 WSU Application to Practice Reflective Essay Nursing Assignment Help

Whether practicing at the local level or involved with health initiatives that encompass a national or global approach, nurses are equipped with competencies to promote

### HSA 515 SU Health & Medical the Respondent Superior Concept Nursing Assignment Help

I’m working on a health & medical discussion question and need the explanation and answer to help me learn. Discussion – Respondeat Superior Analyze the

### WU Handling Tough Decisions In The Workplace Discussion Nursing Assignment Help

Managers make numerous decisions on a daily basis. For some, the best choice is easy or straightforward to determine. If a machine breaks down, you

### Cultural Awareness Paper Read Chapter: Populations Health Nursing Assignment Help

Cultural Awareness Paper Read Chapter: Populations Health Care (9th edition) of Saunders Comprehensive Review for the NCLEX-RN Examination Using Microsoft Word Document complete the following assignment: Specifics:

### ASSIGNMENT: Educate Consumers on Patient Portal Usage Nursing Assignment Help

ASSIGNMENT: Educate Consumers on Patient Portal Usage Instructions: After reading the material for the week, create an educational flyer for patients at a 10-physician outpatient clinic.