Does this make any sense?
On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear All ,
Day before Yesterday I had gone for Interview for Data Analyst. They asked
me one question but i could not answer it .
The Person who has taken my interview, asked me
pls provide some example in excel with chart
On Saturday, March 15, 2014 8:12 AM, Abhishek Jain abhishek@gmail.com
wrote:
Does this make any sense?
On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav prafulltjad...@gmail.com
wrote:
Dear All ,
Day before Yesterday I had gone for
Dear Abhishek Sir,
thanks for reply .
When we exclude the highest value from chart it average is less that is 44
and that is correct average .
But When I show the this chart (included Highest Number ) to my boss , he
will surprise that daily Average cabs coming is 123...and that is wrong...
It
Dear Prafull,
As per example, a total of 1717 cars were handled in 2 weeks (14 days)
which means 123 (rounded off) is the correct average and it is not a wrong
info.
Now, the average for first week is 48 and for second week it is 197. If you
want, we can show week wise averages in the graph or
Dear Abhishek Sir,
Very good morning.
If I now that ddaily frequency of cabs are between 50 to 80.
Because of suddenly increased in cabs for few days this affects the overall
average.
I just want to show normal average..
Which excluding few days highest cabs.
Regard,
Prafull Jadhav.
9920553518
: Prafull Jadhav prafulltjad...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 16 Mar 2014 09:04:39
To: excel-macros@googlegroups comexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Average Graph
Dear Abhishek Sir,
Very good morning