Project analytical techniques as well as decision-making skills on a business problem ( Quantitative Analysis for Business Decisions )

종료 등록 시간: 1개월 전 착불
종료 착불

Project Description, the Data Set, and Specific Problems are available

Make sure you study the information in the "Project Description" data sheet first.

Learning Goal

In this project, you will have a chance to showcase your analytical techniques as well as decision-making skills on a business problem. As the outcome of this project, you will make judgements that are informed by data analyses.

The Case

You are an investment consultant. An important client of yours wants to invest in real estate in a U.S. city that has been experiencing an uptick in growth. The client wants to purchase 10 real estate properties that will have the highest sales prices in the future. She pre-selected 25 potential houses that appear to be good deals. You job is to predict the sales prices of the 25 properties as close to reality as possible. Based on your prediction, you need to make the decision on which 10 properties (i.e., ranked highest in future sale prices) to invest.

To make predictions, the broker of the properties has given you the relevant information of the pre-selected 25 potential houses. The information contained in the “Prediction” data sheet.

In addition, you are given data collected on 125 houses sold in the city over the past 2 years. These data are contained in the “Sales” data sheet. The data collected on the houses include:

1. ID – the property ID, which is the unique IDs of the real estate properties

2. House Size – the size of the house in square feet

3. Lot Size– the size of the lot in acres

4. Rooms – the total number of rooms in the house

5. Bathrooms –the number of bathrooms in the house

6. Utilities – this describes the average monthly utility cost (in $)

7. Year Built – this describes the year when the house was constructed

8. Overall Condition – this is a rating of the overall condition of the house. The numeric scale of this rating is:

1 – Very Poor 2 – Poor 3 – Fair 4 – Average 5 – Good 6 – Excellent 7 – Very Excellent

9. HOA fee – this describes the monthly homeowner associate fee

10. Nearby School Rating – this is the rating of the property’s school zone

11. Price (in $) – this is the sales price of the houses

Tasks

Your client would like you to help her interpret and eventually predict the house price. So here are your tasks.

1. Estimate a multiple regression equation of house price.

2. Based on the results, what do you think would predict house price? For example, does school rating influence the price of the house? Explain your answers (make sure to report the appropriate statistics that inform your conclusions).

3. The client wants to invest in 10 properties that will have the highest house price in the future. She pre-selected 25 potential houses that appear to be good businesses. You job is to predict the prices of the 25 houses. The data on the 25 potential houses are contained in the “Prediction” sheet.

4. Based on your prediction, you need to make the decision on which 10 houses (i.e., ranked highest in price) to invest in.

Note:

a. Report your soultions/answers to 1, 2, and 4 in the "Report" sheet.

b. For Task #3, fill in the predicted house prices in the "Prediction" sheet.

c. Create a new data sheet (or as many as necessary) to show the relevant output/results of your analyses. You can do this by copying and pasting the StatTools outputs. Highlight relevant results and add comments, where needed. Please know that only the relevant ouputs should be included.

통계 통계 분석 기업 분석 학술연구 저작 엑셀

프로젝트 ID: #38812664

프로젝트 소개

30 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 1개월 전

이 일자리에 대한 프리랜서 30 명의 평균 입찰가: $85

freelancerneyer

Leveraging my extensive educational background and 10+ years of experience, I am confident that I am the ideal candidate to tackle your quantitative analysis project. My Business Administration Master's Degree and ongo 기타

$20 USD (7일 이내)
(1185 리뷰)
8.5
DevBenchHQ

Hi, I can do it in the NEXT FEW HOURS by working on it right now. I would like to help you at a LOW PRICE, HIGH-QUALITY work delivered before TIME. Message me for detailed discussion. Thanks and Looking forward:). I g 기타

$10 USD (1일 이내)
(427 리뷰)
7.2
citijayamala

1. I am an expert in Statistics, Regression analysis, Linear regression analysis, p value, ANOVAs, etc. I use excel and other statistical software like SPSS, STATA, E-views for data analysis and statistical analysis ba 기타

