average rent

Completed Posted Aug 11, 2014 Paid on delivery
Completed Paid on delivery

Hello, I am looking to get some thing built in excel if possible. The file attached shows rental units in Calgary. I am looking for a average broken down by the following:

a count of how many listing were used for the average

City

Quadrant

community

Type of home

sq footage within + or - 200

Bedrooms

Bathrooms

For example if there is a listing in Calgary in the same quadrant and community that is a house 1800 sq feet with 3 bedrooms and 2 bathrooms and one is listed for 2000 and the other listed for 2200 the average rent for that area for a house that size is 2100. If the home was more than 200 sq bigger or a different type of home or area then it can not be averaged as it considerably bigger and in a different location or type.

I would like to have a excel sheet where I can copy and paste the same data I attached to get the averages when I need to.

Thanks!

Algorithm Excel Mathematics Matlab and Mathematica Statistics

Project ID: #6310819

About the project

15 proposals Remote project Active Aug 12, 2014

Awarded to:

ethicalboy

Hello ready to start asap to deliver you, If you can give me your notes and conditions although it seems clear about calculating average, if you like we can work on other statistics as well, I am not sure how are you f More

$250 CAD in 3 days
(70 Reviews)
5.5

15 freelancers are bidding on average $349 for this job

ognjen011

A proposal has not yet been provided

$250 CAD in 3 days
(48 Reviews)
5.7
expertatwork

hey there -are you using WINDOWS or MAC ? We can design a rent template where you can copy-paste the new data and the average rent would be calculated as per your specifications. Please reply, we can discuss further, t More

$250 CAD in 1 day
(66 Reviews)
4.9
CaptVo

Hey there fellow Canadian :) seems like a fairly straight forward task I would love to help you out on. I've been using Excel every day for as long as I can remember, and have a statistics and business background (the More

$250 CAD in 3 days
(12 Reviews)
4.4
mirabueno319

I can do this for you. I am proficient in Microsoft Excel. In a previous project, I mad a file that automatically calculates the commission for an employee depending on the current and running outputs. I can finish More

$250 CAD in 1 day
(10 Reviews)
4.0
k00lcaptchrz

Hi, I have done a lot of projects in Excel. I Have enough experience in excel and I am sure that i can do Your Project quickly and as per your requirement. Ready to start asap. Looking forward to hear from You so More

$277 CAD in 2 days
(24 Reviews)
4.0
prithvi81

Hi, I can provide such sheet where you just put raw data in one of sheet and all tables all refresh in other columns with various category need and in future also can add more tables there....thanks!!

$400 CAD in 3 days
(8 Reviews)
3.8
applnet

Hi, sir. I am expert in excel. I have much in builting excel sheet. I can do this correctly. Regards.

$250 CAD in 3 days
(4 Reviews)
3.1
saminatinny

I would like to work on your this project. I'm new in freelancer.com but not know in this sector. I have more than 4 years experience in this sector. So willing to response to discuss about the project. Thanks and More

$250 CAD in 10 days
(2 Reviews)
0.2
xokoe

I am working at excel automation and VBA programming at HSBC Paris. I can Help you extract averages you want within 10 to 20 Hours of work. I hope we can work together. Kind regards. Adrien

$333 CAD in 1 day
(0 Reviews)
0.0
matthewbaker78

Hello, I would pleased to complete your project for you. I'm business major and have just finished freshening up on the newer version of excel at the top of my class. If necessary I can have references sent to you. Als More

$288 CAD in 10 days
(0 Reviews)
0.0
ish105

I will make a user-friendly application for you with a graphical user-interface using VB.net. It will include the rental info database in the back end and options for retrieving the database as required. I do similar p More

$1000 CAD in 10 days
(0 Reviews)
0.0
dehaanj4

I am ready to be hired by you for your post. I have all the skills and experience that makes me a competitive candidate for this post. I am a Business student at the University of Alberta in Canada seeking to sharpen m More

$643 CAD in 10 days
(0 Reviews)
0.0