Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Homework 6: Advanced Excel Skills - Assignment | COMP 112, Assignments of Computer Science

Material Type: Assignment; Professor: Goldstein; Class: INTRO TO COMP & PRG-LOCAL 103; Subject: Computer Science; University: Wentworth Institute of Technology; Term: Spring 2009;

Typology: Assignments

Pre 2010

Uploaded on 08/19/2009

koofers-user-5d0
koofers-user-5d0 🇺🇸

10 documents

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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
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

Partial preview of the text

Download Homework 6: Advanced Excel Skills - Assignment | COMP 112 and more Assignments Computer Science in PDF only on Docsity!

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- 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

1995199619971998199920002001200220032004 Year Value (Dollars) POPS MOMS

  1. Add a third series of your choosing to the above plots Extra Credit
  2. Add a second value (Y) axis on the right that is “Inflation Corrected Value” (as shown on the right)
  3. 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 = ax + b + csin(x) /app/work/qkdauc-472558-2765005-homework6-doc.doc 1 12/3/2020 12/3/ My Stocks 0 50 100 150 200 250 1995199619971998199920002001200220032004 Year Value (Dollars) 0 50 100 150 200 Inflation Corrected Value POPS MOMS Series 0 5 10 15 20 25 30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22