$150 USD (3일 이내)
(295 리뷰)
7.3
eldadshericks

Hello there, I am a Data Analyst by practice, and by using appropriate statistical softwares, I can help you discover facts from your pool of data. I run both quantitative and qualitative analyses, professionally; I us 기타

$30 USD (2일 이내)
(180 리뷰)
6.9
jepita200

Hello there,, I have advanced experience in Data Mining, Statistics, Statistical Analysis and Data Science. With my vast background in data analysis and management, I am confident in my ability to handle your categoric 기타

$20 USD (1일 이내)
(101 리뷰)
5.8
saba106

I am an expert statistician, Research Writer, and data analyst with more than eight years of experience. I have full command of Excel analysis, SPSS, STATA, R LANGUAGE, AND PYTHON. I am an expert in creating time serie 기타

$30 USD (1일 이내)
(47 리뷰)
5.5
SCKRamana

o apply analytical techniques and decision-making skills to a business problem using Quantitative Analysis for Business Decisions Define the Business Problem ex Declining sales Inefficient supply chain Poor customer 기타

$160 USD (2일 이내)
(27 리뷰)
4.6
ranaehtasham

Hello, As a data scientist with expertise in business analytics and a strong background in multiple regression modeling, I can accurately predict the sales prices of the 25 properties using advanced analytical techniq 기타

$25 USD (3일 이내)
(7 리뷰)
2.7
favourprojects25

Hello Project Description, the Data Set, and Specific Problems are available Make sure you study the information in the "Project Description" data sheet first. Learning Goal In this project, you will have a chance to 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
vkvrma3

I am a skilled and experienced content writer with a passion for creating engaging and informative content.

$10 USD (1일 이내)
(0 리뷰)
0.0
abdulg70

Having been an electrical engineer for the past three years, I have honed my Excel and data management skills to efficiently analyze complex projects. Hence, I am confident in taking on the task of estimating a multipl 기타

$10 USD (7일 이내)
(0 리뷰)
0.0
datas3

I am confident in delivering accurate and comprehensive solutions for your project. With my expertise in statistical analysis, Excel, and business analysis, I will ensure a detailed prediction of the sales prices for t 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
sush969156

I'm aware with this technology and all those software which required for this role I'm eager to join this work and can done this work with in a time

$20 USD (7일 이내)
(0 리뷰)
0.0
mftttr

As a professional and as a skilled finance resource who got the exposure to work with big world class conglomerates, had the opportunity to work with world class teams who produced great deliverables in terms insightfu 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
mairamili2115

To Whom It May Concern, As a seasoned data analyst and researcher, I possess both the technical knowledge and the ability to communicate complex findings clearly and compellingly in written form. This combination is e 기타

$15 USD (3일 이내)
(0 리뷰)
0.0
tayub02

Hi, I can predict the sales prices of the 25 properties and help your client make informed investment decisions with confidence. With a Master’s degree in Finance and over 10 years of experience in financial modelin 기타

$200 USD (7일 이내)
(0 리뷰)
0.0
prabodhkumars

I am pleased to assist with predicting house prices to guide your investment decisions. Using tools like StatTools, Excel, and R, I will: Develop a multiple regression model, analyzing key predictors (e.g., school rat 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
Melzubier72

I can do data preparation, develop and train an ML/DL model and develop a GUI(with underlaying objective function) for user/consultant to evaluate options. I would do that job for an amount of 1490USD in 7 working Days 기타

$1490 USD (7일 이내)
(0 리뷰)
0.0
sunx9

I am a PhD holder in Math and have been working on the quantitative model development and analytics roles in financial industry for over 10 years. As an experienced data scientist with a specialized focus on Quantitati 기타

$20 USD (3일 이내)
(0 리뷰)
0.0
chavanvaikhari11

Hi There, I am eager to assist with your project, leveraging my expertise in data analysis and predictive modeling to deliver actionable investment insights. Approach Data Analysis: Review and preprocess the “Sales” 기타

$25 USD (7일 이내)
(0 리뷰)
0.0