Search

Data Analysis and Calculations of Mean, Mode, Median

University: University of Suffolk

  • Unit No: N/A
  • Level: High school
  • Pages: 8 / Words 2019
  • Paper Type: Assignment
  • Course Code: N/A
  • Downloads: 735
Question :

Questions- This assessment will cover the following questions:

  • Identify and use various techniques for summarising and analysing data and its usage for making logical reasoning.
  • Explain forecasting techniques to real life situation and its role in analysing the data.
Answer :

INTRODUCTION

The term data analysis can be defined as a systematic process of gathering monetary data and making proper analyses with the help of different types of techniques. It consists of various kinds of charts and diagrams in order to make an effective presentation of analysed data (Landtblom, 2018). The project report is based on the analysis of humidity data of London City over the last ten days. Along with this analysis, some other calculations are also done such as mean, mode, standard deviation and many more. In the end part of the report, the calculation of m & c as well as forecasting of humidity is done for the upcoming time with the help of proper technique.

MAIN BODY

1. Representation of data in tabular form:

Herein, below presentation of gathered data regarding humidity percentage in London, UK is done. This data is gathered from the 22nd of December to the 31st of December (Humidity data of London, 2019).

Days (Date)

Humidity (values in %)

22nd of December, 2019

96

23rd of December, 2019

91

24th of December, 2019

92

25th of December, 2019

80

26th of December, 2019

98

27th of December, 2019

89

28th of December, 2019

99

29th of December, 2019

86

30th of December, 2019

100

31st of December, 2019

100

Need to Consult Directly With Our Experts?

Contact Us

2. Data representation in charts:

Bar Graph: A bar graph is being used to clearly show data using bars of different heights or distances. It contributes in a significant manner in order to understand analysed data in the most effective way. Herein, below a presentation of the above humidity data is done in such a manner:

Column Chart: A column diagram is a chart in which data shows vertical bars horizontally around the chart, with the value axis shown on the graph's left side (Leech, Barrett and Morgan, 2013). Same as the above graph, this is also prepared in the Excel sheet. Herein, below presentation of the above humidity data is done in a column chart which is as follows:

3. Calculations of mean, median, mode, standard deviation and range:

Days (Date)

Humidity (values in %)

22nd of December, 2019

96

23rd of December, 2019

91

24th of December, 2019

92

25th of December, 2019

80

26th of December, 2019

98

27th of December, 2019

89

28th of December, 2019

99

29th of December, 2019

86

30th of December, 2019

100

31st of December, 2019

100

∑ X

931

Mean

93.1

Median

94

Mode

100

Range

20

Maximum range

100

Minimum

80

Mean- The term mean can be defined as an average of gathered monetary data (Beyer, 2019). This is calculated by a particular formula which is as: Mean = ∑N/ N. Herein, the below calculation of mean value is done in such manner:

N= 10

∑N = 931

Mean = 931 / 10

= 93.1

Also Read:- Data Analysis and Decision Making

Median = As the name assists, it can be defined as a mid-value of the number of data series. This is calculated by a formula which is applied in accordance with number data.

If the number of data is odd then, M= (N+1 / 2)th item

If number of data is even then, M= {N/2th item+ N/2th item + 1}2

Herein, below calculation of the median of humidity data is done below in such a manner:

Stuck with your Assignment?

Hire our PROFESSIONAL ASSIGNMENT WRITERS and
Get 100% Original Document on any Topic to Secure A+ Grade

Get Assignment Help

Humidity (in terms of %)

80

86

89

91

92

96

98

99

100

100

= {10/2+ 10/2 +1} / 2

= (5th item + 6th item) / 2

= (92+96)/2

= 94

Mode- The term mode can be defined as a set of data values which appear most of the time from a group of numbers. Such as in the aspect of the above data of humidity this can be found that humidity of 100% has been incurred with the higher frequency of 2. Thus, the value of the mode is 100.

Range- This can be defined as the difference between a higher value and a minimum value from a group of numbers. Herein, below in the context of the above set of data on humidity, this can be found that the higher value is 100 and the lower is 80. Hence, the range is (100-80)= 20.

Standard deviation- Standard Deviation is a quantitative term used to assess the average number of variations or diffusion (Sarkar and Rashid, 2016). Functionally, it's a kind of volatility measure. Herein, the below calculation of standard deviation is done in such manner:

Days (Date)

Humidity (values in %)

x- m

(x-m)2

22nd of December, 2019

96

2.9

8.41

23rd of December, 2019

91

-2.1

4.41

24th of December, 2019

92

-1.1

1.21

25th of December, 2019

80

-13.1

171.61

26th of December, 2019

98

4.9

24.01

27th of December, 2019

89

-4.1

16.81

28th of December, 2019

99

5.9

34.81

29th of December, 2019

86

-7.1

50.41

30th of December, 2019

100

6.9

47.61

31st of December, 2019

100

6.9

47.61

Total

406.9

Variance= [ ∑(x – mean) 2 / N ]

= 406.9/10

= 40.69

Standard deviation: √ ( variance )

= √40.69

= 6.38

Need Personalised Assistance from Our Experts?

Share Your Requirements via Whatsapp!

Chat Now

4. Calculating values of m, c and wind forecast of days 15 and 20.

Days (Date)

Humidity (values in %)

X2

∑XY

1

96

1

96

2

91

4

182

3

92

9

276

4

80

16

320

5

98

25

490

6

89

36

534

7

99

49

693

8

86

64

688

9

100

81

900

10

100

100

1000

∑X= 55

∑Y= 931

∑X2= 385

∑XY= 5179

The form above computations are summarised in the table, following are the steps to find out the value of “m” in the equation which is y = mx + c, as follows:

1. Compute value of M:

M = N * ∑xy - ∑x * ∑y / N*∑x2 - ( ∑x )2

= 10*5179-55*931/10*385-(55) 2

= 51790- 51205/3850-3025

= 585/825

= 0.71

2. Computation of value of c: ∑y- m ∑x/ N

= 931- 0.71 * 55*10

= 540.5

3. By the above-calculated data, forecasting of humidity is done below in such a manner:

Forecast humidity for 15 days Y= mx+c

Y= 0.71*15+540.5

= 551.15

= 55%

Forecast humidity for 20 days Y= mx+c

= 0.71*20+540.5

= 554.7 or 55.4%

CONCLUSION

On the basis of the above project report, it has been concluded that data analysis is too crucial in order to compute any particular result from the collection of a wide range of data series. The report concludes with the calculation of mean-mode-median as per the given data set. As well as standard-deviation is also computed. In the end part of the report, forecasting of humidity percentage is done on the 15 and 20th day.

To get more details about online assignment help connect with us.

Download Full Sample
Cite This Work To export references to this Sample, select the desired referencing style below:
Assignment Desk.(2024) Data Analysis and Calculations of Mean, Mode, Median Retrieved from: https://www.assignmentdesk.co.uk/free-samples/statistics/data-analysis-and-calculations-of-mean-mode-median
Copy to Clipboard
Data Analysis and Calculations of Mean, Mode, Median Assignment Desk ,(2024),https://www.assignmentdesk.co.uk/free-samples/statistics/data-analysis-and-calculations-of-mean-mode-median
Copy to Clipboard
Assignment Desk (2024) Data Analysis and Calculations of Mean, Mode, Median[Online]. Retrieved from: https://www.assignmentdesk.co.uk/free-samples/statistics/data-analysis-and-calculations-of-mean-mode-median
Copy to Clipboard
Assignment Desk Data Analysis and Calculations of Mean, Mode, Median. (Assignment Desk, 2024) https://www.assignmentdesk.co.uk/free-samples/statistics/data-analysis-and-calculations-of-mean-mode-median
Copy to Clipboard
Assignment Desk Data Analysis and Calculations of Mean, Mode, Median. [Internet]. Assignment Desk.(2024), Retrieved from: https://www.assignmentdesk.co.uk/free-samples/statistics/data-analysis-and-calculations-of-mean-mode-median
Copy to Clipboard
Struggling with writing assignments? Take our academic writing services to resolve your problems. We not only provide online assignment help but also various other services like thesis, dissertation, and essay writing services. If you have any doubts about our experts, then we suggest you check our “Samples” before seeking dissertation help from us. Our experts can ease the complexity of your work. All you have to do is ask, “Can you do my assignment?”
Boost Grades & Leave Stress

Share Your Requirements Now for Customized Solutions.

Lowest Price
USD 6

    Delivered on-time or your money back

    100+ Qualified Writers

    For Best Statistics Assignment Help

    View All Writers
    FREE Tools

    To Make Your Work Original

    • tools Paraphrasing Tool

      Check your work against paraphrasing & get a free Plagiarism report!

      Check Paraphrasing
    • tools Plagiarism Checker

      Check your work against plagiarism & get a free Plagiarism report!

      Check Plagiarism
    • tools Dissertation Outline Generator

      Quick and Simple Tool to Generate Dissertation Outline Instantly

      Dissertation Outline Generator
    • tools Grammar Checker Tool

      Make your content free of errors in just a few clicks for free!

      Grammar Checker
    • tools Essay Typer

      Generate plagiarism-free essays as per your topic’s requirement!

      Essay Typer
    • tools Thesis Statement Generator

      Generate a Compelling Thesis Statement and Impress Your Professor

      Try Thesis Generator Tool

    Professional Academic Help at Pocket-Friendly Prices!

    Captcha Code refresh

        Estimated Price

        USD 6.32 25% OFF
        Total Price USD 6
        182532+Delivered Orders 4500+PhD Writers 4.8/5Client Rating

         
        AD whatsapp

        Limited Time Offer

        Exclusive Library Membership + FREE Wallet Balance