Hey.

I was wondering if you guys could help me with some excel problems? I really hope there are some excel fanatics in here...

For the first one, I know how to obtain the values from the net and get the lines. What I don't know how to do is forecast 20 periods into the future using the regression equation. Could you guys instruct me on that?

1) This is the problem.

From yahoo, obtain a series of prices for an individual stock or for the Dow Jones Industrial or some other standard average.(at least 100 data points). Create an appropriate chart of the data. Fit three trend lines to the data, using technology. Include the equation and R2 for all models. Also, use the model that best fits the data to forecast 20 periods into the future, using technology and the regression equation. I am suppose to have a seperate chart for each regression model.
----
Now for the second one, I have no clue what to do.

2)

In this problem, I am asked to create a worksheet that allows me to enter the location of the ticket desired, the age of the person, and the price of the ticket. I am given the following data to complete the assignment: Box seats are $98, lower deck seats are $54, and upper deck seats are $32. Children (under 16) are half price. Seniors (65 and over) receive a $12 discount.
If the person types in an illegal seat the worksheet should inform the user. I can use as many cells as I want. I am suppose to try the worksheet for box seats for a 65 year old, lower deck for a 12 year old, and dugout for a 28 year old, and box for an 16 year old.

I'd be very thankful if you guys could help me with these worksheets. :)