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

..National Account- Descriptive Statistics, A country''s national accounts ...

A country''s national accounts are assumed to look as follows: GDP 1180 VAT and taxes 140 Commodity subsidies 60 Raw material and consumables 530 1. Calculate GVA 2. Calculate t

Risk of portfolios, Risk of Portfolios So far, we have seen the applic...

Risk of Portfolios So far, we have seen the application of standard deviation in the context of risk in single investment. But usually most investors hold portfolios of securi

Simple linear regression, Simple Linear Regression   While correlati...

Simple Linear Regression   While correlation analysis determines the degree to which the variables are related, regression analysis develops the relationship between the var

Linear regression mode, The State Department of Taxation wishes to investig...

The State Department of Taxation wishes to investigate the effect of experience, x, on the amount of time, y, required to fill out Form ST 1040AVG, the state income-averaging form.

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.

Semiaverages and least square, how can we graph a trend line by semiaverage...

how can we graph a trend line by semiaverages and least square method?

Range, Range Official Exports Target 2000-2001 ...

Range Official Exports Target 2000-2001 Product ($ million) Plantation 500 Agriculture and Alli

Index number, "index number is an economic barometer" comment on this state...

"index number is an economic barometer" comment on this statement

Team Collaboration: Business Decision Making Project, Collect data about th...

Collect data about the chosen business problem or opportunity at the company. Explain how you obtained a suitable sample of either qualitative or quantitative data. Review data f

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