Wentworth Institute of Technology
Division of Professional and Continuing Studies
COMP112 Section 71 – Introduction to Computers and Programming - Spring, 2009
Homework 6 – Excel Assignment 2
Instructor: Bob Goldstein (617) 912-2512
bobg@vision.eri.harvard.edu
robert.goldstein@schepens.harvard.edu
http://home.comcast.net/~goldsteinr/Courses/index.html
http://goldstein.eri.harvard.edu/courses/index.html
http://myweb.wit.edu/goldsteinr/Courses/index.html
Due Date: April 13, 2009
Hand In: Excel document as specified (via email)
Purpose:
This homework is intended to exercise more advanced Excel skills
Description:
1. Download the EXCEL file MyThreeStock.txt from the course website and import it into EXCEL
2. Use the data in that file to make the below graph. Make sure the graph has the following features:
a. A linear trend line for stock POPS and a cubic trend line for stock MOMS
b. White plot area with no gridlines
c. Legend inside the plot
d. Y axis has units of 50 with minimum 0 and maximum 250 with Fontsize 18
e. X axis fontsize 14
f. POPS series has black solid square marker with size 8, and NO line connecting the points
g. MOMS seris has red solid circle marker with size 8 and NO line connecting the points
h. Title, X and Y axis labels as shown
My Stocks
0
50
100
150
200
250
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
Year
Value (Dollars)
POPS
MOMS
3. Add a third series of your choosing to the above plots
Extra Credit
4. Add a second value (Y) axis on the right that is “Inflation Corrected
Value” (as shown on the right)
5. Download the file FitData.dat from the website , make a completely new worksheet and using the solver, fit it
to the below equation. The line you get should look like the one shown.
Put the resulting values of a,b,c as text annotation on the plot
Y = a*x + b + c*sin(x)
/app/work/qkdauc-472558-2765005-homework6-doc.doc 1 12/3/2020 12/3/2020
My Stocks
0
50
100
150
200
250
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
Year
Value (Dollars)
0
50
100
150
200
Inflation Corrected Value
POPS
MOMS
Series3
0
5
10
15
20
25
30
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1718 19 20 21 22
