Computer Hope

Other => Other => Topic started by: glamgran on April 18, 2004, 02:24:56 AM

Title: excel
Post by: glamgran on April 18, 2004, 02:24:56 AM

 ???I am trying to do an excel chart and I don't understand what formula to use we are comparing cost of living in several locationsIf I have the median incomes Locations:seatle,San Francisco,Dallas,Salt Lake City,Memphisand Boston Median Incomes:50993,74773,51099,46359,40439and 59758.determine how muchan employee would have to earn in other cities to maintain same standard of living as if company chose to relocate to Salt LakeCity and paid 75000.I am really desperate

Title: Re: excel
Post by: merlin on April 18, 2004, 03:41:20 PM

you may find all answers on excel here>http://www.kayodeok.btinternet.co.uk/favorites/kbofficeexcelhowto.htm#kbhowto

Title: Re: excel
Post by: dl65 on April 18, 2004, 06:18:02 PM

Hi glamgran....Sounds like we have a homework assignment.........LOL
Exactly what are you trying to do ?........produce a spreadsheet analysis or do a graphic presentation ?

dl65  ???

Title: Re: excel
Post by: carolbtsa56 on April 22, 2004, 04:46:46 AM

 ::)I really am confused but i think i.m doing an analysis chart but i'm not even sure what that is!

Title: Re: excel
Post by: MetalMilitia on April 22, 2004, 02:54:43 PM

what formula are you using for the mean. IS it the 'MEAN' function? or are you doing it in some other way?

I do not quite understand what problem you are having, could you please elaborate.

Title: Re: excel
Post by: carolbtsa56 on April 22, 2004, 08:53:18 PM

Thank you for your help ! by the grace of God ,one of my friends figured it out and showed the rest  of us how to do it. We were doing an income comparison chart to analyze different income needed in several areas with quite diversified median incomes and still all maintain the same standard of living.Isn't it amazing how easy it is to do something once you learn how?!!!     once again ,,,,,,,,thank you but mostly,God Bless You.
            Sincerely,Glamgran