How to Analyze Numerical Summaries of Data

In this week’s assignment, you will answer the following questions using both Excel and SPSS software. Results from these programs should be copied and pasted into a Word document for submission.

For Questions 1 and 2 you will need to input the data provided below into both Excel and SPSS. For Questions 3 and 4 you will use the dataset files provided in the resources for this week (Descriptive statistics, n.d.-a, n.d.-b).

1. Suppose that a quality assurance manager took a random sample from a thread-cutting machine. The sample consisted of 18 bolts and the manager tested their tensile strengths. Results from the sample, in tons of force required for breakage, are given below:

2.20          1.95          2.15          2.08          1.85          1.92

2.23          2.19          1.98          2.07          2.24          2.31

1.96          2.30          2.27          1.89          2.01          1.93

a. Use Excel to calculate the mean, median, and standard deviation for these data.

b. Use SPSS to calculate the mean, median, and standard deviation for these data.

c. Use SPSS to create a histogram of these data.

d. Interpret these results and explain any differences you find between the two software tools (Hint. The results should be identical).

2. A manager of a food manufacturing company wants to estimate the percentage of fat in one of its salad dressings. A sample of 20 bottles was taken and the results are given below.

15.88        19.88        21.16        20.37        22.77        20.65

18.60        18.91        21.77        21.64        18.62        18.41

20.15        17.07        19.91        21.07        16.49        21.21

17.98        20.22

a. Use Excel to calculate the mean, median, and standard deviation for these data.

b. Use SPSS to calculate the mean, median, and standard deviation for these data.

c. Use SPSS to create a histogram of these data.

d. Interpret these results and explain whether or not it is honest for the manufacturer to state that the fat content is 20%? Explain your answer.

3. A manager is worried that her employees are not engaged at work. She finds an employee engagement survey and administers it to her workers. The individual scores are provided in the dataset file.

a. Use Excel to calculate the mean, median, and standard deviation for the employee engagement data.

b. Use SPSS to calculate the mean, median, and standard deviation for the employee engagement data.

c. Use SPSS to create a histogram of these data.

d. Next, conduct an analysis of the “age” and “gender” variables using the appropriate measures of central tendency and dispersion. Use SPSS only. Also, create an appropriate graphic for each variable.

d. Interpret the results for employee engagement, age, and gender. Identify what you believe the next step should be in this analysis.

4. A shop supervisor wants to understand his workers better. He hires a consultant who tells him that he should ask employees questions related to their lives if they feel comfortable answering these questions. Please use SPSS to analyze the following variables, create appropriate figures and charts, and explain the results of each variable. Do not compare the variables in this assignment.

a. Age

b. Model of car

c. Rent or own their home

d. Hobbies

e. How happy they are (on a five-point scale)

Length: 4 pages

References: Include a minimum of 3 resources (two of these will be Excel and SPSS).

Your assignment should demonstrate thoughtful consideration of the ideas and concepts presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards.

ReplyForward

In this week’s assignment, you will answer the following questions using both Excel and SPSS software. Results from these programs should be copied and pasted into a Word document for submission.

For Questions 1 and 2 you will need to input the data provided below into both Excel and SPSS. For Questions 3 and 4 you will use the dataset files provided in the resources for this week (Descriptive statistics, n.d.-a, n.d.-b).

1. Suppose that a quality assurance manager took a random sample from a thread-cutting machine. The sample consisted of 18 bolts and the manager tested their tensile strengths. Results from the sample, in tons of force required for breakage, are given below:

2.20          1.95          2.15          2.08          1.85          1.92

2.23          2.19          1.98          2.07          2.24          2.31

1.96          2.30          2.27          1.89          2.01          1.93

a. Use Excel to calculate the mean, median, and standard deviation for these data.

b. Use SPSS to calculate the mean, median, and standard deviation for these data.

c. Use SPSS to create a histogram of these data.

d. Interpret these results and explain any differences you find between the two software tools (Hint. The results should be identical).

2. A manager of a food manufacturing company wants to estimate the percentage of fat in one of its salad dressings. A sample of 20 bottles was taken and the results are given below.

15.88        19.88        21.16        20.37        22.77        20.65

18.60        18.91        21.77        21.64        18.62        18.41

20.15        17.07        19.91        21.07        16.49        21.21

17.98        20.22

