Lab 5 Questions Fall 2006


	Welcome to CS1315. Click on the python to add comments. Looking for the book? They have it at the Engineer's Bookstore at 748 Marietta St NW. Here is there website: http://www.engrbookstore.com/ - Monica

Hotspots: Slides and Code • TA Corner • Comments? • Announcements • FAQ • Static Webspace

Lab 5 Questions Fall 2006

Lab 5 Questions go here:

In column F, would you still like us to have the 1000 separator? (,)

I think in the column F all the commas should be removed. -Albert d'Heurle

on getting way line-like formation...I am getting confused. what do we do for part 1? and if i do it how i thik, it throws off all the other instructions.

After you download or create the text file with the stock prices you must follow the instructions on this page. Please let me know if you have more questions. -Albert d'Heurle

You didn't understand my question...it was about the instructions...the part I'm referring to is unclear. #1 under Wave line-live Formation...it makes no sense...you want us to drag the info from the cell to the bottom then sort it with the info gone...and have it just sit there?

This section is referring to the formation of a graph. If you need further instructions please go see a TA, or recitation, or see me. -Albert d'Heurle

In the Error bars part of the lab, it says that there is a button that allows you to select the range. Then it says to simply choose Column G, yet when I click the button the only thing I'm allowed to do it type. I tried to type column G and it tells me that there is an error.

Click on the sheet tab to take you to your data (not the graph). Then click on column G. Excel will insert a range reference into the field for you. Colin Potts

are we suppose to add an absolute formula to our sheet, or is it just extra info to know?

I am also wondering about this. Do we need to do anything with the absolute cell reference ($) symbol?

This is extra, valuable knowledge for your edification and fulfillment. It might possibly come up on the final :) but you don't need it for the lab. Colin Potts

When I try to save my excel as StockInfo.xls, it won't let me save the chart and the excel spreadsheet in the same file. It says I must save them separetly because the "workbook" cannot save them together. Please help :)

Try copying the data and graph to a new workbook and save that. If it doesn't work, just submit it as 2 different files and send an email to your grading TA about it. - Bobby Mathew

Make sure you are saving it as an excel file. You have to go to "Save As" otherwise it is just a text file.

I am getting the error "the maximum number of data points you can use in a 2-D chart is 32,000. If you want to use more than 32,000 points, you must create two or more series. What's that all about in reference to my chart?

It has something to do with the way you set the columns to graph. You won't lose any points if the message comes up, as long as your graph is right,. - Bobby Mathew

Can/Should we edit the cells and make them wider, so that the whole title we type at the top can be shown?

You can make it wider if you want. Don't edit any original data. - Bobby Mathew

I2 shouldn't have any information in it right? Since it is the percent change and there is no day that becomes before the first one to be able to calculate it.

You can leave it blank. If you put 0%, that's fine too. - Bobby Mathew

ok...I think I might be wrong with this but when I copied and pasted G and H colums all the way down, all of G reads ABS(E2-C2) and H reads ABS(E2-D2)...is that right or do we have to change the forumla according to each cell its in? Oh and I got that '2-D chart is 32,000' error thing too.

Calculate the formula for the first cell (in this case, G2). Then select G2 and do the copy/paste instructions. Same goes for the H column. That should work. -Alexa Heddinger

You mean you're getting the text "ABS(E2-C2)" displayed in the cells? In that case, you have to tell Excel that it's a formula. Precede it with an equals sign: "=ABS(E2-C2)" in the first cell and then copy again. Colin Potts

Do percent changes need to be positive?

No, they can be negative. - Bobby Mathew

If we have a 0.00% percent change, what color does that need to be? Does it need to be bold?

0% can be considered positive, so make it bold. - Bobby Mathew

My chart gives me the '32000 max' error as well but the chart still changes. Should I just leave it alone or do you guys suggest anything?

You can leave it as it is. - Bobby Mathew

are we suppose to do anything with the $ signs and the Absolute formulae, or it that just put into to the lab for our general knowledge?

See above. Colin Potts

When calculating the percent change, should the first day, E2, be left blank because there is no data for the previous day? Or have I completely misunderstood the formula?

Is webwork down?? I'm not able to submit the lab :(

