Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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

1 answer below »
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
Answered Same Day Jun 02, 2021

Solution

Bolla V V Satyanarayana answered on Jun 04 2021
130 Votes
1. Histogram
First, we convert the Frequency distribution of data in profit variable
Number of classes = 10
We find minimum value of the data using Excel function
=MIN(A2:A71)
=13000
We find Maximum value of data using Excel function
=MAX(A2:A71)
=236000
Using Excel function
= (236000-13000)/10
= 22300
Class interval = 22300
Using This class interval we create the frequency distribution using Excel software
    Lower value
    Upper value
    Bin range
    Frequency
    13000
    35300
    35300
    2
    35301
    57601
    57601
    3
    57602
    79902
    79902
    7
    79903
    102203
    102203
    17
    102204
    124504
    124504
    11
    124505
    146805
    146805
    11
    146806
    169106
    169106
    5
    169107
    191407
    191407
    9
    191408
    213708
    213708
    2
    213709
    236009
    236009
    3
     
     
    Total
    70
i) Using Excel software to draw the Histogram of the Profit variable to the following data
Ogive:
Using Excel software to draw the Ogive curve to the following data
ii) Box Plot:
Using Excel software to draw Box plot to the following data
Interpretation of Box plot: All the points falls on top of the middle line so the data follows positively skewed distribution.
2.90% confidence interval for unknow population mean of Age
Formulae
Using Excel software
term called as Margin of E
or or confidence level
Where
is the Population mean of Age
is the sample mean of Age
n is the sample size
is the level of significance = 1-0.90 = 0.10
n-1 = 70-1 = 69
S is the sample standard deviation
Using Excel software to obtain these values of Age variable to the following procedure
Step 1: Click the Data option on the top
Step 2: Click the Data Analysis on the top
Step 3: Analysis popup window was opened
Age variable data in the Coolum D in the main sheet
Step 4: Enter this data range $D$1:$D$71 in the input range box
Step 5: Please mark the Label box
Step 6: Select the Summary statistic and Confidence level for mean
Step 7: Enter the 90 in the confidence level for mean box
Step 8: Click Ok
We get this output
    Age
    Mean
    12.71142857
    Standard E
o
    0.49916926
    Median
    11.75
    Mode
    20.2
    Standard Deviation
    4.17634966
    Sample Variance
    17.44189648
    Kurtosis
    -0.488652429
    Skewness
    0.752854761
    Range
    16
    Minimum
    6.7
    Maximum
    22.7
    Sum
    889.8
    Count
    70
    Confidence Level(90.0%)
    0.832234232
From the output
Sample mean = 12.7114
Sample Standard deviation = 4.1763
Sample size =70

Thus the 90% confidence for the Mean Age is lies between 11.8792 and 13.5436
3.We want to test the hypothesis that the average business Is significantly more than 15 employees
Null hypothesis: The average business is not significantly more than 15 employees
Alternative hypothesis: The average business is significantly more than 15 employees
Level of significance value = 0.05
Test statistic:
Under the null hypothesis(H0) The test statistical value can be defined
Where
is the Population mean of number of employees
is the sample mean of number of employees
is the sample size
is the sample standard deviation

Using Excel software to obtain these values of Employees variable to the following procedure
Step 1: Click the Data option on the top
Step 2: Click the Data Analysis on the top
Step 3: Analysis popup window was opened
Employee variable data in the Coolum D in the main sheet
Step...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here