How many properties in your sample consist of brick building

Assignment Help Applied Statistics

Reference no: EM131450110

Assignment Part I

Part I of the assignment simply requires the submission of a hard copy of your sample property data presented in a maximum of no more than 3 printed pages in total. (See the Assignment Part I Model Answer). This sample data set will form the basis of the statistical presentation and analysis tasks contained in Part II of the assignment.

Task 1

(a) Make a hard copy of your Random Number Table containing the following:

(i) The highlight of the starting row and starting column of the sample selection process. (Refer to the Assignment Part I Model Answer).

(ii) The strikethrough/mark on the three digits good numbers and the cross-out of the repeated number(s). (Refer to the Assignment Part I Model Answer).

(b) Print a hard copy (see note below) of your sample property data (9 columns x 51 rows of data plus the column headings row) from the Excel file (SamplePropertyData) obtained per the above instructions.

Assignment Part II

Answers to the six assignment tasks in Part II must be based on the sample data file that you have created in Part I. All tasks in this assignment require you to obtain an Excel output prior to performing some analysis. Copy and Paste these outputs to your assignment MS- Word document immediately preceding any subsequent analysis. Explanations must be precise and to the point. Charts and tables must have appropriate titles and numerical values must be rounded to an appropriate number of decimal places and accompanied by the correct units of measure.

Task 2

Use Excel to produce a Frequency Column Chart and a Relative Frequency Pie-Chart for your sample to show the number and proportion, respectively, of each building type.

Use these graphical summaries to answer the following questions:

(a) How many properties in your sample consist of brick buildings?

(b) Which building type occurs most frequently in your sample?

Task 3

(a) Use Excel to sort your sample "Sold Price" data and paste into your MS Word assignment document.

(b) Use the percentile location formula;
, and the three associated rules (Slide 11 of Week 2 Seminar, Session 1) to determine:

(i) The 70th percentile.

(ii) The first and third quartiles.

(d) Determine the Inter-Quartile Range of your sample "Sold Price" data and provide a brief explanation of what information this statistic provides about your sample data.

Task 4

(a) Use Excel to produce a Descriptive Statistics table for your sample "Sold Price" data and paste into your MS Word assignment document.

(b) Use results from Task 3 to determine manually for this data, the upper and lower inner fence limits;

IFUL = Q3 + 1.5 x IQR

and IFLL = Q1 - 1.5 x IQR

(c) Based on the limits calculated in (b), choose from the numerical summary measures provided in the Descriptive Statistics table, and/or measures calculated previously in Task 3;

(i) an appropriate measure of central tendency, and,

(ii) an appropriate measure of dispersion for your sample "Sold Price" data.

Provide a brief explanation of the reasoning behind your choice in both cases.

Task 5

Remember to show all working! Failure to do so will result in the loss of marks.

(a) From the Descriptive Statistics table obtained in Task 5, identity three pieces of evidence that indicate whether your sample "Sold Price" data has been obtained from a normally distributed population or not. What is your conclusion? Note: Make sure only one piece of evidence relates to the shape of the sample data.

(b) Regardless of your conclusion in above, assume the "Sold Price" population data is normally distributed. Applying the Standard Normal tables, calculate how many "Sold Price" observations in your sample would expect to lie within 1.5 standard deviations of the mean (i.e. between z = -1.5 and z = +1.5).

(c) Use the mean and standard deviation from the Descriptive Statistics table of Task 5 to calculate the bound for 1.5 standard deviation spread from the mean. Using the "Sold Price" sample data, manually count the number of observations fall within the bound. State whether this count matches, approximately, your answer to (b) and hence whether this result confirms (or not) your conclusion in (a). (4 marks)

Task 6

Remember to show all working! Failure to do so will result in the loss of marks.

(a) Use Excel to produce a Descriptive Statistics table for the "Sold Price" variable in your sample suitable for constructing an interval estimate of the population mean "Sold Price". Hence determine:

(i) A point estimate of the mean "Sold Price" of the population of properties.

(ii) A 90% confidence interval estimate of the mean "Sold Price" of the population of properties.

(iii) Make a brief verbal statement explaining the meaning of the confidence interval estimate obtained in (ii) in the context of the variable in this task.

(b) If the population mean "Sold Price" is actually 650 ($000s), would you consider the interval estimate obtained in (a), to be satisfactory? Explain why or why not.

Task 7

Remember to show all working! Failure to do so will result in the loss of marks.

(a) Use Excel to produce a Descriptive Statistics table for the brick veneer properties in your sample suitable for constructing an interval estimate of the population proportion of brick veneer properties. Hence determine:

(i) A point estimate of the proportion of brick veneer properties in the population.
(ii) A 99% confidence interval estimate of the proportion of brick veneer properties in the population.

(b) Using the following formula:

(sample statistic) ± (critical z or t) x (standard error of the sample statistic)

Use the rule of thumb for good normal approximation (Slide 3 of Week 7 Session 2) for proportion, then the Empirical Rule (Slide 8 of Week 5 Session 1) for a Normal distribution to determine a 95% confidence interval estimate of the proportion of brick veneer properties in the population.

(c) Compare, in terms of the precision, the interval manually calculated in (b) with the interval obtained from the Descriptive Statistics table in (a). Explain why the direction of the change in precision is expected.

Attachment:- Business Statistics Assignment Tasks.zip

Reference no: EM131450110

Questions Cloud

Provide an amortization schedule for the first year : Please provide an amortization schedule for the first year for a $100,000 mortgage with a 6 percent rate and 30 month amortization period.

