Calculate the variance and standard deviation of age

Assignment Help Basic Statistics
Reference no: EM13853756

Please complete in EXCEL.

a. Using the file below, calculate the variance and standard deviation of Age, LOS, and Charges by using the formula. DO NOT USE FUNCTION for this problem.

b. Based on the mean and standard deviation for LOS, generate a frequency distribution in terms of one standard deviation units around the mean.

c. Develop an Excel chart to show the frequency distribution generated in (b).

Attachment:- file.xls

Reference no: EM13853756

Questions Cloud

What is ecosystem balance? : What is ecosystem balance? Which reduction factors and which growth factors impacted ecosystem balance in Episode 1?
Definition or explanation of industrial hygiene : Definition/explanation of industrial hygiene
Why would gifts commonly not produce a capital gain or loss : What happens if consideration promised is subsequently not received? Why would gifts commonly not produce a capital gain/loss?
Differences between the film frankenstein and the novel : Differences between the film Frankenstein and the novel
Calculate the variance and standard deviation of age : Using the file below, calculate the variance and standard deviation of Age, LOS, and Charges by using the formula. DO NOT USE FUNCTION for this problem.
What are major stressors in your life right now : At the end of your essay answer the following questions- What are major stressors in your life right now? How could you reduce your level of personal stress
Critically disucuss the problem of population growth : Review and critically disucuss the problem of population growth
Determine the total cost-total revenue and profit : 1. The Retread Tire Company recaps tires.  The  fixed  annual  cost  of  the  recapping  operation is $65,000. The variable cost of recapping a tire is $7.5. The company charges$25 to recap a tire. a. For an annual volume of 15, 000 tire, determin..
Calculate the overall total and mean number of gallons : Calculate the total sales, mean, median, mode, and standard deviation for this dataset.Label the cells so that they can be easily identified - Calculate the overall total and mean number of gallons sold for all flavors for this quarter nd for this q..

Reviews

Write a Review

Basic Statistics Questions & Answers

  Find fraction of defective items gets by both inspectors

the probability that it gets by the first inspector is 0.1. Of those that get past the first inspector, the second inspector will miss 5 out of 10. What fraction of the defective items gets by both inspectors?

  Appropriate null and alternative hypotheses

Let ≥ represent the true average area (in square feet) of these apartments. What are the appropriate null and alternative hypotheses?

  Calculate a 95% confidence interval

Calculate a 95% Confidence Interval

  Probability that seven of the adults favor school vouchers

Suppose that 55% of all adults with children favor school voucher programs. A sample of 8 adults with children is taken. What is the probability that at least 7 of the adults favor school vouchers?

  Determining test of independence of attributes

The following data resulted from an experiment to study the effects of leaf removal on the ability of fruit of a certain type to mature:

  Performing a chi-square test for independence

When performing a chi-square test for independence, explain how the "cell frequencies under the independence assumption" are calculated.

  Explain the concept of regression analysis

Explain the concept of "Regression Analysis", its types (3 types at least), applications and usefulness. Provide real application of its usage.

  Measures of central tendency and skew

You've administered a standardized test of manual dexterity to two groups of 10 semi skilled workers. One of these two groups of workers will be employed by you to work in a warehouse with many fragile items.

  Use critical value to determine null hypothesis

Choo Choo Paper Company makes various paper products. One of their products is a 30 mils thick paper. In order to ensure that the thickness of the paper meets the 30 mils specification

  Generate 50 normal distributions with mean 15 and standard

the following problem should be answered in rgenerate 50 normal distributions with mean 15 and standard deviation 3

  A pharmaceutical company receives large shipments of

a pharmaceutical company receives large shipments of aspirin tablets. the acceptance sampling plan is to randomly

  Analysis of multinear regression

How does multilinear regression analysis apply to a profession? Specify the dependent value and the set of predictors. Where would you get the data?

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