Descriptive statistics in the analysis tool list

Assignment Help Basic Statistics
Reference no: EM131094278

Suppose that a health plan asserts that a patient hospitalized with coronary heart disease requires no more than 6.5 days of hospital care. However, we believe that a stay pf 6.5 days is too low. To examine the claim of the health plan, assume further that we collected data depicting the lengths of stay of 40 patients who were hospitalized recently with coronary heart disease. The results of the sample are as follows:

5,8,9,12,7,9,10,11,4,7,8,5,8,13,11,10,6,5,8,9

5,12,7,9,4,8,7,7,11,5,8,10,5,8,2,11,3,6,8,7

If a = 0.05, use these data to evaluate the claim by the health plan

1) Enter the data set into Excel.

2) Click on the Data tab at the top.

3) Highlight your data set with your mouse.

4) Click on the Data Analysis tab at the top right.

5) Click on Descriptive Statistics in the analysis tool list.

6) Find the mean and standard deviation of the data sets.

Reference no: EM131094278

Questions Cloud

Identify and explain an opposing reason : Provide an introduction in which you briefly explain the topic and the particular question on which you will focus your paper - Identify and Explain an Opposing Reason Identify and explain a plausible reason someone might give that would oppose or c..
State the relevant legal issues involved in the controversy : Find a recent article (or articles) from scholarly, academic, professional, or news sources (including online sources) on a current and controversial subject matter that deals with legal issues and principles addressed in your Business Law I cours..
Recognition and genetic characterization of tick resistance : Write  a report on the topic ” Recognition and Genetic characterization of tick resistance (CXCL 10) gene in Red Sindhi (bos indicus) and Jersey ( Bos taurus) cattle on the basis of polymorphism.”
Find out the answer of given questions : 3) The BOD5 of your sample is 1000 mg/L. You add 10 mL of the sample to 290 mL of water (for a total volume of 300 mL). The initial DO is 8.3 ppm. What is the DO after 5 days?
Descriptive statistics in the analysis tool list : 1) Enter the data set into Excel. 2) Click on the Data tab at the top. 3) Highlight your data set with your mouse. 4) Click on the Data Analysis tab at the top right. 5) Click on Descriptive Statistics in the analysis tool list.
Is barnes correct and why or why not : During the course of the construction, Barnes decides to use funds specified for the subdivision for an office-space project that Barnes alone has been interested in completing. Morgan is very angry on learning of Barnes' actions and terminates th..
What are the implications of the mini-hypervisor : What are the implications of this mini-hypervisor? What kind of administration/management would need to be in place to keep all these optimized? What kind of security? Do you really need virtual machines to achieve cloud computing?
Explain one-bank credit system : Explain One-bank Credit System (be able to explain why credit as a means of payment implies an elastic supply of money). Explain Multi-bank Credit System (explain the ways in which banks can pay each other; why is a clearinghouse superior?
Jet service to smaller airports for american airlines : Skywest Airlines is a regional carrier providing jet service to smaller airports for American Airlines, United, and Delta. This project will consider one route that Skywest operates for United Airlines:

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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