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

  Beta industries has net income of 1700000 and it has

stock repurchasesbeta industries has net income of 1700000 and it has 1830000 shares of common stock outstanding. the

  1a simple random sample of 1000 americans found that 61

1.a simple random sample of 1000 americans found that 61 were satisfied with the service provided by the dealer from

  At a 5 level of significance test to determine if more than

last year a soft drink manufacturer had 21 of the market. in an effor to increase their portion of the market the

  Orders for a computer are summarized by the optional

orders for a computer are summarized by the optional features that are requested. the proportion of orders with no

  Calculate the actual number of respondents in 2010 that

a gallup poll released in december 2010 asked 1019 adults living in the continental us about their belief in the origin

  Calculate the mean and variance of the sample data

The times needed to fall asleep are assumed to follow a normal distribution. The results for the two nights for the ten volunteers are shown below:

  Populations are at least normally distributed with equal

In testing for the equality of two population variances, when the populations are normally distributed, the10% level of significance has been used. To determine the rejection region, it will be necessary to refer tothe F table corresponding to an upp..

  Suppose he does not own the deal what is the largest amount

peter browns utility for total wealth x can be represented by the utility function ux lnx. he currently has 1000 in

  What warranty company give if tires to outlast warranty

Random sample with a normal distribution with a mean of 60,000 and standard deviation of 2300. What warranty should the company us if they want 96% of the tires to outlast the warranty?

  Forecasting techniques-regression moving average

Perform a linear regression, 8 month moving average & 3 month moving average forecasting technique to see which is most accurate for the new quarter 11 if quarter 11 sales are 172,000 units

  A study has indicated that the sample size necessary to

a study has indicated that the sample size necessary to estimate the average electricity use by residential customers

  At cruising altitude a commercial jet engine consumes an

at cruising altitude a commercial jet engine consumes an average of 850 gallons of fuel per hour with a standard

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