Homework Help is Here – Start Your Trial Now!
Math
Statistics
Price on: JNJ JNJ 1.00 MSFT 0.94 T -0.15 WFC 0.97 WMT 0.63 XOM 0.66 1/2/2013 12/31/2014 Balance Correlation Table T MSFT 1.00 -0.23 0.95 0.59 0.59 MSFT 27.62 46.45 1.00 -0.28 0.12 0.03 Analysis T 35 33.59 WFC 1.00 0.56 0.69 WMT 1.00 0.25 JNJ WFC WMT XOM 70.84 35.05 69.24 88.71 104.57 54.82 85.88 92.45 Growth 47.61% 68.18% -4.03% 56.41% 24.03% 15.58% In the cells below, determine how much $100 of each stock would be worth on 12/31/2014 if you purchased it on 1/2/2013. XOM 1.00

Price on: JNJ JNJ 1.00 MSFT 0.94 T -0.15 WFC 0.97 WMT 0.63 XOM 0.66 1/2/2013 12/31/2014 Balance Correlation Table T MSFT 1.00 -0.23 0.95 0.59 0.59 MSFT 27.62 46.45 1.00 -0.28 0.12 0.03 Analysis T 35 33.59 WFC 1.00 0.56 0.69 WMT 1.00 0.25 JNJ WFC WMT XOM 70.84 35.05 69.24 88.71 104.57 54.82 85.88 92.45 Growth 47.61% 68.18% -4.03% 56.41% 24.03% 15.58% In the cells below, determine how much $100 of each stock would be worth on 12/31/2014 if you purchased it on 1/2/2013. XOM 1.00

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question

hello,

can someone help me with how I would know what excel formula to use in order to figure out stock?

A B с E F $83.83 $91.70 D 12/16/2014 $102.76 $45.16 $32.14 $52.77 $82.96 12/15/2014 $103.96 $46.67 $32.25 $53.19 $83.94 12/12/2014 $104.43 $46.95 $32.16 $53.70 $83.81 12/11/2014 $106.72 $47.17 $32.71 12/10/2014 $106.24 $46.90 $32.49 $54.26 $82.98 12/9/2014 $108.05 $47.59 $32.89 $54.83 $83.56 12/8/2014 $108.52 $47.70 $33.88 $54.77 $84.23 12/5/2014 $108.51 $48.42 $33.94 $55.03 $84.12 $93.82 12/4/2014 $107.56 $48.84 $33.91 $54.50 $84.76 $94.37 12/3/2014 $107.72 $48.08 $34.00 $54.39 $84.94 $94.95 12/2/2014 $108.51 $48.46 $34.29 $54.22 $86.40 $94.19 12/1/2014 $108.03 $48.62 $35.06 $53.82 $86.22 $92.35 11/28/2014 $108.25 $47.81 $35.38 $54.48 $87.54 $90.54 11/26/2014 $107.21 $47.75 $35.13 $54.28 $84.98 $94.48 11/25/2014 $106.70 $47.47 $34.82 $53.88 $84.95 $94.78 11/24/2014 $106.88 $47.59 $34.70 $54.10 $85.40 11/21/2014 $107.86 $47.98 $35.28 $53.81 $84.65 $96.81 11/20/2014 $108.18 $48.70 $35.28 $53.48 $84.58 $95.72 $95.82 G $86.41 $86.90 $86.60 $89.20 $88.67 $91.38 H Price on: J JNJ JNJ 1.00 MSFT 0.94 T -0.15 0.97 0.63 0.66 WFC WMT XOM Balance JNJ 70.84 1/2/2013 12/31/2014 104.57 K Correlation Table T MSFT L 1.00 -0.23 0.95 0.59 0.59 - 1.00 -0.28 0.12 0.03 Analysis T M WFC 1.00 0.56 0.69 N 3.41 WMT 1.00 0.25 WMT XOM 69.24 MSFT 27.62 46.45 47.61% 68.18% -4.03% 56.41% 24.03% 15.58% WFC 35.05 54.82 88.71 35 33.59 85.88 92.45 Growth In the cells below, determine how much $100 of each stock would be worth on 12/31/2014 if you purchased it on 1/2/2013. XOM 1.00 P
Transcribed Image Text:A B с E F $83.83 $91.70 D 12/16/2014 $102.76 $45.16 $32.14 $52.77 $82.96 12/15/2014 $103.96 $46.67 $32.25 $53.19 $83.94 12/12/2014 $104.43 $46.95 $32.16 $53.70 $83.81 12/11/2014 $106.72 $47.17 $32.71 12/10/2014 $106.24 $46.90 $32.49 $54.26 $82.98 12/9/2014 $108.05 $47.59 $32.89 $54.83 $83.56 12/8/2014 $108.52 $47.70 $33.88 $54.77 $84.23 12/5/2014 $108.51 $48.42 $33.94 $55.03 $84.12 $93.82 12/4/2014 $107.56 $48.84 $33.91 $54.50 $84.76 $94.37 12/3/2014 $107.72 $48.08 $34.00 $54.39 $84.94 $94.95 12/2/2014 $108.51 $48.46 $34.29 $54.22 $86.40 $94.19 12/1/2014 $108.03 $48.62 $35.06 $53.82 $86.22 $92.35 11/28/2014 $108.25 $47.81 $35.38 $54.48 $87.54 $90.54 11/26/2014 $107.21 $47.75 $35.13 $54.28 $84.98 $94.48 11/25/2014 $106.70 $47.47 $34.82 $53.88 $84.95 $94.78 11/24/2014 $106.88 $47.59 $34.70 $54.10 $85.40 11/21/2014 $107.86 $47.98 $35.28 $53.81 $84.65 $96.81 11/20/2014 $108.18 $48.70 $35.28 $53.48 $84.58 $95.72 $95.82 G $86.41 $86.90 $86.60 $89.20 $88.67 $91.38 H Price on: J JNJ JNJ 1.00 MSFT 0.94 T -0.15 0.97 0.63 0.66 WFC WMT XOM Balance JNJ 70.84 1/2/2013 12/31/2014 104.57 K Correlation Table T MSFT L 1.00 -0.23 0.95 0.59 0.59 - 1.00 -0.28 0.12 0.03 Analysis T M WFC 1.00 0.56 0.69 N 3.41 WMT 1.00 0.25 WMT XOM 69.24 MSFT 27.62 46.45 47.61% 68.18% -4.03% 56.41% 24.03% 15.58% WFC 35.05 54.82 88.71 35 33.59 85.88 92.45 Growth In the cells below, determine how much $100 of each stock would be worth on 12/31/2014 if you purchased it on 1/2/2013. XOM 1.00 P
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS