Exploratory analysis of the data, Basic Statistics

Assignment Help:

The Home Improvement Company (HIC) operates five stores in a large regional area. The company wished to study the relationship between x, house value ($'000) and Y, yearly expenditure on house maintenance ($ upkeep) as a basis for promoting the types of products it sells.

A random sample of the owners of 40 houses was taken. They were asked to estimate their maintenance expenditure on the types of products HIC sells. HIC then contacted real estate agents to value the houses. See the data file.

The task of modelling the relationship between Upkeep (Y) and Value (x) was assigned to an analyst within HIC. All the data had been validated and the analyst was instructed not to delete data for 'statistical convenience'.

Part (a)

You are to decide which of the three models below are most appropriate, where Y = estimated maintenance spend (upkeep) and x = house value

Y= β0 + β1x +ε

Log(Y) = β01x +ε

√y = β01x +ε

Your report for Part (a) should start with an exploratory analysis of the data, and then three sections, detailing the analyses of models (1), (2) and (3) and then a short recommendation.

You should analyse and report leverage points and outliers where appropriate using the template below but you cannot remove any data.


Related Discussions:- Exploratory analysis of the data

Mean Deviation, Mean Deviation The two methods of dispersion discussed abo...

Mean Deviation The two methods of dispersion discussed above namely range and quartile deviation are not measure of dispersion in the strict sense of te term because they do not s

Inventory, An audit of the accounting records of Loch Ness Ltd. for the yea...

An audit of the accounting records of Loch Ness Ltd. for the year ending 30 June 2012 discovered that the ending inventory balance was over-valued by $35,000. Upon further investig

Balance sheet-actual reserves , (a)   The bank's excess reserves are its ac...

(a)   The bank's excess reserves are its actual reserves less required reserves. Actual reserves are given as $450 from its balance sheet. Required reserves are given by the produc

Balance sheet assignment, The High Company Balance Sheet Assignment (to be...

The High Company Balance Sheet Assignment (to be completed using Microsoft Excel) -Create T accounts for each transaction #1-10 -Create a trial balance -Create Income Statement -

Administering agency solutions, Administering agency solutions A professio...

Administering agency solutions A professional specific by the Office of Economical Control to provide common management of economic sales action. An administering agency is also a

What is managerial accounting system, Define the Management or Managerial A...

Define the Management or Managerial Accounting System. Ans.  As the name suggest management or managerial accounting system refers to the Management of the firm or company,

Estimate the proportion of lake trout with lamprey scars, In a certain lake...

In a certain lake a limnologist wishes to estimate the proportion of lake trout with lamprey scars. (a) How large of a random sample should be taken if the limnologist has no pr

Accounting Assumption, What are the consequences of non-compliance to each ...

What are the consequences of non-compliance to each accounting concepts?

Change in the performance of the lamps between the dates, Q.2. (ii) A compa...

Q.2. (ii) A company making lamps has drawn a sample from its production line and measured the light output from each. The results, in microamps, are as follows: 9.1 9.8 9.5

Generally accepted accounting principles-gaap, Generally Accepted Accountin...

Generally Accepted Accounting Principles-GAAP:  GAAP is an Americanized term for the accounting standards and procedures that need to be followed by companies while compiling their

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd