+ Reply to Thread
Results 1 to 2 of 2

Growth of student learning in a percentage

  1. #1
    Registered User
    Join Date
    09-07-2020
    Location
    Sydney
    MS-Off Ver
    365
    Posts
    1

    Lightbulb Growth of student learning in a percentage

    Hello excel brains trust..

    i need to show growth of student learning based on the student reading levels from Term 2 2019, to the reading level they are at term 2 2020 (1 year apart).

    For example, if a student was on reading level 3 in 2019, and by the same time in 2020 they are now on reading level 14, how do i show that growth as a % and what is the formula so i can apply to all students reading levels.
    FYI - Students can get to a top of level 30. This is their highest level.

    PLEASE HELP!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Growth of student learning in a percentage

    As with many problems, before we can program a solution, we need to understand the problem outside of Excel. How do you want to mathematically define "growth percentage" for this? A standard way of defining this is growth percentage=(new-old)/old -- for your example, growth percentage=(14-3)/3=367%. Tell us how you want to calculate growth percentage, and we can help you program that calculation into Excel.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 02-02-2020, 01:39 AM
  2. Replies: 1
    Last Post: 11-27-2014, 09:37 AM
  3. Percentage Growth between two years
    By debbiesap in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-27-2014, 08:59 AM
  4. Percentage of Growth Calculation
    By yuzi in forum Excel General
    Replies: 6
    Last Post: 07-16-2009, 12:47 PM
  5. Growth Percentage YTD
    By Naggers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-12-2008, 12:05 PM
  6. Trouble with formula on Student 2006 learning essentials template
    By Student in BC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2005, 03:10 AM
  7. determine percentage of growth
    By restore in forum Excel General
    Replies: 5
    Last Post: 04-05-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1