Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

OFFICE WOULD THE AUTHOR OF THE WORK. You have been hired as Credit Analyst, at BAB Real Estate Co LTD. You are required to clean

image text in transcribed
OFFICE WOULD THE AUTHOR OF THE WORK. You have been hired as Credit Analyst, at BAB Real Estate Co LTD. You are required to clean house prices data and perform exploratory data analysis of the data. Task: with reference to the Excel file attached here to, perform Part C (Sales Analysis) 1. Merge cells CG5 and CHS and enter Sales Analysis 2. Enter "Least Selling Price" in " CG6 " and in " CH6 ", compute the least selling price from the "SalePrice" column. 3. Enter "Average Selling Price" in "CG7" and in "CH7", compute the mean selling price from the "SalePrice" column. 4. Enter "Highest Selling Price" in "CG8" and in "CH8", compute the highest selling price from the "SalePrice" column. Part D 1. Merge cells CG10 and CH10 2. Cell CGIl will act as a dynamic placeholder that, whatever data you enter in there, provided it exists in your dataset

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

The Handbook Of Sentiment Analysis In Finance

Authors: Gautam Mitra, Xiang Yu

1st Edition

1910571571, 978-1910571576

More Books

Students also viewed these Finance questions