Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

What is the best representation of the distribution of data

Posted on 2012-03-29
10
268 Views
Last Modified: 2012-03-29
Hi,

This is a very basic question but I totally forgot high school stuff :/

What is the best way to represent a set of random data? (random numbers)

Average? (Although this is basic, I am looking to do more calculation if possible to get the best fit)

Thanks!
0
Comment
Question by:Shanan212
10 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 37783937
there is no single "best" way

the answer will depend on what you are trying to represent and what you want to do with it.
0
 
LVL 13

Author Comment

by:Shanan212
ID: 37783976
ok the figures are of one year

Say the figures are
Apples     Oranges
12                     9
2                      66
232                  5258
23                    555
53                    68

I am trying to use the figures as forcaster for next year

So I have a price figure x average of apples to get revenue (but average seems not the best option IMO?)
0
 
LVL 27

Expert Comment

by:d-glitch
ID: 37783992
Standard statistics would be mean (average) and standard deviation (spread around the average).

You can do these calculations (as well as generate random numbers to test) in Excel.
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 27

Expert Comment

by:d-glitch
ID: 37784003
What do those numbers mean?

Numbers of apples, cost of apples, ...?

What does the series of numbers mean?  Is it a function of time?   In weeks, or months, ... ?
0
 
LVL 13

Author Comment

by:Shanan212
ID: 37784086
Average                     Standard Dev
2.702068966            1.409153394

9.055578427            1.381641658

12.96546873            1.605291381
 
17.35004248            1.305662328

22.85169104            1.052316898

36.86032306            7.809687104

71.86956522            17.55706286

127.856833              11.12366758

Function of months (montly sales in terms of numbers sold) Should I use the average to forcast next year data? (or is there better figure I can derive - I am concerned because the numbers are so apart/deviates)

The above is the actual figures
0
 
LVL 27

Expert Comment

by:aburr
ID: 37784159
"if possible to get the best fit"
best fit to what?
-
What is the best way to represent a set of random data? (random numbers)"
If you are dealing with random numbers, there is no way to predict the next numbers
0
 
LVL 13

Author Comment

by:Shanan212
ID: 37784215
When I say best-fit, the closest figure that better represents a month's sale of apples?
0
 
LVL 27

Accepted Solution

by:
d-glitch earned 500 total points
ID: 37784278
Which month is which?  It matters.

The sales of fruit are typically seasonal, with lots of interest and activity around Fall Harvest time.

The best way to predict next years sales is to use this years sales directly , month by month.

Unless you have other information -- there was a drought or a forest fire, or an apple sauce factory started operation down the street - there is nothing else to do.
0
 
LVL 27

Expert Comment

by:d-glitch
ID: 37784302
If you have several years worth of data, you could average it month by month and maybe get a better prediction.

If the sales are changing over the course of years because of dietary trends or a growing population, you might want to do month by month linear regression.

But you really need to have real numbers.
0
 
LVL 13

Author Closing Comment

by:Shanan212
ID: 37784366
Thanks!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to solve this equation 3 56
Sample Space 12 51
Inequality 4 84
Odds of picking games correctly 4 131
Have you ever thought of installing a power system that generates solar electricity to power your house? Some may say yes, while others may tell me no. But have you noticed that people around you are now considering installing such systems in their …
This article provides a brief introduction to tissue engineering, the process by which organs can be grown artificially. It covers the problems with organ transplants, the tissue engineering process, and the current successes and problems of the tec…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question