(Answered) Please complete in excela using the file below calculate

Statistics

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

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M91423520
Price:- $15

Verified Expert

Priced at $30 Now at $15, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

1 if there are 150 values in a data set how many classes

1) If there are 150 values in a data set, how many classes should be created for a frequency histogram? A. 5 B. 6 C. 7 D. 8 E. 9 2) . If x is a binomial random variable where n = 100 and p = 0.2, find the probability tha ...

A stock price is currently 112 stock price move up by 10 or

A stock price is currently $112. Stock price move up by 10% or down by 14%. The risk-free interest rate is APR 2% with continuous compounding. What is the value of a six-month European put option with a strike price of $ ...

Ages of ceos of companies throughout the united states and

Ages of CEOs of companies throughout the United States, and answer the questions that follow. Event A : CEO is under 40 Event B : CEO is at least 30 Event C : CEO is in his or her 50s Event D : CEO is under 60 1. Even ...

You have 100 coins and 99 of them are fair equal

You have 100 coins, and 99 of them are fair (equal probability of heads or tails). One of them is weighted and has a 90% probability of landing on heads. You randomly choose one of the 100 coins. Find the probability tha ...

A restaurant serves hot chocolate that has a mean

A restaurant serves hot chocolate that has a mean temperature of 175 degrees with a standard deviation of 8.1 degrees. Find the probability that a randomly selected cup of hot chocolate would have a temperature of less t ...

Felcor stock is currently selling for 4000 a share but is

Felcor stock is currently selling for $40.00 a share but is expected to either decrease to $36 or increase to $44 a share over the next year. The risk-free rate is 4 percent. What is the current value of a 1-year call op ...

In this question are you just using the empirical ruleyou

In this question are you just using the empirical rule? You know that your population is normally distributed with a mean of 100 and a standard deviation of 15. Using the empirical rule as a rough approximation, what is ...

Staples has six special drafting pencils for sale two of

Staples has six special drafting pencils for sale, two of which are defective. A student buys two of these six drafting pencils, selected at random. Let the random variable X be the number of defective pencils. Construct ...

Mort is to pay off a loan of 75000 with equal payments at

Mort is to pay off a loan of $75,000 with equal payments at the end of every month over 10 years (i.e., 120 months). The ANNUAL effective rate is 5%. Mort decides that he can actually manage to pay double the monthly pay ...

1 you consider buying both stock a and stock b to make a

1.) You consider buying both Stock A and Stock B to make a portfolio to reduce some unsystematic risk. Both stocks will be weighted equally in the portfolio. Stock A has an expected return of 11% and a standard deviation ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert