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

Case Brief Assignment Guidelines Sport Law

Gillian BERGER, et al., PlaintiffsAppellants, v. NATIONAL COLLEGIATE ATHLETIC ASSOCIATION, et al., DefendantsAppellees. Each case brief must contain the following information (for more information, see How to Brief a Case on Canvas in the Week 2: Introduction to Legal Thinking module): • Title of the Case, Citation, Year Decided,

Review article Nursing Assignment Help

A review article on “Health Insurance Portability and Accountability Act (HIPAA) for the Electronic medical record era” Expert Solution Preview Introduction: The Health Insurance Portability and Accountability Act (HIPAA) is a crucial legislation in the healthcare industry, especially in the era of electronic medical records. Understanding the implications and

Dangers of GMOs

length requirement of 8-10, double-spaced pages the essay must follow MLA formatting guidelines, including in-text citations. a Works Cited page Must be against the use of GMOs Sources: soapboxie.com/social-issues/What-Genetically-Modified-Foods-Do-to-Our-Bodies www.naturalnews.com/038792_GMO_toxicity_digestion_cancer.html. www.treehugger.com/green-food/11-gm-foods-commonly-found-grocery-stores.html. www.onegreenplanet.org/animalsandnature/the-environmental-impact-of-gmos/. www.huffingtonpost.com/jeffrey-smith/genetically-modified-soy_b_544575.html. nutritionstudies.org/gmo-dangers-facts-you-need-to-know/. responsibletechnology.org/10-reasons-to-avoid-gmos/. #Dangers #GMOs

RESPOND TO STUDENTS POSTS Dominique post This week we discuss

RESPOND TO STUDENTS POSTS Dominique post This week we discuss different analytical techniques, in regards to operating a business. In many businesses, Capitol investments are mandatory. Business homes certainly are going to be anxious to know when they will recover such an initial cost of an investment. When evaluating potential capital

point out the following 1. rites of passage, coming of

point out the following 1. rites of passage, coming of men or women hood (mask wearing, initiation, birth, death and after life rites/ ceremonies , give examples. 2 give the main mode of production / living , farming , pastoral life or hunter / gatherer 3. give examples of political

write a 200-300 word response (no more than one page)

write a 200-300 word response (no more than one page) This assignment asks you to find an example of a fallacious argument online, but it doesn’t really specify what sort of websites you should choose. What’s important for this assignment is that you find an example of a fallacy and

Project Management Consider a recent project that you have worked

Project Management Consider a recent project that you have worked on. This could be for a company or organization with which you are familiar, or even a personal project such as purchasing a home or planning a family gathering. After your opening paragraph, which includes your thesis statement, identify your

Application of Course Knowledge: Answer all questions/criteria with explanations and detail. Reflect on your learning experience in this course. Which

Application of Course Knowledge: Answer all questions/criteria with explanations and detail. Reflect on your learning experience in this course. Which concepts stood out to you and made an impact?  How do you envision using these concepts in your future nursing practice as a master’s prepared nurse?   Describe how course learning activities and assignments

Instructions Marketing Plan: Part II In this unit, you will

Instructions Marketing Plan: Part II In this unit, you will continue to build upon your marketing plan for an existing company and a product or service of your choice. For Part II, make certain to include the sections listed below in your marketing plan. SWOT Analysis A valuable step in

Prompt: Describe an example of a research question where dummy

Prompt: Describe an example of a research question where dummy variables should be used. Describe the characteristics of the categorical variable and its usage in explaining the variance in the dependent variable. Then, discuss whether you feel separate subset analysis is also warranted. Explain why (or why not) you

Answer the following questions in your own words. to be

Answer the following questions in your own words. to be submitted in 2hours Question 1: Create a Work Breakdown Structure (WBS) identifying the Tasks Id, Tasks Description, Tasks Duration (Days), and Predecessor Tasks. Eden Bay is a medium-sized municipality. The town has grown rapidly, and so has the demand for

Stakeholder Analysis: Conduct internal and external research to

The purpose of this assignment is to conduct internal and external research to determine previously attempted solutions and potential solutions that could be implemented to solve identified problem. For this assignment, you will need to create an Excel spreadsheet that summarizes the data collection you have completed. The spreadsheet should

Netflix and digitals streaming services

Outline – This document (minimum of 4 pgs. not including the bibliography) should clearly label the introduction, body, and conclusion elements of her/his speech. Students should also highlight their attention-getter, topical statement, credibility statement, preview points, main points, and summary statement. (Times New Roman; 12 pt font; double spaced) 6

Answer their challenge question. Responses should do the following: Derive

Answer their challenge question. Responses should do the following: Derive from course material Center on thinking about the art object in myriad ways Not be too obscure, obvious or off topic Challenge each other to think critically about the artwork & it’s context Focus on developing ideas – think about other

This assignment will be submitted to Turnitin®.Instructions The human resource

This assignment will be submitted to Turnitin®.Instructions The human resource department is updating its HIPAA Basic Training for Privacy and Security course. As a security analyst for the hospital, you have been tasked with covering the topics in the training related to the HIPAA security rule and the information that

Nursing Role and Scope Discussion Nursing Assignment Help

After reading Chapter 4 and reviewing the lecture power point (located in lectures tab), please answer the following questions. Each question must have at least 3 paragraphs and you must use at 3 least references included in your post. APA format Discussion board questions: 1. Think about the ethical theories

As being a full stack web developer answer the following.

As being a full stack web developer answer the following. Q1. Describe 2-3 actions that you have taken in your internship workplace that demonstrated your initiative. Q2. Have you offered to do something above and beyond your normal duties? Have you figured out a better way to do a common

SCENARIO A U.S. fishing boat manufacturer is known throughout the

SCENARIO A U.S. fishing boat manufacturer is known throughout the United States for its innovative approach to product design, lean manufacturing, and responsive customer service since its start three years ago. The mission statement of the company is “We will provide the most innovative customer-driven design and growth in the