Statistics for Business Decision

Running head: STATISTICS FOR BUSINESS DECISION 1
HOLMES INSTITUTE FACULTY OF HIGHER EDUCATION
HI6007 Group Assignment
(Name of Student)
(University)
(Date of Submission)

STATISTICS FOR BUSINESS DECISION 2
Table of Contents
Introduction:...............................................................................................................................3
Question 1..................................................................................................................................3
Question 2..................................................................................................................................7
Question 3..................................................................................................................................9
Question 4................................................................................................................................11
Conclusion:..............................................................................................................................16
References................................................................................................................................17

STATISTICS FOR BUSINESS DECISION 3
Introduction:
The solved questions in the following are respectively providing us the concept of
frequency distribution and histograms. In the second question, simple linear regression model
brings the idea about sample size, correlation co-efficient, co-efficient of determination and
predicted values. Also, in the third question, one-way ANOVA is accomplished with a
certain level of significance. Correspondingly, in the fourth question, multiple regression
model is executed with the help of MS Excel. This model helps to generate an understanding
about estimation, significance of the independent variables and slope co-efficient. Not only
that, after identification of predictor, elimination of that predictor is accomplished. Finally,
the creation of new regression model with single significant predictor is also shown in this
context.
Question 1
Below you are given the examination scores of 20 students (data set also provided in
accompanying MS Excel file).
52 99 92 86 84
63 72 76 95 88
92 58 65 79 80
90 75 74 56 99
a. Construct a frequency distribution, cumulative frequency distribution, relative
frequency distribution, cumulative relative frequency distribution and percent
frequency distribution for the data set using a class width of 10.

STATISTICS FOR BUSINESS DECISION 4
Using a class width of 10, the range is obtained as; (50-59), (60-69), (70-79), (80-89) and
(90-99).
i. Frequency distribution for the dataset
Class Range/ Interval Class Midpoint (x) Frequency
50-59 54.5 3
60-69 64.5 2
70-79 74.5 5
80-89 84.5 4
90-99 94.5 6
Total 20
ii. Cumulative frequency distribution for the dataset
Class
Range/Interval
Class Midpoint
(x)
Frequency Cumulative
Frequency
50-59 54.5 3 3
60-69 64.5 2 5
70-79 74.5 5 10
80-89 84.5 4 14
90-99 94.5 6 20
Total 20
iii. Relative Frequency distribution for the dataset
Class Range/ Class Mid- Frequency Relative