- July 18, 2017
- Debbie
- Statistics
- No Comments

**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). (1 mark)

(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). (4 marks)

(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. (5 marks)

Note: when printing the hard copies in (b) please select Page Setup in Excel and then

under Print in the Sheet window, tick the Gridlines and Row and column headings

check boxes. This will ensure that the Excel row and column headings are included

in your Excel printout. The screenshot for printing row and column heading is

attached below for reference.

** **

**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 (4 marks) and a Relative Frequency Pie-

Chart (3 marks) 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? (1 mark)

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

(c) What proportion of properties in your sample consists of weatherboard buildings? (1 mark)

**Task 3 **

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

(b) Use the percentile location formula;

LP =(n+1)p/100, and the three associated rules (Slide 11 of Week 2 Seminar,Session 1) (1 mark) to determine:

(i) The 70 th percentile. (1 mark)

(ii) The first and third quartiles. (2 mark)

(c) Briefly explain what the 70 th percentile that you have determined informs you about

your sample “Sold Price” data. (2 mark)

(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.(3 marks)

**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. (4 marks)

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

inner fence limits;

IFUL = Q 3 + 1.5 x IQR (1.5 marks) and IFLL = Q1 – 1.5 x IQR (1.5 marks)

(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 5:**

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

(ii) an appropriate measure of dispersion for your sample “Sold Price” data. (1 mark)

Provide a brief explanation of the reasoning behind your choice in both cases. (1 mark)

**Task 6**

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. ( 2 marks)

(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). (4 marks)

(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).

**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: (2 marks)

(i) A point estimate of the proportion of brick veneer properties in the population.(1 mark)

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

(b) Using the following formula:

(sample statistic) (critical z or t) (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. (4 marks)

(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.

Post Views:
116

- Visitors Dataset – Conversion Rate – Job Value – Data Analysis Assignment Help
- COIT20247 :Database Design And Development – Data Modelling – ER Model Assignment Help
- Evidence Selection & Critical Appraisal Using CASP – PICO framework – Nursing Assignment Help
- Effectiveness of Resistance Machines vs Free Weight Training – Trifocus Fitness Academy – Research Project Help
- 100897: Everyday Life – Masculinity – Everyday LifeEveryday Life Assignment Help

All the assignments are checked for the plagiarism and its types by our expert quality assurance team of TV Assignment Help. So, we assure you that every assignment will be 100% percent authentic and original.

The assignments are delivered much before the assignment deadline and we even work on urgent basis. Our experts work accordingly to make the delivery possible before time so that you can ask for revisions.

Please send us a Text on

+61 426 106 697

All documents prepared at TV Assignment Help are written by subject-specific experts who are certified from various renowned universities. Every assignment is checked by our “**Quality Assurance Team**” to check on the quality.

We serve you with our premium services at reasonable prices. You can even compare our prices with other assignment help services to clear your doubts. We even offer seasonal and referral discounts.

Kevin Edward

Queensland

TV391

TV Assignment Help amazed me! In order to do my assignment, I’ve read a lot of sources, but nothing helped. But, the kind of assignment help TV Assignment Help provided was beyond my request. Appreciate your hard work and would definitely recommend you to my fellow mates.
Bacar Silva Jaura

Brisbane

TV386

I approached TV Assignment Help for my dissertation paper. They helped me not only in writing my dissertation, but also to proofread it. I believe that their experts can cope up with any writing you need. The final output had all the relevant points which were mentioned by me. Thank you so much for helping me in writing my dissertation. I highly recommend TV Assignment Help!
Brayden Chan

Adelaide

TV347

I would say that TV Assignment Help has a clear view of how a good assignment should be written. As I ordered an SPSS assignment, and the final result was totally satisfying. The quality of work was really high and it met the standards of writing I needed. You guys are an A+ for me.
Nhatquyen Phan

Perth

TV338

TV Assignment Help serve students by providing high-quality assignments. It was such a relief for me as they provided me the assignment on-time and that too without any errors. I did not have to proofread it again and again, as their experts have done a quality work. Thank You, Guys!
Sagar Chettri

Melbourne

TV490

I had a management assignment due in 10 hours and had no clue what to do. TV Assignment Help turned up as a savior, as I ordered a paper with them and what I got shocked me. Their expert was able to provide the assignment despite the short deadline. The writer delivered a great assignment which got me good grade.
Vinod Mandava

Sydney

TV413

In my opinion, TV Assignment Help is doing an amazing job! I have taken assignment help from them and I like the guarantees they offer, as well as the ability to provide best-discounted offers. They provided my assignments before the deadline. I must say that TV Assignment Help provides what they promise.**Disclaimer 1.1**: The assignment delivery time by TvAssignmentHelp is contingent on the level of expertise, total word count and the technicalities involved.

**Disclaimer 1.2**: The academic papers provided by TvAssignmentHelp are for reference purpose only and not to be used as it is.

* Terms and Conditions Apply

© Copyright 2014 - 2018 TvAssignmentHelp. All Rights Reserved.