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

  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