***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN

7) For borrowers with good credit scores, the mean debt for revolving and installment accounts is $15,015. Assume the standard deviation is $3,540 and that debt amounts are normally distributed.

a. What is the probability that the debt for a borrower with good credit is more than $18,000?

b. What is the probability that the debt for a borrower with good credit is less than $10,000?

c. What is the probability that the debt for a borrower with good credit is between $12,000 and $18,000?

d. What is the probability that the debt for a borrower with good credit is no more than $14,000?

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN

6) The time needed to complete a final examination in a particular college course is normally distributed with a mean of 90 minutes and a standard deviation of 15 minutes. Answer the following questions.

a. What is the probability of completing the exam in one hour or less?

b. What is the probability that a student will complete the exam in more than 60 minutes but less than 105 minutes?

c. Assume that the class has 60 students and that the examination period is 120 minutes in length. How many students do you expect will be unable to complete the exam in the allotted time?

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN

Given that z is a standard normal random variable, find z for each situation.

a. The area to the left of z is .9750.

b. The area between 0 and z is .4750.

c. The area to the left of z is .7291.

d. The area to the right of z is .1314.

e. The area to the left of z is .6700.

f. The area to the right of z is .3300.

A company manager believes that a person’s ability to be a leader is directly correlated to their zodiac sign. He never selects someone to chair a committee without first evaluating their zodiac sign. An irate employee sets out to prove her manager wrong. She claims that if zodiac sign truly makes a difference in leadership, then a random sample of 200 CEO’s in our country would reveal a difference in zodiac sign distribution. She finds the following zodiac signs for her random sample of 200 CEO’s:

Can she conclude that zodiac sign makes a difference in whether or not a person makes a good leader?

Hypotheses:

H₀: There is a difference/no difference in leadership ability based on zodiac sign.

H₁: There is a difference/no difference in leadership ability based on zodiac sign.

Enter the test statistic - round to 4 decimal places.

___

Enter the p-value - round to 4 decimal places.

___

Can it be concluded that there is a statistically significant difference in leadership ability based on zodiac sign?

Yes/No

A Gallup Poll showed that 44% of Americans are satisfied with the way things are going in the United States. Suppose a sample of 25 Americans are selected.

Find the probability that no less than 7 Americans are satisfied with the way things are going.

Find the probability that exactly 15 Americans are not satisfied with the way things are going.

Find the probability that the number of Americans who are satisfied with the way things are going differs by greater than 2 from the mean.

Find the probability that greater than 7 Americans are satisfied with the way things are going.

Find the probability that at least 15 Americans are not satisfied with the way things are going.

Find the probability that no more than 9 Americans are satisfied with the way things are going.

Find the probability that more than 40% but at most 65% of these Americans are satisfied with the way things are going.

Round to 4 decimals.

An elementary school started a special reading enrichment program for seventh-graders that has been underway for eight months. One of the investigators wants to confirm the program is having its intended effect, and collects a sample of 34 students from the program with a standardized reading test average of 24.1. The standardized reading test average for seventh-graders in the country is 26.1 with a standard deviation of 4.9. What can the investigator conclude with α = 0.01?

a) What is the appropriate test statistic?
---Select--- na z-test one-sample t-test independent-samples t-test related-samples t-test

b)
Population:
---Select--- the school seventh-graders in the program the program months seventh-graders in the country
Sample:
---Select--- the school seventh-graders in the program the program months seventh-graders in the country

c) Compute the appropriate test statistic(s) to make a decision about H₀.
(Hint: Make sure to write down the null and alternative hypotheses to help solve the problem.)
critical value =  ; test statistic =
Decision:  ---Select--- Reject H0 Fail to reject H0

d) If appropriate, compute the CI. If not appropriate, input "na" for both spaces below.
[  ,  ]

e) Compute the corresponding effect size(s) and indicate magnitude(s).
If not appropriate, input and select "na" below.
d =  ;   ---Select--- na trivial effect small effect medium effect large effect
r² =  ;   ---Select--- na trivial effect small effect medium effect large effect

f) Make an interpretation based on the results.

The standardized reading test of seventh-graders in the special reading enrichment program is significantly higher than seventh-graders in the country.The standardized reading test of seventh-graders in the special reading enrichment program is significantly lower than seventh-graders in the country.    The standardized reading test of seventh-graders in the special reading enrichment program is not significantly different than seventh-graders in the country.

A company that makes language learning software wants to determine which of two approaches (Method A or Method B) to learning vocabulary would lead to the largest number of recalled words. The company wishes to evaluate the methods on 7 different languages (since languages differ in difficulty). Seven individuals, one per language, were recruited to learn words using Method A, and 7 individuals, one per language, were recruited to learn words using Method B.

After one month, each person completed a test of word recall. The data, representing the number of words recalled, are shown in the table below.

The company wishes to test whether there is a difference in the average number of words recalled between the two methods. Calculate the test statistic for this hypothesis to two decimal places. Take all calculations toward the final answer to three (3) decimal places

23. Late in summer of 1996, Tiger Woods became a professional golfer. This highly publicized event followed a sensational college career at Stanford University, where Tiger won three United States Amateur Championships. Tiger was not a professional very long before he had his first win on the pro tour, the Las Vegas Invitational. He received a total of $297,000 for his accomplishment. The prize money (in thousands of dollars) for the top 40 finishers in the tournament are given below.

1. Find the mean

2. Find the median

3. Find the mode

4. Find the 10% trimmed mean and compare it to the mean and the median.

5. Comment on the skewness of the distribution.

Assume that the age at onset of a certain disease is distributed normally with a mean of 43 years and a variance of 177.69 years.

a) What is the probability that an individual afflicted with the disease developed it before age 31?
probability =  

b) What is the probability that an individual afflicted with the disease developed it after age 48?
probability =  

c) What is the probability that an individual afflicted with the disease developed it between ages 31 and 48?
probability =  

uConstruct confidence intervals for the population mean of 80%, 90%, 95%, 99% using the following data and a population standard deviation of 900:

un = 100

u?x ̅ = 425

Consider a baseball world series (best of 7 game series) in which team A theoretically has a 0.55 chance of winning each game against team B. Simulate the probability that team A would win the world series against team B simulating 1,000 world series. What is the probability that team A would win? (USE R - include R output)

Imagine a class where nearly everyone scores between 83-84%, with hardly any dispersion beyond this narrow peak. How would you describe this distribution in terms of kurtosis?