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 Cab where i was working earlier. Question was as below He asked me supposed Cabs are daily coming for Repair purpose in workshop it can be 50,60,70,40,65,35...Nos then what will be daily average the cabs graphs. Answer was very easy for above question. then he asked supposed suddenly in few days cabs reached at workshop with 150,500,200..Nos. How will i show graphs or Summary with stable average count. if i include the Highest numbers in series then Average suddenly goes up..and charts look like jumping at highest point. for avoid this ..which type of formula i have to apply here which show stable Average or Graphs. Regards, Prafull Jadhav 9920553518 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.