anyone familiar with regression analysis in excel?

[Benjamin Baites]

Hey, I have a range of data.

Revenue, People, Income, Competitors, Price.

I need to do a regression analysis to find the best location for a new store... which depends on these variables...


Number of people living within1 km of the store ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]PEOPLE[/FONT][/FONT])
Mean income of the households within 1 km of the store ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]INCOM[/FONT][/FONT]E)
Number of competitors within 1 km of the store ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]COMPTORS[/FONT][/FONT])
Rental price of a newly released movie ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]PRICE[/FONT][/FONT])

I need to do a randomrandomly select 50 video stores and record the value of each of the variables listed above plus annual gross revenue ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]REVENUE[/FONT][/FONT]).

then use this data to list a series of information like explain how people, income, competitors and price affect the dependent variable.

Anyone have an idea where to start with this? I've never used excel to do something like this and my regression analysis is pretty scratchy, haven't done it in years.

Cheers

 

[tusharm]

Dunno if this will help...
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/publish_train/data_analysis/16.htm

Hey, I have a range of data.

Revenue, People, Income, Competitors, Price.

I need to do a regression analysis to find the best location for a new store... which depends on these variables...


Number of people living within1 km of the store ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]PEOPLE[/FONT][/FONT])
Mean income of the households within 1 km of the store ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]INCOM[/FONT][/FONT]E)
Number of competitors within 1 km of the store ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]COMPTORS[/FONT][/FONT])
Rental price of a newly released movie ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]PRICE[/FONT][/FONT])

I need to do a randomrandomly select 50 video stores and record the value of each of the variables listed above plus annual gross revenue ([FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]REVENUE[/FONT][/FONT]).

then use this data to list a series of information like explain how people, income, competitors and price affect the dependent variable.

Anyone have an idea where to start with this? I've never used excel to do something like this and my regression analysis is pretty scratchy, haven't done it in years.

Cheers

 

[Benjamin Baites]

cheers for that mate!!

Having a read now, looking pretty complex the further it goes down