Our Services

Get 15% Discount on your First Order

Standard error will be calculated by dividing the standard deviation

May 14, 2023

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

calculated, deviation, dividing, Error, STANDARD

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

ANSWER POST 250 WORDS MIN Discussion Questions: Select one terrorist

***ANSWER POST 250 WORDS MIN*** Discussion Questions: Select one terrorist tactic (other than bombings) and explain how it has evolved over time. Explain why homemade bombs (improvised explosive devices) have been such a popular choice of a weapon for terrorists? Fully explain the reasons why various bombs have been used as the most

Objective: To create a fine motor lesson plan for preschoolers. Scenario: You are a teacher at a preschool. Your class will soon be starting a topic

Objective: To create a fine motor lesson plan for preschoolers. Scenario: You are a teacher at a preschool. Your class will soon be starting a topic called “Airplanes, Trains, and Tracks.” The children in your care come from diverse cultural backgrounds, and several of them speak languages other than

table graphics, notes and analysis is needed for assignment. Please

table graphics, notes and analysis is needed for assignment. Please be very detailed with company Baldwin Comparative Financial Analysis and Competitive Analysis. •Comparative Financial Analysis and Competitive Analysis. Round 7 are attached to give the analysis for Comparative Financial and Competitive. Please explain what, happened from round 7 why

1. Complete the required Major Case Analysis on the NFL

1. Complete the required Major Case Analysis on the NFL Rooney Rule The write-up is limited to 12-15 double-spaced pages, not including a title page and exhibits (include as appendices) 2. In addition to the Major Case Analysis, produce a PowerPoint or Prezi presentation (or presentation that uses another appropriate

I have a psychology project due further details to be discussed upon acceptance

kindly find attached the document. Rasmussen University – NUR2063: Essentials of Pathophysiology Title of

kindly find attached the document. Rasmussen University – NUR2063: Essentials of Pathophysiology Title of Assignment: Module 01 Written Assignment – Electrolyte Imbalance Purpose of Assignment: Identifying abnormal findings for electrolyte imbalances is an expected function of a healthcare team. Course Competency(s): · Determine the cellular functions required to regulate homeostasis.

Access 365/2019 Capstone – Level 3 Working with a Sales Database (EX.03)

MSHA students: Research each topic below as it related to

MSHA students: Research each topic below as it related to your selected healthcare organization and actively research each topic in preparation for submitting a 5- to 6-page paper and presenting your Capstone Project: Organizational Structure Existing Plans (strategic, quality improvement, etc.) Environmental Factors/Assessment Leadership Challenges Legal and Ethical Challenges Performance

Daily Question (Finance) Consider a U.S. based MNC that has excess cash to invest. Discuss advantages and disadvantages of investing excess cash in a

Daily Question (Finance) Consider a U.S. based MNC that has excess cash to invest. Discuss advantages and disadvantages of investing excess cash in a foreign currency such as the Mexican peso or the Indian rupee instead of investing it in the U.S. In April 2024, the latest central bank interest

Like you cannot travel without knowing the destination; similarly, an

Like you cannot travel without knowing the destination; similarly, an assignment is nothing without a perfect topic. A good topic gives you the direction to proceed and guides you throughout the writing process. Therefore, you cannot just pick up any topic and start writing on it. You need to select

1) Choose a current topic or issue In the previous

1) Choose a current topic or issue In the previous modules, many current topics and issues have been explored. For this assignment, you and your partner will be applying all the research concepts you have learned to write a formal, well-written research paper. If you are uncertain of

Describe at least two theories that help to explain what

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Assignment: Academic Success and Professional Development Plan Part 1: Developing

Assignment: Academic Success and Professional Development Plan Part 1: Developing an Academic and Professional Network Consider individuals, departments, teams, and/or resources within Walden University and within your profession that you believe can support your academic and professional success. Identify at least two academic and at least two professional

WHAT DOES THE EPIC OF GILGAMESH TELL US ABOUT OUR EARLIEST CIVILIZATIONS’ REPRESENTATION OF THE HERO? In what way(s) does Gilgamesh become a hero in the

WHAT DOES THE EPIC OF GILGAMESH TELL US ABOUT OUR EARLIEST CIVILIZATIONS’ REPRESENTATION OF THE HERO? In what way(s) does Gilgamesh become a hero in the second half of the work? What has he achieved at the end of the poem and why is this important? What is the function

NR 361 CCN Mobile Health App Patient Guide Presentation Nursing Assignment Help

Purpose The purpose of this assignment is to demonstrate the skills of the professional nurse as an educator. You are to prepare a guide that will serve as a handout to assist a specific patient that you identify. Your guide or handout should help this patient find and evaluate a

An organization (Facebook Security Concerns focusing on data leaks over

An organization (Facebook Security Concerns focusing on data leaks over the past couple of years, and in particular the one from 2018) you will work on that has had a public relations crisis within the last 12-36 months. You will want to select something large enough that there are

Please explain what Sezary syndrome and mutation in DNA (

Please explain what Sezary syndrome and mutation in DNA ( Genomics) FOLLOW INSTRUCTIONS!!!!!! –Abstract of the proposal – Context and objectives of the proposal – Introduction – Research objectives Your research objectives are the key things you intend for your research to accomplish. They may be the specific questions that