Question: Instructions: Please answer these questions using EXCEL. If you don't use EXCEL you will not get any points. Include a printout of the EXCEL file


Instructions: Please answer these questions using EXCEL. If you don't use EXCEL you will not get any points. Include a printout of the EXCEL file showing your work and answers clearly in the submitted report. The report should be submitted as a PDF file Be careful of formatting. Do not include empty pages. 5 points will be awarded for the report format. This is a group project. Up to 5 students can work on this together. Please submit one report per group and make sure all student names are included on the report cover page. Project Question 4 (20 points) Given the following probability distributions for X and Y, compute and interpret: a. Covariance b. Correlation c. E[X + Y] d. E[X2 Y] x 1 6 8 10 p(x) 0.1 0.3 0.25 y 2 9 15 p(y) 0.35 0.3 0.35 Project Question 5 (20 points) Compute the mean, median, 10% trimmed mean, standard deviation, and confidence interval for the following data set. Use significance level of 0.05. ' Student 1 2 3 4 5 5 7 a 82 91 76 45 92 82 63
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
