Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the provided dataset, conduct an analysis to determine how the rental price of an apartment is influenced by its square footage, number of bedrooms,

Using the provided dataset, conduct an analysis to determine how the rental price of an apartment is influenced by its square footage, number of bedrooms, and proximity to public transportation.
Instructions:
Use a maximum of 3000 words excluding references.
The report should be structured into 4 sections:
1.1 Introduction
1.2 Discussion of Findings
1.3 Conclusion
1.4 Appendix (where large output tables should be presented)
Apply concepts of correlation, regression, and hypothesis testing to support your analysis.
Do not share your responses, as doing so will result in a mark of 0.
apartment_data_v1.csv
Make Model Price Year Kilometer Fuel Type Transmission Location Color Owner Seller Type Engine Max Power Max Torque Drivetrain Length Width Height Seating Capacity Fuel Tank Capacity
Honda Amaze 1.2 VX i-VTEC 505000201787150 Petrol Manual Pune Grey First Corporate 1198 cc 87 bhp @ 6000 rpm 109 Nm @ 4500 rpm FWD 399016801505535
Maruti Suzuki Swift DZire VDI 450000201475000 Diesel Manual Ludhiana White Second Individual 1248 cc 74 bhp @ 4000 rpm 190 Nm @ 2000 rpm FWD 399516951555542
Hyundai i10 Magna 1.2 Kappa2220000201167000 Petrol Manual Lucknow Maroon First Individual 1197 cc 79 bhp @ 6000 rpm 112.7619 Nm @ 4000 rpm FWD 358515951550535
Toyota Glanza G 799000201937500 Petrol Manual Mangalore Red First Individual 1197 cc 82 bhp @ 6000 rpm 113 Nm @ 4200 rpm FWD 399517451510537
Toyota Innova 2.4 VX 7 STR [2016-2020]1950000201869000 Diesel Manual Mumbai Grey First Individual 2393 cc 148 bhp @ 3400 rpm 343 Nm @ 1400 rpm RWD 473518301795755
Maruti Suzuki Ciaz ZXi 675000201773315 Petrol Manual Pune Grey First Individual 1373 cc 91 bhp @ 6000 rpm 130 Nm @ 4000 rpm FWD 449017301485543
Mercedes-Benz CLA 200 Petrol Sport 1898999201547000 Petrol Automatic Mumbai White Second Individual 1991 cc 181 bhp @ 5500 rpm 300 Nm @ 1200 rpm FWD 4630177714325
BMW X1 xDrive20d M Sport 2650000201775000 Diesel Automatic Coimbatore White Second Individual 1995 cc 188 bhp @ 4000 rpm 400 Nm @ 1750 rpm AWD 443918211612551
Skoda Octavia 1.8 TSI Style Plus AT [2017]1390000201756000 Petrol Automatic Mumbai White First Individual 1798 cc 177 bhp @ 5100 rpm 250 Nm @ 1250 rpm FWD 467018141476550
Nissan Terrano XL (D)575000201585000 Diesel Manual Mumbai White First Individual 1461 cc 84 bhp @ 3750 rpm 200 Nm @ 1900 rpm FWD 433118221671550
Hyundai Elite i20 Sportz 1.2591000201720281 Petrol Manual Mumbai Red First Individual 1197 cc 82 bhp @ 6000 rpm 115 Nm @ 4000 rpm FWD 398517341505545
Renault Kwid 1.0 RXT [2016-2019]459999201822541 Petrol Manual Bangalore Grey First Individual 999 cc 67 bhp @ 5500 rpm 91 Nm @ 4250 rpm FWD 367915791478528
Maruti Suzuki Ciaz Alpha Hybrid 1.5 AT [2018-2020]1075000201930672 Petrol Automatic Bangalore Blue First Individual 1462 cc 103 bhp @ 6000 rpm 138 Nm @ 4400 rpm FWD 449017301485543
Tata Harrier XZ [2019-2020]1695000201920856 Diesel Manual Bangalore Orange First Individual 1956 cc 138 bhp @ 3750 rpm 350 Nm @ 1750 rpm FWD 459818941706550
Volkswagen Polo GT TSI 944999201741417 Petrol Automatic Bangalore Grey First Individual 1197 cc 103 bhp @ 5000 rpm 175 Nm @ 1500 rpm FWD 397116821469545
Maruti Suzuki Celerio ZXi AMT [2019-2020]569000201611471 Petrol Automatic Bangalore Red First Individual 998 cc 67 bhp @ 6000 rpm 90 Nm @ 3500 rpm FWD 369516001560535
Maruti Suzuki Alto 800 LXi (O)44900020193583 Petrol Manual Bangalore Grey First Individual 796 cc 47 bhp @ 6000 rpm 69 Nm @ 3500 rpm FWD 344515151475535
Maruti Suzuki Baleno Alpha Automatic 894999201821365 Petrol Automatic Bangalore Grey First Individual 1197 cc 82 bhp @ 6000 rpm 113 Nm @ 4200 rpm FWD 399517451510537
Maruti Suzuki Wagon R ZXi 1.2 AMT 699000202030777 Petrol Automatic Bangalore White First Individual 1197 cc 82 bhp @ 6000 rpm 113 Nm @ 4200 rpm FWD 365516201675532
Hyundai Creta 1.6 E Petrol 740000201660125 Petrol Manual Delhi Silver First Individual 1591 cc 122 bhp @ 6400 rpm 154 Nm @ 4850 rpm FWD 427017801630560
Maruti Suzuki S-Presso VXi AMT 47000020202169 Petrol Automatic Mumbai Grey First Individual 998 cc 67 bhp @ 5500 rpm 90 Nm @ 3500 rpm FWD 356515201564527
Volkswagen Vento Comfortline Petrol AT 765000201560240 Petrol Automatic Bangalore Brown First Individual 1197 cc 103 bhp @ 5000 rpm 153 Nm @ 3800 rpm FWD 438416991466555
Hyundai Santro Sportz AMT [2018-2020]589000201813772 Petrol Automatic Bangalore White First Individual 1086 cc 68 bhp @ 5500 rpm 99 Nm @ 4500 rpm FWD 361016451560535
Hyundai Venue SX 1.0(O) Petrol [2019-2020]999000201927464 Petrol Manual Bangalore Blue First Individual 998 cc 118 bhp @

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions