ILLUSTRATE STATISTICAL FINDINGS WITH A BAR CHART USING EXCEL

Illustrate statistical findings with a bar chart using Excel

Illustrate statistical findings with a bar chart using Excel

Introduction

Statistics is one study that contains special tools to deal with every type of study. The research in every study requires at least some statistical knowledge at the back to move forward towards conclusion. From huge economic data analysis to local day to day matters, statistics plays a major role and it can be said that for a literate person it would be slightly difficult to spend a whole week with involving into at least smallest kinds of statistical tools (i.e. mean & SDs etc).

The UClan students are weighed in Dec, 2011 with their partners and are placed in group 'a' and 'c'. A sample of 20 students was experimented or weighed and their results are given in the table.

Using Descriptive Statistics

Using descriptive statistics in this case study is to find out the means, variances and Standard deviations (SDs) to analyze the variations with in weights of the students and their partners and also analyze the average height in both the groups (Bowerman, O'Connell, and Orris, 2003).

Analyzing descriptive statistics results

Group 'a' & 'c'

Descriptive Statistics

N

Range

Minimum

Maximum

Mean

Std. Deviation

Variance

Weights of UClan

20

34

61

95

78.25

9.187

84.408

Weights of partners

20

22

43

65

53.40

7.591

57.621

Valid N (list wise)

20

The mean weight of UClan students is found to be 78.25 with a SD of 9.187 showing that 68.5% data lies between 78.25±9.187. The range between the weights of UClan students if 34 KGs. Similarly, the mean of their partners if found to 53.40 with a SD of 7.591 showing that 68.5% weights lies between 53.40±7.591. The range is similarly 22 KGs (Trochim, W., & Donnelly, J. 2008).

Group 'b' &'d'

Descriptive Statistics

N

Range

Minimum

Maximum

Mean

Std. Deviation

Variance

UCLan weights after 6 months

20

24

65

89

78.85

5.706

32.555

Partner weights after 6 months

20

26

40

66

52.30

7.363

54.221

Valid N (list wise)

20

After giving strictly a low calorie diet to the entire above sample, their weights were recorded again and their weights are given in the table. The mean of UCLan students after 6 months is recorded as 78.25 with a SD of 5.706 showing that 68.5% of the data lies between 78.25±5.706. In the same way, the mean of their partners are 52.30 with a SD of 7.363 showing that majority of the data lies between 52.30±7.363 (Gujrati, 2009).

Comparing the differences between Dec, 2011 and Jun, 2012

The mean weights of UCLan students in both the time periods are found to be 78.5 showing that even after giving a low calorie diet to them, the weights remain unchanged i.e. low calorie diets remains of no use (Trochim, W., & Donnelly, J. 2008). Though the range reduces a little from 34 to 24 showing that low calorie diet had made their weights closer to the mean but overall there occurs no change of low calorie diet. Similarly, the mean of their partners before the diet plan was 53.40 KGs and after acting on the diet plan, the mean weight reaches to 52.30 KGs, showing that low calorie diet creates a difference in the weights of their partners but not a significant amount of ...