Standard deviation for grouped data, Applied Statistics

Assignment Help:

Grouped data 

For grouped data, the formula applied is  σ = 1926_standard dviation for grouped data.png

Where f = frequency of the variable, μ= population mean.

Example 17

 

A security analyst studied hundred companies and obtained the following Return on Investment (ROI) data for the year 20x3.

Returns %

0-10

10-20

20-30

30-40

No. of companies

19

32

41

8

We can find how the ROI of the company varies with the mean ROI by calculating the standard deviations for the above data.

The steps involved are:

  • Find mean for grouped data.

  • Find deviations from mean for grouped data.

  • Find squares of the above deviations.

  • Total the squared deviations taking frequency into account.

  •  Calculate square root.

Return on investment

Mid-point

No. of companies

Deviation

%

X

f

fX

   X - μ

 f(X -  μ  )2

0-10

5

19

95

      -13.8

3618.36

10-20

15

32

480

-3.8

462.08

20-30

25

41

1025

6.2

1576.04

30-40

35

8

280

16.2

2099.52

Total

 

100

1880

 

7756.00

Mean

2299_standard dviation for grouped data1.png

= 18.8%.
 

 


Standard Deviation 

=

775_standard dviation for grouped data2.png
  = 309_standard dviation for grouped data3.png =8.81%

Thus, the standard deviation for the return on investment is 8.8%.

In such a calculation, we always assume that all the observations in a class interval are located at the mid-point of the class. For example, the first class interval has mid-point 5 and frequency 19. Hence the assumption is that all the 19 companies have an ROI of exactly 5%.


Related Discussions:- Standard deviation for grouped data

Quantitative and qualitative methods for forecasting sales, OmegaPlus Pty...

OmegaPlus Pty.Ltd. is a chain of Health Food stores operating in Australia: with 12 stores across Sydney, Melbourne and Brisbane. OmegaPlus has recently appointed a new CEO: San

Probability and expectation, Ten balls are put in 6 slots at random.Then ex...

Ten balls are put in 6 slots at random.Then expected total number of balls in the two extreme slots

Data project, Dr. Jim Mirabella UNIT EIGHT: DATA ANALYSIS PROJECT All Excel...

Dr. Jim Mirabella UNIT EIGHT: DATA ANALYSIS PROJECT All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below.

#title., 1 Se toma una muestra de 81 observaciones con una desviación están...

1 Se toma una muestra de 81 observaciones con una desviación estándar de 5. La media de la muestra es de 40. Determine el intervalo de de confianza de 99% para la media

Probability, HOW WOULD YOU INTERPRET THIS PROBABILITY:P(a)=1.05

HOW WOULD YOU INTERPRET THIS PROBABILITY:P(a)=1.05

Canonical correlation analysis, Canonical correlation analysis (CC) allows ...

Canonical correlation analysis (CC) allows the investigation of the relationship between two ,sets of variables. For example, a sociologist may want to investigate the Relationship

Advantages of mode, Advantages By definition, mode is the most typic...

Advantages By definition, mode is the most typical or representative value of a distribution. Hence, when we talk of modal wage, modal size of shoe or modal size of family i

Compute the sample mean and sample standard deviation, We want to investiga...

We want to investigate the income data.  In the Excel file Midterm  Data.xls there is a tab labeled "Income Data 2006".  The data in the tab is the income reported by 400 people in

Variance, Variance The term variance was used to describe the square of...

Variance The term variance was used to describe the square of the standard deviation by R.A.Fisher. The concept of variance is highly important in areas where it is possible to

QHA, Your employer, Quick Hit Agency (QHA), is a debt collections agency. T...

Your employer, Quick Hit Agency (QHA), is a debt collections agency. The company specializes in collecting small accounts. QHA does not deal in large accounts and does not take on

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd