LauraLi

I am working a major project in my statistics class and have hit a snag. I have 4 questions that require me to use and show Excel functions (formulas) in my worksheet. I can not seem to find the correct way to input formulas for the probability of the following information:

I need to find the probability of a number greather to or equal to 7

I need to find the probability of numbers less than or equal to 50K

I need to find the probability of numbers between 150K and 250K

I need to find the probability of numbers less than 49K

I have empirical data sets for to use to find all of the above information but can't seem to find the proper formulas. CAN ANYONE OUT THERE HELP.

In a random sample of 86 college students has a mean earnings of $3120 with a standard deviation of $677 over the summer months. Using a t- distribution, what are the confidence interval values for a 99% confidence range?

In a random sample of 18 families, the average weekly food expense was $95.60 with a sample standard deviation of $22.50. Using a t- distribution with a 96% confidence Interval. What is the margin of error?

In a random sample of 18 families, the average weekly food expense was $95.60 with a sample standard deviation of $22.50. Use a t- distribution to determine the upper a lower confidence interval values for a 96% confidence Interval. What are the CI Values?

Suppose 2-year Treasury bonds yield 4.25%, while 1-year bonds yield 2.6%. r* is 1.5%, and the maturity risk premium is zero.

a. Using the expectations theory, what is the yield on a 1-year bond, one year from now?

b. What is the expected inflation rate in Year 1?

c. What is the expected inflation rate in Year 2?

Due to a recession, expected inflation this year is only 2.5%. However, the inflation rate in Year 2 and thereafter is expected to be constant at some level above 2.5%. Assume that expectations theory holds and the real risk-free rate is r* = 3.25%. If the yield on 3-year Treasury bonds equals the 1-year yield plus 3%, what inflation rate is expected after Year 1?

I need help with this one.......hopefully someone out there can help:

Three cards are drawn from a deck of cards in succession without replacement. Find the probability that the first card selected is a red ace, the second card is a ten or jack and the third card is greater than 3 but less than 7?

In a college graduating class of 1000 students, 420 studied computer science, 516 studied engineering and 432 studied statistics, 244 studied computer science and engineering, 166 studied engineering and statistics, 194 studied computer science and statistics and 104 studied all 3 subjects. What is the probability that a person selected at random:

A. studied stats but not engineering

B. studied engineering AND statistics, but NOT computer science

C. studied stats only

D. Did not study engineering

E. Studied engineering and computer science.

I have been beating myself up with this one and can't get the answer.

6. A pair of dice is thrown twice. What is the probability of getting totals of 7 and 11?

A town has two fire engines operating independently. The probability that a specific engine is available when needed is 0.96

a. What is the probability that neither is available when needed?

b. What is the probability that one fire engine is available when needed?

In a college graduating class of 1000 students, 420 studied computer science, 516 studied engineering and 432 studied statistics, 244 studied computer science and engineering, 166 studied engineering and statistics, 194 studied computer science and statistics and 104 studied all three subjects. Find the probability that a person selected at random:

a. Studied statistic but not engineering

b. Studied engineering and statistics but not computer science

c. Studied statistics only

d. Did not study engineering

e. Studied engineering and computer science

There are three red balls and two white balls in a box. An experiment consist of drawing three balls in succession. Once a ball is drawn, it is not replaced.

1)What is the probability that two or more red balls will be obtained in the three draws?

2)Given a red ball is selected on the first draw, what is the probability of selecting one or more white balls after the three draws.

My husband and I moved away from our home town about a year and a half ago. We started a life for ourselves. We are in our mid 30's and we have an eight month old daughter. We are torn between moving back home to live near our aging parents, or stay where we have found a happy, fulfilling life. What do we do?

I am a fourth grade teacher in NJ and have five and a half years tenure. The state cut our budget by 7.2 million and 20% of the district's teachers were let go. This is happening across the state, and school taxes are forever increasing. mmm...

These cuts will increase class size to 33 students per class, and add other complications to the proper organization and running of the schools. Both of which go against the No Child Left Behind act.

How about a new bill?

No Teacher Left Behind!!!