Use the Student_Data.xls file which consists of 200 MBA students at Whatsamattu U. The file includes variables regarding students' age, gender, major, GPA, Bachelors GPA, course load, English speaking status, family, weekly hours spent studying. Each of the three assigned problems should be formatted as a one page memo. Answers to all three of the problems should be submitted via the Drop Box as a single Word document with each of the problems clearly labeled. Be sure to include your name on the document itself!

COMPLETE PROBLEM 1: Let's assume (for this problem only) that the Student_Data.xls file was the entire population. We know the mean and standard deviation of student ages to be 42.3 and 8.9, respectively. Using the Normal_ Probability.xls file:

a) compute the percentage of students that are older than 50,
b) compute the percentage of students that are younger than 40,
c) compute the percentage of students that are between 41 and 46, inclusive.
d) compute the age range of the oldest 10% of the students.

Then compare each of the answers you computed to the truth as found in the actual file. Briefly discuss your results (100+ words, 3 or more sentences).

COMPLETE PROBLEM 2: You wish to know the average GPA of MBA students at Whatsamatta U. Compute the 95% confidence interval of the mean using the sample of 200 students. Report on your findings (50+ words, 2 or more sentences) along with a normal probability chart that illustrates the points raised in your report.

COMPLETE PROBLEM 3: You wish to know the proportion of MBA students that are majoring in Finance. Compute the 95% confidence interval of the proportion using the sample of 200 students. Report on your findings (50+ words, 2 or more sentences) along with a normal probability chart that illustrates the points raised in your report.

The solution provides step by step method for the calculation of probability using the Z score and confidence interval. Formula for the calculation and Interpretations of the results are also included.

Which of the following is not needed to be known to calculate a confidenceinterval?
a. standard deviation
b. sample size
c. mean
d. degree of confidence

What is the area under the standard normal distribution curve between z = 1.50 and z = 2.50?
A) 0.0802
B) 0.0606
C) 0.0764
D) 1.00
Identify the degree of confidence displayed in the confidenceinterval shown below.
A) 90%
B) 95%
C) 98%
D) 99%
If the sample mean is 10, the hypothesized population mean is 9

Please help with the following problems.
1. For df = 25, determine the value of A that corresponds to each of the following probabilities:
a.P(t > A) = 0.25
b. P( < A) = 0.10
c. P(-A < t < A) = .99
2. Given the following observations in a simple random sample from a population that is approximately normally distrib

If x bar =75, S = 24, and n = 36, and assuming that the population is normally distributed, construct a 95% confidenceinterval estimate of the population mean, ยต.

A laboratory tested eleven chickens and found that the mean amount of cholesterol was 244 milligrams with s = 24.92 milligrams. Construct a 95 percent confidenceinterval for the true mean cholesterol content of all such eggs. Assume that the population has a normal distribution.

Use the given degree of confidenceand sample data to find a confidenceinterval for the population standard deviation o. Assume that the population has a normal distribution.
Weights of men: 90% confidence; n=14, Xbar=160.9lb, s=12.6lb

In a random sample of 62 bolts, the mean length was 1.87 inches and the standard deviation was 0.07 inch. Use a normal distribution or a t-distribution to construct a 90% confidenceinterval or the mean.
Which distribution should be used to construct the 90% confidenceinterval?
A. Use a normal distribution because the len

A local university administers a comprehensive examination to the candidates for B.S. degrees in Business Administration. Five examinations are selected at random and scored. The scores are shown below.
Grades
80
90
91
62
77
I am interested in the overall performance for all candidates of a B.S. degree. The populati