Identify whether the data is qualitative or quantitative

Assignment Help Operation Management
Reference no: EM132198568

Statistics Concepts and Descriptive Measures purpose of Assignment

The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics.

Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the course start.

Assignment Steps

This assignment has an Excel® dataset spreadsheet. You will be required to only do one of the three datasets.

Resource: Microsoft Excel®, Statistics Concepts and Descriptive Measures Data Set

Download the Statistics Concepts and Descriptive Measures Data Set.

Choose one of the following datasets to complete this assignment:

• Consumer Food

• Financial

• Hospital

Answer each of the following in a total of 90 words:

• For each column, identify whether the data is qualitative or quantitative.

• Identify the level of measurement for the data in each column.

• For each column containing quantitative data:

o Evaluate the mean and median

o Interpret the mean and median in plain non-technical terms

o Use the Excel =AVERAGE function to find the mean

o Use the Excel =MEDIAN function to find the median

• For each column containing quantitative data:

o Evaluate the standard deviation and range

o Interpret the standard deviation and range in plain non-technical terms

o Use the Excel =STDEV.S function to find the standard deviation

o For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel's =MIN function

Reference no: EM132198568

Questions Cloud

Morals and ethics within their households : Assuming most everyone learned their morals and ethics within their households,
The integrated approach to managing diversity : What are your company’s strengths and weaknesses in light of the integrated approach to managing diversity?
Calculate the company return on equity : Calculate the company's return on equity and explain whether the managers are providing a good return on the capital provided by the company's shareholders
Terms of its diversity management initiatives : Analyze the organization in which you work (or have worked in the past) in terms of its diversity management initiatives.
Identify whether the data is qualitative or quantitative : Find the maximum value using the Excel =MAX function and find the minimum value using the Excel's =MIN function.
Calculate the return on sales ratio : S&J Plumbing, Incorporated's income statement shows a net profit before tax of $468, Calculate the Return on sales ratio
Explain why managers should understand web technology : Briefly explain why managers should understand Web technology.
Estimate of the company cost of equity capital : What is your best estimate of the company's cost of equity capital using the arithmetic average growth rate in dividends
What do you know about probability : Describe a data distribution statistically and graphically using skewness, kurtosis, and box-and-whisker plots.

Reviews

Write a Review

Operation Management Questions & Answers

  The core competencies of netflix current business model

What are the core competencies of Netflix’s current business model ? Assess the value of Netflix’s business as described in the case.

  Russian missiles are going to be hitting your territory

You're the president. You Know that 3,000 Russian missiles are going to be hitting your territory within the hour.

  Corporate contract account should be retained or dropped

What are some of the criteria the sales staff could use to evaluate whether a corporate contract account should be retained or dropped?

  Identify commonalities across several studies

Why is it important to identify commonalities across several studies with regard to study findings & the types of patients to which study findings can be apply.

  Identify what you believe are consequences of the issues

Identify what you believe are consequences of the issues/problems you presented. Identify roles within the organization and organizational units affected.

  The development of m-commerce

What are the business forces that are driving the transition from traditional education to online learning. Briefly describe Web 2.0. How does it differ from the traditional Web

  Support activity of the value chain model

Which of the following is a support activity of the Value Chain Model?

  The operations are in parallel

A product needs to go through only one of the three assembly operations? (the operations are in parallel).

  Major consulting firm

For this week, discuss your thoughts on the following ethical dilemma: You work in HR at a major consulting firm and one of the consultants comes to you and says that he cannot in good faith take an assignment at the Philip Morris company because ..

  Van driver t-boned when another driver

Two straight truck driver accidents hitting objects while backing into loading docks, and a van driver t-boned when another driver ran a red light.

  Relocating to your area for more education and training

A colleague has a friend who is considering relocating to your area for more education and training.

  Briefly discuss how uncertainty affects capacity decisions

Briefly discuss how uncertainty affects capacity decisions.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd