iginal Message-
From: Prafull Jadhav
Sender: excel-macros@googlegroups.com
Date: Sun, 16 Mar 2014 09:04:39
To: excel-macros@googlegroups com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Average Graph
Dear Abhishek Sir,
Very good morning.
If I now that ddaily frequency of cabs
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
On
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,
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
pls provide some example in excel with chart
On Saturday, March 15, 2014 8:12 AM, Abhishek Jain
wrote:
Does this make any sense?
On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav
wrote:
Dear All ,
>
>
>Day before Yesterday I had gone for Interview for Data Analyst. They asked me
>one qu
Does this make any sense?
On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav wrote:
> 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 question on based on Meru
