Gold Price Data Excel

gold price data excel
In need of desperate help! :( regression question…?

I have been given some data containing prices of oil, gold, 3 month tbill, SP500 and nasdaq. I need to create a regression, but i dont know which one to use as the independent variable. Does anyone have any idea what im suppose to do?
Also I have two years of data. should i do a regression for each year?
Also can anyone tell me what the solver in excel is used for? and how I could use it?
Any pointers would be much appreciated.
Thank you!
sorry i have little information! I need to come up with a hypothesis and create a multiple regression.

The choice of regression depends on what you want out of it (which you haven’t said). One of the simplest one to try is the Least Squares fit, which Excel is capable of doing.

The solver in Excel is used for constrained optimization problems, such as: What is the maximal area of a rectangular region you can build a fence around, if the perimeter of the fence must be <= 300 feet? (The latter limitation is called a constraint, and reflects real-world limitations, e.g. availability of only a certain amount of fence material.)

LACIE PRICE #22


Avery Easy Peel Address Labels for Laser Printers, 1 x 2.625 Inches, White, Pack of 750 (05260)


Avery Easy Peel Address Labels for Laser Printers, 1 x 2.625 Inches, White, Pack of 750 (05260)


$5.99


Avery White Address Labels make high-volume mailings more manageable. Avery White Address Labels make high-volume mailings more manageable. The Easy Peel feature conveniently exposes label edges so you can remove each label quickly. Just start with an easy-to-use, free template from avery.com. Then print your customized labels directly from your laser printer. They’re jam free and smudge free, so …


Leave a comment

Your comment