BE01106 Business Statistics Statistics Assignment.

Questions : 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.

(ii) The strikethrough/mark on the three digits good numbers and the cross-out of the repeated number(s). (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. 2.Use Excel to produce a Frequency Column Chart (4 marks) 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?

(c) What proportion of properties in your sample consists of weatherboard buildings? 3.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

December 2, 2022

December 2, 2022

December 2, 2022