a. Use Excel to calculate the mean, median, and standard deviation for these data.

b. Use SPSS to calculate the mean, median, and standard deviation for these data.

c. Use SPSS to create a histogram of these data.

d. Interpret these results and explain whether or not it is honest for the manufacturer to state that the fat content is 20%? Explain your answer.

3. A manager is worried that her employees are not engaged at work. She finds an employee engagement survey and administers it to her workers. The individual scores are provided in the dataset file.

a. Use Excel to calculate the mean, median, and standard deviation for the employee engagement data.

b. Use SPSS to calculate the mean, median, and standard deviation for the employee engagement data.

c. Use SPSS to create a histogram of these data.

d. Next, conduct an analysis of the “age” and “gender” variables using the appropriate measures of central tendency and dispersion. Use SPSS only. Also, create an appropriate graphic for each variable.

d. Interpret the results for employee engagement, age, and gender. Identify what you believe the next step should be in this analysis.

4. A shop supervisor wants to understand his workers better. He hires a consultant who tells him that he should ask employees questions related to their lives if they feel comfortable answering these questions. Please use SPSS to analyze the following variables, create appropriate figures and charts, and explain the results of each variable. Do not compare the variables in this assignment.

a. Age

b. Model of car

c. Rent or own their home

d. Hobbies

e. How happy they are (on a five-point scale)

Length: 4 pages

References: Include a minimum of 3 resources (two of these will be Excel and SPSS).

Your assignment should demonstrate thoughtful consideration of the ideas and concepts presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards.

ReplyForward

Discuss The Nature of Capitalism

This week we are covering the textbook topics found in Chapter 4, The Nature of Capitalism (beginning on page 117) and Chapter 5 Corporation (beginning on page 156).

For this week’s discussion you need to post your thoughts on the following questions.

Per our textbook, there are four key features of capitalism which include the existence of companies, the goal of making a profit, a competitive market, and private property ownership.

How do these four features of capitalism relate to you as an individual residing in the “land of free enterprise.?”

Do you feel that capitalism is fair across the board for small business owners as well as large corporate giants? Explain your thoughts.

This week we are covering the textbook topics found in Chapter 4, The Nature of Capitalism (beginning on page 117) and Chapter 5 Corporation (beginning on page 156).

For this week’s discussion you need to post your thoughts on the following questions.

Per our textbook, there are four key features of capitalism which include the existence of companies, the goal of making a profit, a competitive market, and private property ownership.

How do these four features of capitalism relate to you as an individual residing in the “land of free enterprise.?”

Do you feel that capitalism is fair across the board for small business owners as well as large corporate giants? Explain your thoughts.

Reflection On Cultural Diversity

Instructions

In this unit, you will consider everything you have learned over the course of the term and reflect on our growing awareness of stereotype, othering, and the impact of inequality on cultural diversity.

  • Download the Reflection on Cultural Diversity Template
  • Follow the template instructions
  • Demonstrate your understanding of key concepts from the weekly content by including analysis of specific evidence in your responses within the template.
  • Use in-text citations and APA formatting for all source material references in your template.
  • Upload the completed template to this assessment.
  • The grading criteria for this assignment are outlined in the rubric below.

    Instructions

    In this unit, you will consider everything you have learned over the course of the term and reflect on our growing awareness of stereotype, othering, and the impact of inequality on cultural diversity.

    • Download the Reflection on Cultural Diversity Template
    • Follow the template instructions
    • Demonstrate your understanding of key concepts from the weekly content by including analysis of specific evidence in your responses within the template.
    • Use in-text citations and APA formatting for all source material references in your template.
    • Upload the completed template to this assessment.
    • The grading criteria for this assignment are outlined in the rubric below.

Discuss four leadership theories

This assignment requires you to use Tutor.com and make the changes based on the feedback before you upload your assignment. Review the Tutor.com instructions in the Student Success Guide located in the Course Resources folder.

Choose four leadership theories that most resonate with you from the theories you read about this week.

Note: The readings this week only cover four contemporary leadership theories so please research to familiarize yourself with historical leaders and other contemporary leadership theories.

Write a 500- to 750-word literature review of the four theories you chose.

Identify a problem in your organization or industry. You can use the problem you identified in your Week 1 assignment or you can choose a different problem.

Choose one theory from the four you selected and discuss how a leader could apply the theory to address your identified problem.

