I have to complete a problem by this Thursday and need help.

Here is the problem:

Con Vincer, the Laboratory manager, is sitting in his office studying the figures for Laboratory A for the last few years. He notes that having started with 240 scientists in post in Laboratory A there has recently been a monthly relocation of 20 scientists every month to another state facility. This month the aim of the relocation has been reached and there is now the planned final number of 40 scientists in post in Laboratory A. To help Con understand the figures:

* Plot the number of scientists in Laboratory A (counts) against time
* Plot the rate at which scientists are relocated against time
* Plot the monthly percentage change of counts against time

Using the plots you have prepared, and other examples of data presentation if you wish to illustrate your answer, comment on the effect different methods of presenting data have on the viewer's immediate impression of the presentation. Your answer should not be more than 250 words.

One of the state politicians is querying the productivity of the laboratory and the funding which Con is requesting from the state in order to run Laboratory A. How would you suggest Con presents the data which covers the last few years that he has available to justify his funding requests and defend the drop in productivity of Laboratory A?

NEED HELP WITH THE LAST QUESTION..

How would I explain this or go about it. Someone please help me.

You can use a trend analysis using the previous figure. You can do this using the ms excel add analysis tool pak. Just do a simple linear regression curve and you can predict the given time or number.

Joseph

i have to complete a problem by this thursday and need help.

here is the problem:

Con Vincer, the Laboratory manager, is sitting in his office studying the figures for Laboratory A for the last few years. He notes that having started with 240 scientists in post in Laboratory A there has recently been a monthly relocation of 20 scientists every month to another state facility. This month the aim of the relocation has been reached and there is now the planned final number of 40 scientists in post in Laboratory A. To help Con understand the figures:

* Plot the number of scientists in Laboratory A (counts) against time
* Plot the rate at which scientists are relocated against time
* Plot the monthly percentage change of counts against time

Using the plots you have prepared, and other examples of data presentation if you wish to illustrate your answer, comment on the effect different methods of presenting data have on the viewer's immediate impression of the presentation. Your answer should not be more than 250 words.

One of the state politicians is querying the productivity of the laboratory and the funding which Con is requesting from the state in order to run Laboratory A. How would you suggest Con presents the data which covers the last few years that he has available to justify his funding requests and defend the drop in productivity of Laboratory A?

NEED HELP WITH THE LAST QUESTION..

how would i explain this or go about it. someone please help me.
Use the method that justifies the drop in productivity. The charts using rates are the ones that would understate the loss of staff the most. Leaving you with the one chart to use.