PLEASE ANSWER QUESTION IN IT\'S ENTIRETY. IF YOU CANNOT ANSWER THE COMPLETE QUES
ID: 2766682 • Letter: P
Question
PLEASE ANSWER QUESTION IN IT'S ENTIRETY. IF YOU CANNOT ANSWER THE COMPLETE QUESTION THEN PLEASE DO NOT ANSWER IT AS I NEED THE COMPLETE ANSWER. THANK YOU FOR YOUR HELP BUT I NEED THE COMPLETE QUESTION ANSWERED.
In ‘Excel Data Document’,below, the table shows inflation rate and the average salary of an administrative staff of ‘Alexandra College’ from year 1992 to year 2012. Does the change in staff wage follow the inflation rate shown in the data file? If not then what is the average different between the change in staff wage and inflation rate? What was the maximum change in staff wage and in which year was that change observed? What was the minimum change in staff wage and in which year was the change observed?
Year Inflation rate Average admistrative staff wage 1992 4.3 1800 1993 2.5 1854 1994 2 1947 1995 2.6 2000 1996 2.5 2065 1997 1.8 2147 1998 1.6 2255 1999 1.3 2322 2000 0.8 2462 2001 1.2 2486 2001 1.3 2511 2003 1.4 2611 2004 1.3 2664 2005 2.1 2797 2006 2.3 2880 2007 2.3 2967 2008 3.6 3000 2009 2.1 3110 2010 3.29 3225 2011 4.48 3330 2012 2.83 3355 Source Inflation: http://www.whatsthecost.com/historic.cpi.aspxExplanation / Answer
Hence we can see that the inflation rate does not followd th wage rate as they increase by differnce percentage point every year
Maximum change in staff wage is in year =6.03%
in year 2000
Minum change in staff wage =0.75%
Inflation rate Average admistrative staff wage 1992 4.3 1800 %change 1993 2.5 1854 3.00% 1994 2 1947 5.02% 1995 2.6 2000 2.72% 1996 2.5 2065 3.25% 1997 1.8 2147 3.97% 1998 1.6 2255 5.03% 1999 1.3 2322 2.97% 2000 0.8 2462 6.03% 2001 1.2 2486 0.97% 2001 1.3 2511 1.01% 2003 1.4 2611 3.98% 2004 1.3 2664 2.03% 2005 2.1 2797 4.99% 2006 2.3 2880 2.97% 2007 2.3 2967 3.02% 2008 3.6 3000 1.11% 2009 2.1 3110 3.67% 2010 3.29 3225 3.70% 2011 4.48 3330 3.26% 2012 2.83 3355 0.75%Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.