Sorry, not E2, but I2 ((E2-E1)/E1—>does not exist, right?)

You can leave it blank. If you put 0%, that's fine too. - Bobby Mathew

Just kidding about webwork....

Should there be a title for column I?

Why not? Colin Potts

I guess I should have asked if there was a specific title we should use for column I or if it's okay to just make one up?

No, there is no specified title. Colin Potts

how do we find the historical price page on yahoo

http://finance.yahoo.com/q/hp?s=DIS Toni Walden

do the values in columns G and H need to be to two decimal places?

No. But generally, spreadsheets look more professional if the figures in a column or series are formatted similarly, so go ahead and do this if you want to. Colin Potts

As a general rule, if you want to add a personal touch by doing something to your spreadsheet that does not contradict the letter or spirit of the assignment, go ahead and do it. (E.g. Make up your own title for column I, format cells to have two decimal places, change the color of the graph, add additional labels, etc.) We won't deduct marks for this. The purpose of the labs is to educate, not bore you. However, please read the assignment carefully and follow the instructions. Colin Potts

On the step Labeled "Rounding Third Base, I've Seen This On TV Right?: Error Bars"
After selecting "Y Error Bars", "Both", and "Custom". I typed column G into the "+" and column H into the "-". However, when I click "OK", I recieve and error stating "the formula you typed contains an error."

What is going wrong?

See above. Colin Potts

uhh, if our positive changes are already supposed to be in bold and black and the assignment says choose another condition that applies to positive numbers and make it bold and black... how is the change suppossed to appear? Can I, for example, make all positive numbers bold and green, and numbers bigger than 1 in bold and black?

No, the instructions are just spelling out the second condition (positive = black and bold). "On your own" just means that you have to follow the same steps as for (negative = red and bold). You don't have to make up another condition. Colin Potts

Is the formula for column H (motion below) =ABS(E2-D2) (close-low)?

yes that is the formula I have.

on the last instruction, it says to make the positive percentages bold (and by default black) and the negative values bold and red. Then it says to add another formatting to the positive values, but leaving them bold and black. But they are already bold and black... so how would we change it? What do you want us to do? I dont understand! haha. please help! :)

See above. Colin Potts

I dont have any negative Data in Column I to format red, is that bad?

On the last instruction, should all the rowws in column I be affected of only 12-down?

Ok, the error bars portion... I keep getting a typing-only prompt too. I tried to follow what Dr.Potts said in the above answer, but its not working. The only sheet tab I see drops down under format, and that doesn't do what we need it to. Can someone PLEASE explain how to do this???

You should have two spreadsheets in your workbook. The first, the real spreadsheet, is the table of numbers. The second is the graph. You need to be in the table spreadsheet to click on the column. Don't type in "G" into the form; just click on the column. Excel will fill something into the form when you do. Colin Potts

Does anyone know if there is something wrong with webwork?

If it isnt working, just email the file to your grading TA by 11:59pm tonight. - Bobby Mathew

I cant find any information that is supposed to be in "I" where was it in the instructions on what to put in their. Currently I have that section formatted without any data.

It is in the section titled "Did I Win? Do I Get To Goto Vegas Tomorrow?" Colin Potts

Do we have to put our names somewhere?

There is no negative data for me to format into red text in column I, is this bad?

Very, very bad ;) Since this is a column of percentage differences, I think that the only way that you are winding up with no negatives is that you are still using the ABS function as you did in the previous columns. Column I should not consist of absolute differences. Colin Potts

yeah, there's no negative numbers in the I column for some reason. The column seems to compute it but ignore if it's positive or negative. When I try and switch it with the number format it just continues to ignore it. Somebody? Anybody?

See above. Colin Potts

I am getting the error "the maximum number of data points you can use in a 2-D chart is 32,000. If you want to use more than 32,000 points, you must create two or more series. And visually there are no error bars, however if I make x error bars instead of y error bars they appear? so which one would you like us to do?

nvm, I figured out I graphed the wrong Information thnx

I couldn't find the option 3/14/01 when changing the date format of column A. The closest thing was 3-14-01. Is that good enough?

Link to this Page

Fall 2006 Lab 5 JES portion last edited on 3 November 2006 at 11:44 pm by r33h37.res.gatech.edu