PLEASE HELP I ONLY NEED INSTRUCTIONS ON HOW TO INPUT THE DATA IN EXCEL TO GET TH

Question

PLEASE HELP I ONLY NEED INSTRUCTIONS ON HOW TO INPUT THE DATA IN EXCEL TO GET THE PLOT.....PLEASE, THANK YOU

21. The Seneca Childrens Fund (SCF) is a local charity that runs a summer camp for disadvantaged children. The funds board of directors has been working very hard over recent years to decrease the amount of overhead expenses, a major factor in how charities are rated by independent agencies. The following data show the percentage of the money SCF has raised that were spent on administrative and fund-raising expenses for 20032009.

Year       Period (t)             Expense (%)

2003          1                        13.9

2004            2                        12.2

2005            3                        10.5

2006            4                        10.4

2007            5                        11.5

2008            6                        10.0

2009            7                          8.5

can someone tell me how to enter this data into the cells in excel so that I can create a time series plot. I know Im DUMB just cant think straight right now...

Explanation / Answer

1.First you open the excel file in your desktop

2. The excel window open, you can put the data in any one sheet which is given under

3. Write the "year" in the first row of the first column( A1), In the second column of the first row you write "Period"

and In the third column of the first row you write "Expense"

4. You enter the data of the year in the first column of the second , third, so on row. Similarly for the others

5.Finally you plot the time series plot by using Insert---Chart----Line

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.