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 #1: Use the to calculate this problem. Use the . You should be able to get all answers from that sheet. Copy and paste the output chart with answers. Do not worry about calculating the \”real truth\” as instructions requested. I am only looking for the answers from the file on this one. 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 #2: Use the to calculate this problem. Use the which allows you to copy and paste your raw data into the file for it to calculate. Copy and paste the output chart as well as the bell curve that is underneath the output chart that is the normal prob chart for which the instructions are asking. 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.Complete Problem #3: Use the , the sheet at the bottom for (sheet 3). You can\’t copy and paste raw data here. You must count the number of successes by sorting the student data file by major and counting the # of Finance majors. Copy and paste the relative charts here as you did in #2.
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]