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

  Can the bond rate be predicted by the interest rate

Can the bond rate be predicted by the interest rate? Make the Bond rate the Dependent variable and Prime the independent variable.

  The diameter of a brand of ping-pong ball is approximately

the diameter of a brand of ping-pong ball is approximately normally distributed with a mean of 1.30 inches and a

  Calculate the test statistic for a test of the hypothesis

researchers studied the effects of adding an exercise program to dieting in the achievement of weight loss. a sample of

  Waiting times to receive food after placing an order at the

waiting times to receive food after placing an order at the local subway sandwich shop follow an exponential

  Task of developing a requirements document

Lavanya is leading a virtual team that is given the task of developing a requirements document for a new application system. She will present a draft of the initial document but needs additional input on requirements form other team members who ar..

  Choosing one of subjects-art-geology-psychology

A student must choose one of the subjects, art, geology, or psychology, as an elective. She is equally likely to choose art or psychology and twice as likely to choose geology.

  Question on identifying statistic

Suppose a researcher has trained observers to rank participants according to their level of frustration when trying to solve a puzzle.

  What are the steps of testing a hypothesis

What are the steps of testing a hypothesis for two populationmeanswith independent and dependent samples? Provide a workplace or business related example

  The revenues of the top eleven personal computer

the revenues of the top eleven personal computer manufacturers are given in hundred millions15 17 23 26 27 35 72 88 91

  Let x be a continuous distribution with probability density

let x be a continuous distribution with probability density function fx2x32 if xgt -2 and fx0 otherwiselet yx2.

  Compute cis for proportion of all female hispanic drivers

Tthen calculate the 95% and 99% CIs for the proportion of all female Hispanic drivers in Boston who wear seatbelts. Why is the 99% CI wider than the 95% CI?

  Probability that the psychic correctly identifies the symbol

A noted psychic was tested for ESP. The psychic was presented with 400 cards face down and asked to determine if each card was marked with one of four symbols: a star, cross, circle, or square. The psychic was correct in 120 cases. Let p represent..

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