DIRECTIONS: For this assignment you will conduct a descriptive statistics

DIRECTIONS: For this assignment you will conduct a descriptive statistics investigation and analysis on the data set associated with this assignment that is poste to Moodle. Please complete each of the following numerical prompts. Copy and paste the numerical prompts into your submission document and post your responses directly below each prompt.  

DO NOT submit Excel datasets to Moodle with your assignment. Do save your submission and submit to Moodle in PDF FORMAT ONLY. Copy and paste all requested charts, tables, and graphs from Excel into your submission document. Tables, charts, and graphs are to be formatted to expectations for the class (see Week 1 materials). Points are deducted for formatting and illegibility. Please use complete sentences when providing discussions or reporting interpretations for results (see week 1 materials). Report calculations when requested.

1. Review  and study ALL course materials and textbook chapter material prior to beginning this assignment.

2. Open the Data set associated with Project Part I

3. Create a table which lists each variable and its most likely level of measurement.  Format the table to class expectations as required on ALL assignments.

4. Generate an Excel descriptive statistic table for eacb variable. Discuss and report the measures of central tendency (mean and median), measures of variability (standard deviation, IQR, and range), kurtosis, and skewness numerical summaries. See exemplar (posted at the top of the course list in Moodle) for sample write up.  DO NOT JUST LIST the numerical summaries. Each of the numerical summary areas (measure of center, variability, kurtosis, and skewness) must have an associated meaningful interpretation to receive credit.

5. Based on the descriptive statistic tables generated in #3 above, which is the better measure of the center (mean or median) for each variable? Justify your response using rationale presented in the course materials provided for this week. That is,  REVIEW AND APPLY justification presented in the course materials prior to responding to this prompt.

6. Create a table and which contains the 5-number summary for the Capital Investment variable. Calculate and interpret the IQR for this variable. Report the formula you used to calculate the IQR.

7. In Excel, generate a box plot for the Capital Investment variable. Referencing the box plot, interpret the shape of the distribution of this variable. That is, state specifically which characteristics of the boxplot lead you to your claim regarding the distribution shape

8. In Excel, generate a histogram for the Sales variable. Reference characteristics of the histogram as you discuss the shape of the variable distribution.

9. Can the empirical rule be applied to the Sales variable?  Justify your response referencing details contained with the course materials for this week.

10. Calculate the Z-score for the Sales value for row 14 in the spreadsheet (162.9). Report the formula you used.  Is the Sales value for row 14 above or below the variable’s mean?  Justify your response referencing of your Z-score results that you calculated.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

This is based off the topic chosen for the capstone

This is based off the topic chosen for the capstone proposal.  This week you are to submit an “annotated” research bibliography of a minimum of “six” references (no older than seven years) to be used. Sources should only include scholarly sources such as journals, reports for think tanks, books, theses,

it consists of two parts (maximum 2,500 words): Part 1

it consists of two parts (maximum 2,500 words):Part 1 – Mental Experiment of Fast-forwarding your life and Part 2 – Creating Personal Vision. Assignment Instructions Part 1: Mental Experiment of Fast-forwarding your life To define one’s purpose in life is not an easy or simple task. When asked to do

www.pmi.org How many different certifications does the PMI offer? How

  www.pmi.org  How many different certifications does the PMI offer?  How much more can you expect to earn relative to a non-certified project manager?  How may questions are on the test?  How much does the certification cost?  How many hours do I need directing projects?  How many hours of PM

Journal Paper – Premium Paper Help

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.

Question 1: (25%) What is the role of a Change

Question 1: (25%) What is the role of a Change Agent? What is the difference between a Change Agent and a Change Leader? A family company wants to start a process of internationalization of the business. In this case: a) Who is the Change Agent, Change Leader, and Change Manager?

 In your health care career, you will be confronted with many problems that demand a solution.   4/12/24, 10:13 PM Analyzing a Current Health Care

 In your health care career, you will be confronted with many problems that demand a solution.   4/12/24, 10:13 PM Analyzing a Current Health Care Problem or Issue Scoring Guide files/Scoring Guides/a04_scoring_g… 1/1 Analyzing a Current Health Care Problem or Issue Scoring Guide CRITERIA NON-PERFORMANCE BASIC PROFICIENT DISTINGUISHED Use scholarly

Initial Post Week 1: In your initial post present seven

  Initial Post Week 1: In your initial post present seven business values (instrumental values as Rokeach defines ‘instrumental’) that a senior HRM executive in a global business should have – as you gleaned from the assigned reading. Initial Post Week 2: Present two principles from the Old Testament and

For this assignment, we must (1) discuss what is the

For this assignment, we must  (1) discuss what is the survival lottery, and the author’s argument about it. connect that with the thesis of “the duty to not kill is not stronger than the duty to not let survive”  (2) arguments for the author’s argument (see textbook) (3) provide critical

City 10KT IND Effects Analysis A

 Select a large international city that you know well – either by residence or multiple visits. Go to: http://www.nuclearsecrecy.com/nukemap/ (Links to an external site.) Links to an external site. (Links to an external site.) Links to an external site. Input the city into the tool, set the nuclear detonation for

Question: It could be argued that Sidhartha was in the

   Question:  It could be argued that Sidhartha was in the position similar to Oedipus, and Sidhartha’s father, the King, was in a position similar to King Laius — but after that, both Sidhartha and his father responded to their situations very differently – it could be said ‘oppositely’ to

Discuss what we learn about cultural processes and ethnography (and

  Discuss what we learn about cultural processes and ethnography (and their relationship to each other) in the following three works: 1. First Contact,  2. The Ax Fight,  3. Tajen: Interactive In your answer, be sure to: 1. Define key terms like “culture” and “ethnography” and how they relate to

Mental Skills Training Plan The purpose of this assignment is

  Mental Skills Training Plan The purpose of this assignment is to provide an opportunity to demonstrate your understanding of how to apply the principles of sport and exercise psychology to Coaching. You will creating a mental skills training portfolio that you can add to your coaching portfolio. Mental Skills

Organizational Communication Plan Instructions For this assignment, assume you are

  Organizational Communication Plan Instructions For this assignment, assume you are employed as a strategic planner with Metropolitan Health. Mission and vision are important to the strategic planning process of a health care organization. For this assignment, consider the following mission and vision statement. Mission: Metropolitan Health’s mission is to

INSTRUCTIONS: 1. Add a sheet to the worksheet and rename

INSTRUCTIONS:1. Add a sheet to the worksheet and rename sheet  Pivot table 1.  On sheet which is now called Pivot table 1,  go to cell A1 then “insert” “pivot table” using the data range provided on the data sheet (including the heading lines).  Drag “account” to the row labels and

In this version of your presentation you will incorporate the

 In this version of your presentation you will incorporate the feedback from your peer group and you will use the voice over feature in PowerPoint to narrate your revised presentation. Along with the narrated slides, you will submit a summary (minimum 300 words) to document and reflect on any revisions you

Research the topic of minority hiring, both racial and gender,

Research the topic of minority hiring, both racial and gender, in police departments. Do there appear to be any trends? What seems to be the overall opinion regarding the hiring of racial and gender minorities? Defend your thoughts with evidence. 250 – 350 words long. Refer & cite current resources

Week 2 Discussion 2 As you read this week’s assignments,

  Week 2 Discussion 2 As you read this week’s assignments, examine your own beliefs about the student–faculty relationship and discuss the effects that your beliefs and practices may have on the teaching-learning process, the academic performance of your students, and your students’ behavior. What are your beliefs about interactions