Support your assertions with citations from at least three peer-reviewed articles.

Format your paper according to APA guidelines using the APA Paper Template.

Include APA-formatted in-text citations, a title page, and a references page.

Submit your paper to Tutor.com by clicking the Tutor.com™ Access link located below the Course Syllabus.

Note: Turnaround time for Drop-off Paper Review is within 12 hours.

Download the Summary Feedback you receive from Tutor.com.

Submit your revised paper (based on the tutor.com feedback) and the Tutor.com  Feedback. Upload both in one submission.  

This assignment requires you to use Tutor.com and make the changes based on the feedback before you upload your assignment. Review the Tutor.com instructions in the Student Success Guide located in the Course Resources folder.

Choose four leadership theories that most resonate with you from the theories you read about this week.

Note: The readings this week only cover four contemporary leadership theories so please research to familiarize yourself with historical leaders and other contemporary leadership theories.

Write a 500- to 750-word literature review of the four theories you chose.

Identify a problem in your organization or industry. You can use the problem you identified in your Week 1 assignment or you can choose a different problem.

Choose one theory from the four you selected and discuss how a leader could apply the theory to address your identified problem.

Support your assertions with citations from at least three peer-reviewed articles.

Format your paper according to APA guidelines using the APA Paper Template.

Include APA-formatted in-text citations, a title page, and a references page.

Submit your paper to Tutor.com by clicking the Tutor.com™ Access link located below the Course Syllabus.

Note: Turnaround time for Drop-off Paper Review is within 12 hours.

Download the Summary Feedback you receive from Tutor.com.

Submit your revised paper (based on the tutor.com feedback) and the Tutor.com  Feedback. Upload both in one submission.  

Employment Law Infographic

Title:

Module 03: The role of employment law in business relationships

Competency:

Evaluate employment law at the state and federal levels.

Scenario:

Your work as a contract employee for a U.S. based company that develops gaming software. Having been there for years, and going into the office five days a week for usually more than forty hours a week, you were inspired by the various projects you have worked on and in your spare time, using company equipment, you work on your own side project – an app that would give gamers an edge. You know that your company’s business partners would be very enthusiastic about this new product, and you would probably make a great profit; in fact, you might be able to retire! You decide to reach out to these business relationships to see who might have interest.

Instructions:

  • Review the situation and conduct scholarly research on employment law. Upon review of the given business situation, create an infographic that evaluates employment law utilizing both federal and state regulations (students should use their own state of residence regulations for the project).
    • Address the following:
      1. Distinguish between full-time, part-time, at-will, and contract employment statuses, and state which status reflects your employment position in this company.
      2. What federal, state and international laws explain the rights, responsibilities and protections of employees and employers in the employment relationship?
      3. What are the property rights of employees and employers for inventions as provided in federal intellectual property laws?
  • Use at least three credible sources. These should be cited and in APA format.

Discuss on Capital Budgeting Decisions

Chee Company has gathered the following data on a proposed investment project:

Investment required in equipment …………. $240,000

Annual cash inflows ……………………………. $50,000

Salvage value …………………………………….. $0

Life of the investment …………………………. 8 years

Required rate of return ………………………… 10%

Assets will be depreciated using straight

line depreciation method

Required:

Using the net present value and the internal rate of return methods, is this a good investment?

Chee Company has gathered the following data on a proposed investment project:

Investment required in equipment …………. $240,000

Annual cash inflows ……………………………. $50,000

Salvage value …………………………………….. $0

Life of the investment …………………………. 8 years

Required rate of return ………………………… 10%

Assets will be depreciated using straight

line depreciation method

Required:

Using the net present value and the internal rate of return methods, is this a good investment?

Define the term Salvage value

Chee Company has gathered the following data on a proposed investment project:

Investment required in equipment …………. $240,000

Annual cash inflows ……………………………. $50,000

Salvage value …………………………………….. $0

Life of the investment …………………………. 8 years

Required rate of return ………………………… 10%

Assets will be depreciated using straight

line depreciation method

Required:

Using the net present value and the internal rate of return methods, is this a good investment?

Chee Company has gathered the following data on a proposed investment project:

Investment required in equipment …………. $240,000

Annual cash inflows ……………………………. $50,000

Salvage value …………………………………….. $0

Life of the investment …………………………. 8 years

Required rate of return ………………………… 10%

