country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

Question:

Class Participation and Attendance (10%) During the trimester students will discuss various Statistics issues and cases, which are noted in the prescribed textbook. Active student participation in the lectures and tutorials is essential to the learning process. All students are expected to be prepared for and contribute to the lecture and tutorial discussions. To assist in your understanding of Statistics issues, you are encouraged to contribute to in-class discussions. Your participation and interaction with other students will be a major component of the class instruction. Part of your class participation will also be based upon your ability to recognise contemporary statistical issues. As this is a graduate Bachelor of Business unit, regular and active participation in lecture and tutorial discussions is expected from every student each week.
 
Participation in this unit will be compiled and noted for each week. Please contact your Lecturer/Tutor as soon as possible if you are unable to participate in class discussions for any length of time (e.g., more than two “working” days in a row, weekends not included). Students are expected to ask and answer questions in all discussions. Points for class participation and completion of other class assignments will be recorded. Attendance at 10 lectures and tutorials as a minimum per student, per trimester is expected. Students are expected to participate throughout the entire trimester, including during the training session presentations made by other groups. Please note: Your attendance in class is a necessary, but not sufficient, condition for good participation. (Just showing up for work, but not contributing anything to the organisation, would not generally be considered acceptable behaviour in the workplace.) Please participate, and feel free to share your experiences as long as they are relevant.
 
The assignment has a total of six tasks to complete. For the assignment you need to create your own data set using the data provided as LGAData.xls excel file. 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 or 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. Do not include the assignment questions nor the data with your submitted assignment. Introduction The Assignment Data (LGAData.xls) file contains, LGA data (sourced from ABS) for a population of 400 LGA in Australia. You are required to select a random sample of 50 LGA from this population. Variables in the data set are as below: PN ID number ID V1 LGA name Name V2 Gender Male=1; Female=0 V3 Age Group 30-34 =1; 35-39=2; 39-44 =3; 45-50=4 V4 Age1 number of people 30-34 years old V5 Age2 number of people 35-39 years old V6 Age3 number of people 39-44 years old V7 Age4 number of people 45-50 years old V8 Income category $650-$800=0;
 
$801-$850=1 V9 Income1 number of people with $650-$800 weekly income V10 Income2 number of people with $801-$850 weekly income V11 Occupation type Managers=1; Professionals=2;Sales workers=3;Administration=4 V12 Occupation1 number of Managers V13 Occupation2 number of Professionals V14 Occupation3 number of Sales workers V15 Occupation4 number of Administration V16 Industry of occupation Mining=1; Agriculture=2;Manufacturing=3;Education=4 V17 Industry1 number of people in Mining V18 Industry2 number of people in Agriculture V19 Industry3 number of people in Manufacturing V20 Industry4 number of people in Education V21 Transport 0=car; 1=public transport V22 Living with children 0=with; 1=without Column A (PN), contains the LGA identification numbers from 001 to 400 LGA. 5 Selecting Random Sample and Creating your Sample Data File To select your random sample, you need to open the PopulationLGAData.
 
xls file and create a SampleLGAData Excel file of 50 samples (rows) which will include 50 LGA. To select these samples randomly one member of the group starts with 2 last digits of their student ID and adds 50 to it to create the data set. For example a student with ID of MIT172256 will start with row 56 to add 50 rows to it which will include rows 56-106. Then the data set for this group will include LGA 56-106. You will need to submit a SOFT copy of your sample LGAdata. You will also need to report what student ID was used for random data selection. This sample data set will form the basis of the statistical presentation and analysis tasks of the assignment. Assignment requirements Answers to the assignment tasks must be based on the sample data file that you have created. 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. 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 1 (10 marks) 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 people under each age group. Use these graphical summaries to answer the following questions: (a) How many LGA in your sample indicate use of public transport? (b) Which occupation type occurs most frequently in your sample? (c) What proportion of LGA in your sample consists of people within 30-34 years old age group? Task 2 (10 marks) (a) Use Excel to sort your sample “occupation 4” data.
 