Can you think of procedural justice implications : Few topics in the business press have grabbed more headlines recently than highly lucrative annual bonuses for top management.

Evaluate the two evaluation instruments used in the fabrics : Critique the organizational analysis conducted for Fabrics, Inc. and determine if there are other questions that should have been asked.

A qualified residence cannot be a recreational vehicle : A qualified residence cannot be a recreational vehicle. The amount a taxpayer can deduct for home mortgage interest is unlimited.

How many properties in your sample consist of brick building : BE01106 - BUSINESS STATISTICS How many properties in your sample consist of brick buildings - Which building type occurs most frequently in your sample and Determine the Inter-Quartile Range of your sample "Sold Price" data and provide a brief expla..

What aspects of motivation might workplace bullying reduce : After a long weekend, Kara stared at her computer with a sick feeling in her stomach: her boss had added her as a friend on Facebook.

Calculate the amount the firm would need on the present date : Calculate the amount the firm would need on the present date as savings to cover the expected liability.Calculate the amount the firm would need to set aside.

What are the motivational benefits of intrinsic rewards : What are the motivational benefits of intrinsic rewards? Assessing Employee Motivation and Satisfaction Using the Job Characteristics Model.

How can government and schools help to encourage recycling : Name three types of HAZARDOUS WASTES and indicate how they are disposed of. How can local government and schools help to encourage recycling?

Reviews

len1450110

4/4/2017 2:17:03 AM

Presentation • Your answers must be presented in task number order and be clearly labelled with the appropriate task number. • Your assignment must be presented in Microsoft (MS) Word. Copy and paste any relevant Excel outputs to this document immediately before (above) any relevant written answers to each task. • If you are unfamiliar with the use of the MS Word Equations Editor, you may write algebraic - mathematical - statistical symbols and notation in neat handwritten form. • Your answers must be clear. You must highlight relevant items on any required Excel outputs and make reference to them in your written answers. • When asked to perform a manual calculation (i.e. the use of MS Excel is not specified) you must show all working. This must include intermediate steps where relevant. Failure to do so will result in a loss of marks. • Completed assignments are to be presented for correction on A4 paper, stapled in the top left hand corner. You are permitted to print on both sides of the paper. Colour printing is recommended for graphs-charts. If printed as greyscale, be mindful and creative to make the greyscales distinct shades.

len1450110

4/4/2017 2:15:12 AM

The assignment must be submitted in hard copy. An Assessment Declaration (the form can be downloaded from the Assessment Information page on the unit website) is required and must be stapled to the front of your assignment. To avoid any complications associated with misplaced assignments, make a copy of your assignment before you hand in the original to your seminar leader for correction. Although we will discuss the assignment tasks in the seminars, you will need to complete the tasks in your own time. For most students, Assignment Part I tasks can be completed within one hour on average. It is recommended that to start working on the assignment the earlier the better and do not leave it to the last minute.

len1450110

4/4/2017 2:14:58 AM

assignment has a total of seven (7) tasks for students to complete. Each task accounts for 10 marks. The total marks available for the entire assignment is 70. The assignment accounts for 35% of the overall assessment in the unit. So the total mark you receive for your assignment will be converted to a mark (out of 35) before being aggregated with your test and examination marks to produce your final result for the unit. The assignment consists of two parts. Part I is to collect a set of sample data which will be used to answer six questions in Part II. In Week 4, 5, 6 and 7, the Model assignment questions will be discussed during the seminar sessions. This will assist you to understand the requirements for those questions. Both Part I and II must be submitted together for correction due in the seminar of week 8. Late submission will be penalised by 1 mark per day for a maximum of 5 working days.

len1450110

4/4/2017 2:12:55 AM

Please do keep all the works you calculate or write and attach them as well when you send the final document Please do keep all the works that will written or calculated and send them with the final document when ready. I need them as proofs. The referencing style is Harvard. My last ID 3 digits are 184. Please make sure you do the right number (refer to file, RandomNumbers2014).

Write a Review

Required(*) Message

Applied Statistics Questions & Answers

How much vince required to pay when he paid his balance in f

If Vince charged $200 on his credit card with 18% APR and he paid his balance in full within the grace period, how much was he required to pay?

Identify the sampling technique

Identify the sampling technique being used. Every 20th patient that comes into the emergency room is given a satisfaction survey upon their discharge.

State the appropriate null and alternative hypotheses

State the appropriate null and alternative hypotheses. Assuming the population standard deviation is known to be $2,500 and the significance level for the test is to be 0.05, what is the critical value (stated in dollars)

Risk factors using a multivariate analysis

The authors stated that they controlled for confounding many risk factors using a multivariate analysis. State an alternative method that the authors could have used to control for confounding in the design or analysis.

Pros and cons of the mean and the median

Investigate the comprative pros and cons of the mean and the median. Find examples where the mean is more appropriate than the median and vice-versa. Discuss the locations of the mean, median and mode for a normal, left-skewed and right-skewed distri..

Prevalence of hyperglycemia

A recent study reported that the prevalence of hyperlipidemia (defines as total cholesterol over 200) is 30 % in children 2 to 6 years old of age. If 12 children are analyzed. a) What is the probability that at least 3 are hyperlipidemia? b) What is ..

Describe a "real world" scenario

Respond to the following to describe a "real world" scenario where a researcher might want to construct a confidence interval to support a conclusion about a population parameter.1.Provide an overview of the scenario and the variable involved. Includ..

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!

Submit Assignment

User Account

All Pages