Assets will be depreciated using straight

line depreciation method

Required:

Using the net present value and the internal rate of return methods, is this a good investment?

How will the components of the external environment impact Magnolia Brands’ ability to realize their vision?

Evaluate Magnolia Brands’ sustainable competitive advantage by analyzing the case study and answering the following questions in 350 to 525 words:

  • How will the components of the external environment impact Magnolia Brands’ ability to realize their vision?
  • Who are Magnolia Brands’ major competitors?
  • What other factors are affecting the growth of Magnolia Brands?
  • What internal factors must be considered for Magnolia Brands to achieve its vision and mission?
  • What are some of Magnolia Brands’ strengths and weaknesses?
  • How does the new show represent an opportunity in the home remodeling industry?
  • What challenges or threats might Magnolia Brand face?
  • What measurements can be used to determine if the new show is successful?
  • What is the feasibility of the ability of Magnolia Brands to continue to be successful? Why?
  • Use bullets and/or headers for each of the nine questions

    Evaluate Magnolia Brands’ sustainable competitive advantage by analyzing the case study and answering the following questions in 350 to 525 words:

    • How will the components of the external environment impact Magnolia Brands’ ability to realize their vision?
    • Who are Magnolia Brands’ major competitors?
    • What other factors are affecting the growth of Magnolia Brands?
    • What internal factors must be considered for Magnolia Brands to achieve its vision and mission?
    • What are some of Magnolia Brands’ strengths and weaknesses?
    • How does the new show represent an opportunity in the home remodeling industry?
    • What challenges or threats might Magnolia Brand face?
    • What measurements can be used to determine if the new show is successful?
    • What is the feasibility of the ability of Magnolia Brands to continue to be successful? Why?
    • Use bullets and/or headers for each of the nine questions

Discuss Corporate Entrepreneurship Assessment

Choose 1 of the following Fortune 500 companies to study throughout this course:

  • CVS Health
  • Chevron
  • Kroger
  • Bank of America
  • Home Depot
  • Comcast
  • Target
  • United Parcel Service
  • Procter & Gamble
  • Caterpillar
  • Complete the Entrepreneurial Strengths and Actions to Increase Value Creation worksheet, describing the company’s approach to entrepreneurial value creation, assessing the company’s strengths in terms of entrepreneurial value creation, and recommending at least 1 action the company could take to increase entrepreneurial value creation.Choose 1 of the following Fortune 500 companies to study throughout this course:
    • CVS Health
    • Chevron
    • Kroger
    • Bank of America
    • Home Depot
    • Comcast
    • Target
    • United Parcel Service
    • Procter & Gamble
    • Caterpillar
    • Complete the Entrepreneurial Strengths and Actions to Increase Value Creation worksheet, describing the company’s approach to entrepreneurial value creation, assessing the company’s strengths in terms of entrepreneurial value creation, and recommending at least 1 action the company could take to increase entrepreneurial value creation.

Explain the thematic connection between the two pieces.

 

Part 1: Art Creation
Select one of the visual art pieces from Chapters 1-6 or the lessons from Weeks 1-3 to use as a point of inspiration. Create a painting, sculpture, drawing, or work of architecture inspired by your selected art piece.

Part 2: Reflection
Write a reflection about the relationship between your art production and the inspiration piece. Include the following in the reflection paper:

  • Introduction
  • Inspiration Piece
    • Include image.
    • Record the title, artist, year, and place of origin.
    • Briefly explain the background of the inspiration piece.
  • Your Art Piece
    • Include image.
    • Provide a title.
    • Explain the background of your piece.
  • Connection
    • Explain the thematic connection between the two pieces.
    • How are they similar and different?
    • Are they the same medium? How does the medium impact what the viewer experiences?
    • How do the formal elements of design compare to one another?

Original Artwork Requirements

  • Methods: paint, watercolor, pencil, crayon, marker, collage, clay, metal, or wood (Check with your instructor about other methods you have in mind.)
  • No computer-generated pieces

Writing Requirements (APA format)

  • Length: 1.5-2 pages (not including title page, references page, or image of artwork)
  • 1-inch margins
  • Double spaced
  • 12-point Times New Roman font
  • Title page
  • References page (minimum of 1 scholarly source)

Grading
This activity will be graded based on the W3 Art Creation & Reflection Grading Rubric.