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
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

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

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Excel Assignment 2 on Introduction to Computer Programming | COMP 112, Assignments of Computer Science

Wentworth Institute of Technology (WIT)Computer Science
Prof. Robert Goldstein

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

Typology: Assignments

Pre 2010

Uploaded on 08/18/2009

koofers-user-7um-1
koofers-user-7um-1 🇺🇸

5

(1)

9 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 - Fall, 2008
Homework 5 – Excel Assignment 2
Instructor: Bob Goldstein (617) 912-2512
[email protected]
[email protected]
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: October 21, 2008
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/qkd3hz-384616-2764983-homework5-doc.doc 1 11/29/2020 11/29/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 Excel Assignment 2 on Introduction to Computer Programming | 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 - Fall, 2008

Homework 5 – Excel Assignment 2

Instructor: Bob Goldstein (617) 912- [email protected] [email protected] 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: October 21, 2008 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/qkd3hz-384616-2764983-homework5-doc.doc 1 11/29/2020 11/29/ 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