Graphing data for investors
Not what you're looking for?
I need to analyze data (portion of the retirement investment portfolio) and graph the not so obvious info (such as total value) in a bar, pie, and line graph.
I need to do this in excel and come up with formulas, name for the graphs, Y' and X's.
What information should I be looking for as an investor (that's meaningful and not obvious)?
Which info is suitable with which graph?
Data is as follows:
Stock # Shares 9/30/96 10/31/96 11/30/96 12/31/96 1/31/97 2/28/97
CHV 65 62.63 65.75 67.00 65.00 63.38 64.50
GE 38 91.00 96.75 104.00 98.88 103.50 102.88
GM 50 48.00 53.63 57.63 55.75 59.00 57.88
IP 41 42.50 42.63 42.50 40.50 40.88 41.63
MRK 30 70.38 73.88 83.00 79.63 90.63 92.13
MMM 45 69.75 76.38 83.75 83.00 82.25 92.00
Purchase this Solution
Solution Summary
This works with analyzing data and information that investors should look at. Graphing data for investors are provided.
Solution Preview
I'll assume you have all of your data in a Excel spreadsheet with each name, number, price, or date in a separate cell. In my spreadsheet I have the stocks in rows and the date is different for each column.
Your suggestion of a looking the "Total Value of Portfolio" is a good start. In this case, what is important is how the the value is change with time. So I would construct a line graph with the dates along the x axis and the total value in dollars of the portfolio at each time. You will need a formula that sums the product of the # of shares and the price for each equity.
An example of such a formula would be:
=$B2*C2+$B3*C3+$B4*C4+$B5*C5+$B6*C6+$B7*C7
(of course your cells might be ...
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.