Step 1:  Identify the population.  (Where, what, how much)  An example would be that you are looking at                       the population of telephones in the world.  As of 1900, there were 40,000 telephones in the wild.                    I believe that the tiger population is growing by 28% each year.  You must have a reference for                      the information.  You can make up the statistics, but then you will have to make up a reference                       as well.  You may look up a reference online if you wish and cite that.  AGAIN – YOU CAN                        MAKE IT UP, BUT MAKE UP A REFERENCE THAT SOUNDS GOOD!

Step 2:  Identify the starting year and the population at that time.  (your beginning year will be “0” in your                      excel chart)  For my example, the starting year would be 1900;  this would represent 0.  THE                          ACTUAL YEAR DOES NOT GO IN THE EXCEL CHART.

Step 3:  Open an excel chart and a word document.  You will use the excel chart to create a graph and the                       word document to write the paper.  You will be copying the excel chart into your final paper.

Step 4:  In the excel chart, put the year increments in column A.  The first entry will be 0 (your beginning                        year).  You decide if you want to go in 2, 3, or 5 (etc.) year increments.  If 2, then your next 4                        numbers in the A column would be 0, 2, 4, 6, 8….if 3 then 0, 3, 6, 9, 12….if 5 then 0, 5, 10, 15,                     20.  My paper only uses 3 year differences – you must use 4!!!  There will be a total of 5                                 numbers  (starting with 0) in your “A” column.

Step 5:  To get the “B” column, you will go to the calculator on the computer.  You will need to click on                         view and set the calculator to scientific view.

Next, on the calculator you will:

Year (from column A) times percent you have (as a decimal) then hit equal.  Then hit the                                 INV button (top left of calculator) and the e xbutton (next to INV).  Now hit times and                                  then your starting value.  This number goes in column “B” next to the year you used.

Note – the only thing that changes each time is the year (from column A).  DO NOT                                       CHANGE THE VALUE AT THE END.  IT IS ALWAYS YOUR STARTING                                             NUMBER.

If THE CALCULATIONS CONFUSE YOU, GO TO http://www.investopedia.com/calculator/fvcal.aspxAND USE THAT WEBSITE TO FIND THE NUMBER IN COLUMN B FOR EACH YEAR INCREMENT YOU HAVE.  THE PERCENT WILL STAY THE SAME, THE PRESENT VALUE WILL STAY THE SAME, BUT YOU JUST CHANGE THE YEARS!!!!!

Step 7:  Have Excel make a scatter plot (like you did in the first LASA – see the “Doc Sharing notes if                            needed)of the two columns.  Now…go to Layout and click “Legend” and select none.

Step 8:  In the Layout tab, click “Axis Title” the Horizontal and “Title Below Axis” and vertical and select                      “Vertical Title”.

Step 9:  Now, in each axis title, you can highlight “Axis Title” and replace the horizontal with “Years” and                      the vertical with “Population”.

Step 8:  By right clicking on one of the points on the scatterplot, add a “Trendline”.  While On the “Add                         Trendline” option, have Excel display the equation for the line onto the chart and have it display                   R 2on the chart.  Also, while formatting the trendline, up at the top – click on exponential.  This                      will make your line a curve. Excel, have it graph the line on the chart (like you did last class).

Step 9:  Remember that R 2* 100 gives us the percentage of growth implications due to time.  With this in                       mind, make an interpretation based on your graph.  Your interpretation should be more than a                         mere 1 sentence statement.

Step 10:  What are the likelihood of your results?  Would it be expected that the percent growth rate would                   stay constant over such long periods?  Would the growth rate change  exponentially (like                                doubling each year) more than it would be just a constant growth?  What other changes could                        affect the growth?

Step 12:  Write it up in a neat paper with the graph copied and pasted into the paper.  If you got the                                 population from a web-source, be sure to sight that source.

PLEASE READ MY PAPER EXAMPLE BEFORE YOU START WRITING YOURS.  IT WILL GIVE YOU AN IDEA OF HOW TO GO ABOUT YOUR PAPER.  ALSO….MAKE SURE TO PASTE YOUR EXCEL CHART INTO THE PAPER.  ONLY PASTE THE SCATTERPLOT – NOTTHE COLUMNS!!!!

Your paper should follow the format of my paper.  You will not be required to submit a separate title page or reference page.  Simply use the same format and set up that I did.

Trends in Online Education Growth

According to James Marshall Crotty’s Forbes Magazine article, “Over 5.6 million people enrolled in at least one online course in 2009” (Crotty, 2012, p. 1).  Crotty goes on to state the growth in online enrollment is 21% (Crotty, 2012).  This article lends the population of online learners with a growth of 21%.  I decided to look at this trend for a five, ten, and fifteen year span of time.

Using Crotty’s growth percentage, we can see that online enrollment is expected to explode in the next fifteen years.  Exponentially, the population in five years would reach approximately 16 million.  The population would continue to climb to approximately 45.7 million in ten years and approximately 130.7 million in fifteen years.  From a graphical standpoint, the growth is more obvious.

If trends in education continue to follow this growth pattern, it seems that there is an exponential surge occurring in the online arena.  This growth does seem to be in line with the ideals that many Americans are trying to balance more time demands with career and family obligations while attending college.  While I believe that online education does have a growth pattern that is exponential, I feel that there will be a time when the growth slows.  There will be adjustments for availability of online opportunities, costs of higher education, and simply that there are fewer people who will be attending college.  Also, there will be surges in the pattern as resources become more plentiful, economic hardships become less burdensome, and individuals seek  alternative income methods.  More than just the availability will impact the growth of the online environment.  It is affected by the student population, the economy, and the progress of programs that are offered in online arenas.  For this reason, the growth may not remain at a constant 21% throughout the next fifteen years.

References

Crotty, J. M. (2012). Future Of Education Is Mobile, Social, and in the Cloud: Lessons from EduCause.Retrieved from Forbes.com : http://www.forbes.com/sites/jamesmarshallcrotty/2011/10/25/future-of-education-is-mobile-social-and-in-the-cloud-lessons-from-educause-part-one/

## PCN-520 Module 6 DQ 2...

After watching the second part of the DVD (Challenges Facing Group Leaders), what skills do you think you need to acquire or refine t...

## None...

Before you respond to this second Forum assignment, please review the item attached (also located insi...

## ACC205 week 3 exercise...

Week Three Exercise Assignment Inventory 1. Specific identification method. Boston Galleries uses the...

## CJA 413 all Weeks Summaries A++ work !!!...

CJA 413 all Weeks Summaries  A++ work !!!...

## A) The reaction for the combustion of solid sulfur...

A) The reaction for the combustion of solid sulfur is given below:S(s) + O2(g) --> SO2(g)A student combusts a 10.8 gram sample of...

## Sell or Process Further- Port Allen Chemical Compa...

Sell or Process Further- Port Allen Chemical Company...

## UOP ACCOUNTING 490...

The Cloud Effect” Please respond to the following:Many firms are relying on cloud computing, also known as “the clo...

## consolidation and acquisition: Below are the state...

AssignmentBelow are the statements of financial position and income stateme...
Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
\$65
Order a paper. Study better. Sleep tight. Calculate Price!
Calculate Price
Approx. price
\$65