Evaluate the mean and median

Assignment Help Operation Management

Reference no: EM132069289

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 attached. 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: EM132069289

Questions Cloud

What is the total gain or loss after day four : Assume that the initial margin is $3,000; the maintenance margin is $2,000, and the tick value is 1 b.p. = $25. What is the total gain or loss after Day 4?

Explain use of direct contact and brand advertisements : Social Media is the number one way we will get to our target audience with the use of direct contact and brand advertisements.

What would you do to exploit these quotes : What would you do to exploit these quotes? What would be your riskless profit? How could you synthetically sell a call option?

Difference between r square and adjusted r square : What is the difference between R Square and Adjusted R Square in multiple regression and why do we need to calculate both of these statistics.

Evaluate the mean and median : The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics.

Ordinal scale and interval scale as used in research : Describe the difference between ordinal scale and interval scale as used in research.

What is the chance that a youth will be chosen : What is the chance that a youth will be chosen first to represent the sample?

How much money do you have if you hold the bond to maturity : If you can reinvest coupons a rate of 2% per annum, then how much money do you have if you hold the bond to maturity?

Create a shortage to increase the demand : Provide an example of a company that artificially created a shortage to increase the demand? And do not use the Cabbage Patch dolls or the Tickle Me Elmo.

User Account

All Pages