Project Description: You are a financial advisor, and a client would like you to complete an analysis of his portfolio.

[answerhappygod]

Project Description You Are A Financial Advisor And A Client Would Like You To Complete An Analysis Of His Portfolio 1 (39.31 KiB) Viewed 17 times

Project Description: You are a financial advisor, and a client would like you to complete an analysis of his portfolio. As part of the analysis you will calculate basic descriptive statistics with the Analysis ToolPak, calculate standard devi-ation and variance in value, calculate correlation between asset age and value, and create a stock forecast sheet. Steps to Perform: Step 2 1 32 K 4 5 6 Instructions Start Excel. Download and open the file named Exp19 Excel Ch08 ML1 HW PortfolioAnalysis.xlsx. Grader has automatically added your last name to the beginning of the filename. Use the STDEV.S function to calculate the standard deviation between the current values of all commodities in cell G6. Use the VAR.S function to calculate the variance between the current values of all commodities in cell G9. Ensure the Analysis ToolPak is loaded. Create a descriptive statistics summary based on the current value of investments in column E. Display the output in cell G12. Format the mean, median, mode, minimum, maximum, and sum in the report as Accounting Number Format. Resize the column as needed. Use the FREQUENCY function to calculate the frequency distribution of commodity values based on the values located in the range 16:110. Points Possible 0 14 14 16 10 14