Data Analytics

Chapter 3, Question #11- The first file- Construct an appropriate chart to show the relative value of funds in each investment category in the Excel file Retirement Portfolio.

This question will be manually graded.

Chapter 4 . —– 19 question – Construct an appropriate chart to show the relative value of funds in each investment category in the Excel file Retirement Portfolio. ——-

Chapter 4 —- 21 question . – Use a Pivot Table to construct a cross-tabulation for marital status and housing type for the Base Data worksheet in the Excel file Credit Risk Data — chapter 4, question 66 Compute the z-scores for the data in the Excel file Airport Service Times. How many observations fall farther than three standard deviations from either side of the mean? Would you consider these as outliers? Why or why not? CHAPTER 6: question 33 Using data in the Excel file Colleges and Universities, find 95% confidence intervals for the median SAT for each of the two groups, liberal arts colleges and research universities. Based on these confidence intervals, does there appear to be a difference in the median SAT scores between the two groups? Chapter 7- question 16- Using the data in the Excel file Airport Service Times, determine if the airline can claim that its average service time is less than 2.5 minutes.