Use the percentile location formula; LP = (n +1) P 100 , and the three associated rules to determine: (i) The 70th percentile. (ii) The first and third quartiles. Remember to show all working! (b) Briefly explain what the 70th percentile that you have determined informs you about your sample “occupation 4” data. (c) Determine the Inter-Quartile Range of your sample “occupation 4” data and provide a brief explanation of what information this statistic provides about your sample data. 6 Task 3 (15 marks) (a) Use Excel to produce a Descriptive Statistics table for your sample “occupation 4” data. (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 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 4; (i) an appropriate measure of central tendency, and, (ii) an appropriate measure of dispersion for your sample “occupation 4”data. Remember to show all working! Provide a brief explanation of the reasoning behind your choice in both cases. (d) Write a brief report on the “occupation 4” data paying particular attention, on the mean, median, quartiles and measures of variation. Task 4 (15 marks) 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 4, identity three pieces of evidence that indicate whether your sample “occupation 4” 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 “occupation 4” data is normally distributed.
 
Applying the Standard Normal tables, calculate how many “occupation 4” 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 4 to calculate the bound for 1.5 standard deviation spread from the mean. Using the “occupation 4” 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 5 (15 marks) (a) Use Excel to produce a Descriptive Statistics table for the “Occupation 4” variable in your sample suitable for constructing an interval estimate of the population mean “Occupation 4” Hence determine:
 
(i) A point estimate of the mean “Occupation 4” of the population.
(ii) A 90% confidence interval estimate of the mean “Occupation 4” of the population.
(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 “Occupation 4”is actually 59, would you consider the interval estimate obtained in
(a), to be satisfactory? Explain why or why not. 7 Task 6 (15 marks)
(a) Use Excel to produce a Descriptive Statistics table for the $650-$800 income earners in your sample suitable for constructing an interval estimate of the population proportion of income earners. Hence determine:
(i) A point estimate of the proportion of $650-$800 income earners in the population.
(ii) A 99% confidence interval estimate of the $650-$800 income earners.
(b) Using the following formula: (sample statistic) ? (critical z or t) ? (standard error of the sample statistic) Use the Empirical Rule for a Normal distribution to determine a 95% confidence interval estimate of the $650-$800 income earners 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.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 9 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Business Statistics. Retrieved from https://myassignmenthelp.com/free-samples/bb-108-business-statistics/percentile-location-formula.html.

My Assignment Help (2020) Business Statistics [Online]. Available from: https://myassignmenthelp.com/free-samples/bb-108-business-statistics/percentile-location-formula.html
[Accessed 01 December 2020].

My Assignment Help. 'Business Statistics' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/bb-108-business-statistics/percentile-location-formula.html> accessed 01 December 2020.

My Assignment Help. Business Statistics [Internet]. My Assignment Help. 2020 [cited 01 December 2020]. Available from: https://myassignmenthelp.com/free-samples/bb-108-business-statistics/percentile-location-formula.html.


MyAssignmenthelp.com delivers assignment help to millions of students of USA. We have in-house teams of assignment writers who are experts on wide ranges of subjects. We have appointed teams of native writers who provide assignment help to students in New York City and all over the USA. They are skilled assignment writers who successfully cater to search terms like do my assignment in the USA

Latest Business Law Samples

BULAW2611 Organisations Law

Download : 0 | Pages : 10
  • Course Code: BULAW2611
  • University: Federation University Australia
  • Country: Australia

Answer: Background It has been observed that the Inquiry had recognized a number of shortcomings in CBA’s governance, culture and the accountability frameworks especially while dealing with the non-financial risks that had made a set of recommendations, which were designed to strengthen these particular frameworks. Such a statement was established and announced by the Prudential Inquiry on August 28, 2017. The purpose of its establishme...

Read More arrow

BUSI2301 Business Law

Download : 0 | Pages : 3
  • Course Code: BUSI2301
  • University: Panola College
  • Country: United States

Answer: 1. Statement of the problem Peter, a chartered accountant, was bored with his job and was applied to a software company in Oshawa for a new position in the development of new accounting software. The job description described the new project which was expected to run during the next eleven years, and as a promised position he would become a senior manager to supervise his own employees if hired. Peter accepted the offer immediately ev...

Read More arrow

LML6004 Australias Visa System 2

Download : 0 | Pages : 9
  • Course Code: LML6004
  • University: Victoria University
  • Country: Australia

Answer: Introduction: In this letter of advice I would provide you information in relation to employer sponsor visas available in Australia. The information provided to you would be based on the types of visa available, the sponsorship, nomination and other requirements to get the visa and what the visa allows and restricts a visa holder to do. There are three types of employer sponsored visa which can be selected from in order to temporarily...

Read More arrow

LAW5003 Principles Of Torts

Download : 0 | Pages : 11
  • Course Code: LAW5003
  • University: Murdoch University
  • Country: Australia

Answer: Introduction The below case study discusses about tort law and major tort law question “Is it possible to frame an action in both trespass and negligence based on the same set of facts? If so, identify instances when trespass may be more attractive to a plaintiff? This paper discusses about the case Williams v Milotin [1957] 97 CLR 465 and major significance and implications of the decision. This case is related to trespass...

Read More arrow

HI6027 Business And Corporate Law

Download : 0 | Pages : 9

Answers: 1. Issue Whether Jenny would be bound to the exclusion clause which the bus services have attempted to incorporate into the contract Law An express term is a term of the contract which has been contemplated by the parties and can be added in a contract via a notice or signature. In the case of L'Estrange V Graucob [1934] 2 KB 394 a rule had been made by the judges according to which any person who has got into a contract thr...

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,506,361

Orders

4.9/5

Overall Rating

5,101

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1592 Order Completed

96% Response Time

Jane Sima

Ph.D in Psychology with Specialization in Industrial-Organizational Psychology

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

798 Order Completed

97% Response Time

Benjamin Blakeman

MSc in Medical Technology

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1265 Order Completed

97% Response Time

James Cook

Masters in Management

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

416 Order Completed

95% Response Time

Tyler Moore

MBA in Accounting

Washington, United States

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Phenomenal service and very quick in terms of their response/action. Yet to be graded. But, after having a read through, can confirm their quick response did not compromise quality. Will definitely be in touch again with MyAssignmentHelp on future pr...

flag

User Id: 557641 - 01 Dec 2020

Australia

student rating student rating student rating student rating student rating

great service, they really helped me with a good price I will definitely use this cite till I graduate

flag

User Id: 549690 - 30 Nov 2020

Australia

student rating student rating student rating student rating student rating

Very nice answers. All of the questions were well answered and allowed me to understand the subject very well.

flag

User Id: 472407 - 29 Nov 2020

Australia

student rating student rating student rating student rating student rating

The quality of work is excellent! Since I have so many assignments to do, I am scared of late submission. They give me back the work on the same day. High efficiency.

flag

User Id: 554448 - 28 Nov 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?