JNTU Excel Worksheet

Hello,

Please answer the following questions mentioned below in excel sheet and sample document also attached please check

Construct an appropriate chart to show the relative value of funds in each investment category in the excel file Retirement Portfolio.

 Find the first,second,and third quartiles for the combined amounts of checking and savings accounts in the excel file Credit Risk Data and interpret the results.

 Use a pivotable to construct a cross-tabulation for marital status and housing type for the Base Data worksheet in the Excel File Risk Data.

 Compute the z-scores for 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?

 Using the data in 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?

 Using the data in excel file Airport Services Times, determine in airline can claim that its average service time is less than 2.5 minutes