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

  Compute a t-test comparing males and females heights

Using the above database, compute a t-test comparing males' and females' heights. You must determine which type of t-test to compute. Write a short interpretation of the results.

  Frequency distribution table and a pie chart

a.) Construct a frequency distribution table and a pie chart for this data. b.) What category comprises most of the sample?

  What is the formula for the standard error of the sample

what is the formula for the standard error of the sample distribution when we know the population standard

  A committee of eight members is to be formed from a group

a committee of eight members is to be formed from a group of eight men and eight women. assume people from the group

  Find the percentage of women meeting the height requirement

a survey found that womens heights are normally distributed with a mean 63.4 in and a standard deviation 2.5 in. a

  A class of statistics students was asked regarding your

a class of statistics students was asked regarding your weight do you think you are about right overweight or

  One sample mean by t-test

To test this notion, eight paid volunteers were placed (individually) in a room in which there was no light from the outside and no clocks or other indications of time.

  For the funtion fx6x2 make a table of slopes of secant

for the funtion fx6x2 make a table of slopes of secant lines and make a conjecture about the slope of the tangent line

  The weights of bags of candy are normally distributed with

the weights of bags of candy are normally distributed with a mean of 28 ounces and a standard deviation of .28 ounce.

  Casino game probability

Think of your favorite casino game (craps, black-jack, roulette, etc) and analyze the probabilities of a few different outcomes.

  Demonstrate the importance of performance-rhythm

Prepare: Prior to beginning your initial post, read the poems "We Real Cool" and "My Papa's Waltz" in your textbook. You are also required to listen to "We Real Cool" and "My Papa's Waltz" before completing this discussion.

  Expression for the potential for two dipoles

Consider a dipole of strength D, oriented along the x-axis and located at the point x = ε/2, y = 0, z = 0, and a dipole of strength -D, oriented along the x-axis at the point x = - ε /2, y = 0, z = 0.  Write the expression for the potential for thes..

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