Microsoft Word - Assignment questions- Details-Exemplar Q2 2020.docx
Page 1 of 3
COMPUTER ASSIGNMENT Quarter XXXXXXXXXX
SCHOOL OF COMPUTER, DATA & MATHEMATICAL SCIENCES
Student surname
Student first name
Student ID
Signature
Unit Name: Applied Business Statistics
Unit Number: XXXXXXXXXX
Due Date: By 5pm Monday, 08/06/2020 (vUWS submission time closes at 5pm)
Number of Questions: 5
Value: out of 20 worth 20%
Total Number of Pages: 3
Unit Coordinator: Dr Kenan Matawie
INSTRUCTIONS TO CANDIDATES
(1) The data will be provided for you and you must download them from vUWS/“My Grades”
under column “Assignment Data”. This file will contain data sets for the following questions.
You should find and download the data set assigned for your only and not any other student.
Follow the instruction how to copy the data to excel sheet given in “PDF to Excel” file.
(2) You should use Excel only to ca
y out all calculations and statistical analyses.
Students should consult the Excel details in the textbook and details found on vUWS, starting
with excel Data Analysis, workbooks., DAP and certain excel functions.
(3) To complete this assignment, you must provide the Excel outputs for each of the questions
in a report.
(4) Your assignment submitted must be typed and word-processed with Excel output
copy/paste .
(5) The maximum number of pages for each submission is Five (5), not including the cover page.
No mark will be given if the number of pages exceeds the limit.
(6) The assignment is to be submitted by 5pm, 08/6/2020. On
vUWS/assessment/Assignment/”submit your assignment here”. The closing time for
submission is 5pm sharp.
(7) Any late assignments will be penalised as mentioned in the Learning Guide.
(8) Exemplar is given at the end of the question, how you present your Excel and typed answers.
Page 2 of 3
A study was commissioned to investigate the characteristics of local businesses. Data was collected
on 70 local businesses and the following variables recorded.
Column 1 Profit What was your 2014 profit?
Column 2 Type Is the business privately held, publicly traded or a franchise?
(Private = 1, Public = 2, Franchise = 3)
Column 3 Employee How many employees work at your business?
Column 4 Age How old is the company (in years)?
Column 5 Location Where is the company? (1 = Pa
amatta CBD, 2 = Sydney CBD). If you
find this variable is copied to excel as a text convert it to numerical
efore you do the analysis.
QUESTION 1 (4 marks)
(i) Produce a histogram and Ogive of the Profit variable considering 10 classes.
(ii) Produce a Box plot for Profit.
QUESTION 2 (3 marks)
Calculate a 90% confidence interval for the unknown population mean of the Age “business age”.
QUESTION 3 (4 marks)
Test, at the 5% level of significance, whether the average business has more than 15 employees.
QUESTION 4 (3 marks)
Can we conclude at 1% level of significant that the presentation (appearance or proportion) of
usiness location 1 = Pa
amatta CBD and 2 = Sydney CBD is the same.
QUESTION 5 (6 marks)
(i) Estimate the regression equation to predict the Profit (y) from the number of
employee (x).
(ii) Determine the coefficient of determination.
(iii) Does the data provide evidence that the slope of the equation from part (i) is
positive? Perform an appropriate hypothesis test using a 10% level of
significance.
(iv) Present the co
elation coefficient of the Profit and number of employee and the
significant of this co
elation.
NOTE: The data was randomly created for the sole purpose of this assignment.
The data can be assumed to be normally distributed for all continuous variables
Page 3 of 3
DATA SET: 009
THIS DATA SET NUMBER SHOULD APPEAR AT THE BEGINNING OF YOUR ASSIGNMENT
FAILURE TO COMPLY WITH THIS REQUEST WILL RESULT IN A 10% PENALTY
Profit Type Employees Age Location
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX XXXXXXXXXX
XXXXXXXXXX9.1