Scribd
Upload
155 views2 pages

Practice Questions

The document provides instructions and 6 questions for a practice exam on business statistics. Part A contains 1 compulsory question asking to generate a random number table and calculate various descriptive statistics. Part B contains 5 optional questions covering topics like correlation, regression, price indices, frequency tables, Poisson distribution, and Spearman's rank correlation.

Uploaded by

Varnika Rai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
155 views2 pages

Practice Questions

The document provides instructions and 6 questions for a practice exam on business statistics. Part A contains 1 compulsory question asking to generate a random number table and calculate various descriptive statistics. Part B contains 5 optional questions covering topics like correlation, regression, price indices, frequency tables, Poisson distribution, and Spearman's rank correlation.

Uploaded by

Varnika Rai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Sample Questions for Practice

Instructions:
1. Write your details on evaluation sheet provided along with this paper.
2. Save your excel file in a folder on Desktop by your name and examination roll number.
3. There are two parts; A and B, in this question paper.
4. Part A is compulsory.
5. Any three out of five questions from Part B.

PART- A (Compulsory)
Que 1. Generate a table of 20 rows and 20 columns of 400 random numbers between 1-400 using an
excel function. Also calculate the following descriptive statistics for the data:
(a) Mean
(b) Median
(c) Mode
(d) Standard Deviation
(e) Kurtosis
(f) Skewness
(g) Maximum and Minimum Values
PART- B
Que 2. Following data, related to marks scored by students in Business Statistics and Accountancy, is
collected from the students of B. Com(H):

Marks in 80 75 64 72 58 76 60 42 55
Statistics
Marks in 78 71 68 67 66 85 75 55 60
Accountancy
You are required to calculate following:
(a) Coefficient of correlation
(b) Regression equation; Y on X and X on Y
(c) Show Regression line in diagram
(d) Value of two regression coefficients

Que 3. Following are the price and quantity related data available for five commodities for 2010 and
2020:

Year Commodity A Commodity B Commodity C Commodity D Commodity E


Po 55 35 60 20 30
Qo 200 150 300 450 380
P1 70 55 110 35 45
Q1 220 250 380 550 600
You are required to price index using following methods:
(a) Laspeyres
(b) Paasche
(c) Fisher
Que 4 Generate a table of 20 rows and 20 columns having 400 fixed random numbers between 1-400
using an excel function. Also calculate the following:
(a) Frequency Table for the data
(b) Summation of the all 400 numbers
(c) Summation of values greater than 100
(d) Counting of values greater than 200

Que 5
Construct a Poisson distribution both simple and cumulative for a probability data set having mean as
5, and X ranging from 1 to 25.

Que 6
Following are the data related to marks awarded by two examiners to ten students:

Examiner A 45 51 42 41 43 37 46 47 42 49

Examiner B 43 41 36 44 34 40 32 35 41 36

You are required to calculate spearman’s rank correlation coefficient.

You might also like