Business Statistics Practical Questions
Unit I Descriptive Statistics (Compulsory: 5 marks)
1. Generate 40 numbers randomly between 10 and 100 and calculate Mean, Median,
Mode, Range, Quartile Deviation, Mean Deviation, Standard Deviation, Variance,10 th
Decile, 80th Percentile, Skewness and Kurtosis.
2. You are given the following data about the share prices of five companies during
January 2025. Compute various measures of descriptive statistics using excel
functions.
Alpha Beta Gamm Lambd Zeta
Ltd. Ltd. a Ltd a Ltd Ltd
691 799 602 901 833
382 287 907 732 261
840 200 523 848 580
423 861 85 784 107
310 439 602 777 334
716 448 602 194 118
975 400 979 661 171
396 270 479 732 356
973 532 138 814 74
423 952 817 602 768
678 438 118 732 580
486 532 93 720 610
675 687 704 435 580
423 597 171 913 231
558 559 384 440 619
660 656 112 732 926
987 532 554 683 580
487 723 271 946 873
672 343 94 732 528
699 575 584 779 465
687 871 684 841 91
3. For the following data, check whether Mean, Median, Mode, Variance and Standard
Deviation are independent of change of origin and scale or not:
23 79 41 3 59 29 6 38 37 58 58
4. ***Prepare a spreadsheet in MS-Excel to generate 50 random numbers between 0 and
500 and create frequency distribution according to the class intervals provided below:
Class Interval
LOWER UPPER
LIMIT LIMIT
0 100
100 200
200 300
300 400
400 500
You are required to:
i. Calculate the mean, median, mode and standard deviation on the basis of raw and
grouped data by using appropriate functions and calculations in MS-Excel.
ii. Find out the maximum and minimum value from the fixed numbers.
iii. Insert a suitable chart for the above frequency distribution.
iv. Find out how many values are more than 400 (INCLUDING 400) or count the
number of cells having more than value 400 & above.
v. Find the sum of numbers (out of above 50 fixed integer numbers) having more than
value 400 & above.
vi. Find out the skewness of above 50 fixed integer numbers
vii. Find out the kurtosis of above 50 fixed integer numbers.
5. Prepare a spreadsheet in MS-Excel to generate 60 random numbers between 50 and
600, and create a frequency distribution using the following class intervals:
Class Interval LOWER LIMIT UPPER LIMIT
50–150 50 150
150–250 150 250
250–350 250 350
350–450 350 450
450–550 450 550
550–650 550 650
Class Interval LOWER LIMIT UPPER LIMIT
You are required to:
i. Use an appropriate Excel formula to generate 60 random integers between 50 and
600.
ii. Paste values to fix them.
iii. Prepare Frequency Distribution Table.
iv. Compute Mean, Median, Mode, and Standard Deviation for raw as well as grouped
data using Excel functions and calculations.
v. Find how many values are greater than or equal to 450.
vi. Find the sum of all values ≥450.
vii. Compute the Skewness and Kurtosis of the dataset using Excel functions.
viii. Insert a suitable Column Chart or Histogram showing your frequency distribution.
Label the axes and provide a meaningful title.
6. Calculate central moments for the following data. Also, verify that the second moment is
equal to variance.
X 2 3 5 7 8 10 11 23 67 89
Unit III Correlation and Regression
7. For the following data, compute the covariance and correlation between advertising
expenditure and sales revenue. Plot appropriate graph.
Advertising 28 218 225 228 200 211 227 271
Expenditure (X) 8
Sales Revenue (Y) 59 594 533 441 409 412 449 498
7
8. Calculate correlation coefficient and coefficient of determination between the
following pairs of variables:
X Y1 Y2 Y3
10 10 13 99
12 5 15 97
14 7 17 95
16 8 19 93
18 9 21 91
20 0 23 89
22 100 25 87
24 84 27 83
26 81 29 79
28 8 31 75
30 75 33 71
32 7 36 67
34 69 39 63
36 5 42 59
38 53 45 55
40 5 48 51
42 57 51 45
44 0.59 54 39
46 61 57 33
48 63 60 32
50 8 63 31
52 100 67 30
54 2 71 29
56 90 75 28
58 18 79 27
60 16 83 25
62 14 87 23
64 12 91 21
66 10 95 15
68 8 99 11
9. Determine the Spearman’s Rank Correlation Coefficient for the following data:
Salesmen A B C D E F G H I
Intelligenc 55 60 50 65 80 70 75 40 20
e Score
Sales 56 60 42 45 90 30 70 40 15
(₹000)
10. The marks obtained by 9 students in Mathematics and Accountancy are as follows:
Marks in 30 33 45 23 8 49 12 4 31
Mathematics
(X)
Marks in 35 23 47 17 10 43 9 6 28
Accountancy
(Y)
Calculate Spearman’s rank correlation coefficient.
11. Calculate Spearman’s rank correlation coefficient from the following data:
X 57 16 24 65 16 16 9 40 33 48
Y 19 6 9 20 4 15 6 24 13 13
12. In an end semester examination, following marks were obtained by ten students of a
particular class in Mathematics and Statistics:
Marks in Mathematics (X) 25 28 35 32 31 36 29 38 34 32
Marks in Statistics (Y) 43 46 49 41 36 32 31 30 33 39
You are required to find out:
(i) The two regression equations,
(ii) The coefficient of correlation between the marks in Mathematics and Statistics
(iii) The most likely marks in Statistics when marks in Mathematics are 40,
(iv)Calculate the standard error of estimate for regression equation of Y on X.
13. From the following data, obtain the two regression equations, regression coefficients,
coefficient of correlation and coefficient of determination:
Share Price 14 19 24 21 26 22 15 20 19
Dividend 31 36 48 37 50 45 33 41 39
14. Data related to score of an investment analyst in a CFA exam and his corresponding
weekly revenue is as follows:
Investment Analyst A B C D E F G H
Score in CFA Exam (X) 50 60 50 60 80 50 80 40
Revenue (Y) (₹000) 30 50 40 50 60 30 70 50
You are required to find out:
(i) Obtain regression equation of revenue on the CFA exam test score of an investment
analyst. Plot an appropriate graph.
(ii) What is the expected revenue if the investment analyst scores 65 marks in the CFA
exam?
(iii) Calculate the Standard Error of Estimate and Correlation for the data.
(iv) Find out the projected revenues from the data given above.
UNIT V Index Numbers
15. Calculate price index number from the following data by: (i) Laspeyre’s method (ii)
Paasche’s method, (iii) Fisher’s method:
ITEM p0 p1 q0 q1
x1 33 104 42 121
x2 30 104 40 121
x3 26 103 35 118
x4 34 102 36 113
x5 34 102 43 112
x6 31 102 43 124
x7 29 102 38 115
x8 31 104 44 125
x9 29 102 43 119
x10 29 100 35 224
16. From the following data, calculate price index numbers for 2007 with 2006 as base by: (i)
Laspeyre’s method (ii) Paasche’s method, (iii) Fisher’s method:
Commodity Base year Current year
Price Quantity Price Quantity
A 10 100 12 150
B 8 80 10 100
C 5 60 10 72
D 24 30 18 33
17. From the following data, calculate price index numbers by: (i) Laspeyre’s method (ii)
Paasche’s method, (iii) Fisher’s method:
Commodity Base year Current year
Price Quantity Expenditure Quantity
A 8 80 792 88
B 4 200 1150 230
C 6 120 980 140
D 10 60 840 70
E 7 80 810 90
UNIT IV Time Series Analysis
18. You are given the following time series regarding earnings in crores by a firm over a
period of 7 years:
Years 2014 2015 2016 2017 2018 2019 2020
Sales (in crores) 50 52 64 70 90 86 100
(i) Using the method of least squares, fit a straight-line trend equation to the data.
(ii) What is the average annual change in sales?
(iii) Obtain the trend values for the years 2014 to 2020.
(iv) Eliminate the trend using additive and multiplicative models.
(v) What are the expected sales (in crores) for the year 2031?
(vi) Plot appropriate chart for the actual and trend values.
19. Conduct the time series analysis for the following data by utilizing the standard technique
of least square method and predict value of output for the year 2040:
Years 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Annual 135 150 167 176 120 560 600 760 899 800 900 1000 1267
Sales
(in
crores)
20. Below are the figures of production (in ‘000 tonnes) of a sugar factory:
Year 1999 2000 2001 2002 2003 2004 2005
Production 77 88 94 85 91 98 90
(i) Fit a straight-line trend by the method of least squares and show the trend values.
(ii) What is the monthly increase in production?
(iii) Eliminate the trend by using both additive and multiplicative models.