User Account

All Pages

Evaluate the standard deviation and range

Assignment Help Applied Statistics
Reference no: EM131548761

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:

Evaluate the mean and median

Interpret the mean and median in plain non-technical terms

Use the Excel =AVERAGE function to find the mean

Use the Excel =MEDIAN function to find the median

For each column containing quantitative data:

Evaluate the standard deviation and range

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

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

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.

Attachment:- statistics_conceptsdata_set.rar

Reference no: EM131548761

Questions Cloud

What was your dollar return and percent return : During the year, it pays $65 in interest payments and ends the year valued at $1025. What was your dollar return and percent return?
What is the required rate of return : What is the required rate of return on the investor's portfolio?
Create ad for product or service as agreed on by your team : Create an ad for a product or service, as agreed on by your team. Each team member will submit a one-page summary discussing the process the team followed.
Examples of cost of capital in personal life : Can you think of examples of cost of capital in personal life? When or how have you compared the cost of getting money to the potential benefit.
Evaluate the standard deviation and range : Evaluate the standard deviation and range.Interpret the standard deviation and range in plain non-technical terms.
How do most individuals monitor and control their cash flow : How do most individuals monitor and control their cash flow? Share an example of something that you had to budget and plan to pay for.
What should the analysis indicate to the firm managers : The firm has a 6% cost of capital. What should the analysis indicate to the firm's managers?
Write the above second order equation : Write the above second order equation as a system of first order equations.
How do most individuals monitor and control their cash flow : How do most individuals monitor and control their cash flow? Share an example of something that you had to budget and plan to pay for.

Reviews

Write a Review

Applied Statistics Questions & Answers

  The world''s smallest mammal is the bumblebee bat

The world's smallest mammal is the bumblebee bat. The mean weight of 15 randomly selected bumblee bats is 1.659 grams, with a standard deviation of 0.264 grams.Dr. Clifford Jones claims that the mean weight of bumblebee bats is 1.8 grams.

  Complete the analysis of variance

Complete the analysis of variance. At a .05 level of significance, is there a significant difference between the treatments?

  What is the probability that such pollution actually exists

Suppose that on a particular day the test indicates carbon tetrachloride pollution. What is the probability that such pollution actually exists?

  Find the equation of the parabola in terms of a and b

A continuous probability distribution is given by a parabola, y=f(x), for a 2b - a/2)

  The average offering at another church

You gather data from two local churches about the average offering (a monetary donation to the church)that is collected at a weekly service. You want to see whether the average offering given at one churchis the same as the average offering at anothe..

  The number of cars that pass through.

An attendant at a car was is paid according to the number of cars that pass through.

  Find the probability that a sample mean is larger

Which of the following formulas would you use to find the probability that a sample mean is larger than some given value? z = (x - µ) ÷ σ µ = ∑x ÷ N

  Calculate the correlation between pretest and posttest score

Calculate the correlation between pretest and posttest scores separately for each gruop and determine sperately for each group whether performance improved from pretest to posttest

  Explain difference between two independent sample groups

A z-test is used for testing the mean of a population versus a standard, or comparing the means of two populations, with large (n = 30) samples.

  A new phone answering system for a company

A new phone answering system for a company is capable of handling seven calls every 10 minutes.  Prior to installing th new system company analysts determined that the incoming calls to the system are Poisson with a mean equal to three every 10 minut..

  Find the linear correlation coefficient for the systolic

Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements. Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastoli..

  Which is the better measure of central tendency

In the business world, the mean salary is often to describe the salaries of employees of a company.  However, the median salary may be a better measure of the salaries than the mean.  Which is the better measure of central tendency?  Why?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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