Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
*** I NEED SOME HELP IN THIS****
As the financial manager of ABC computers, you are ready to make some decisions. You are trying to see where revenues are going€”is the company ready to expand, and if so, when? There is a lot of data that you have, but columns of numbers are not as easy to understand as a graph. You plot revenue as a function of time. You do not want to just know what has happened in the past, you want to create a model that will help you predict what will happen to revenues in the future. You can do this if you can fit the data to some function, such as an exponential, quadratic, rational, polynomial, or log plot. To increase your understanding of these, choose one equation of each type: linear, quadratic, polynomial, rational, exponential, and log. Plot each equation on the same graph. Discuss and compare the appearance of each graph. Describe the plots shape, the effect of any constants, and behavior for very large or very small x or y. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Strongly suggest you read the posting guidelines found at the link shown below and then make a new post with a specific question. . . http://www.cpearson.com/excel/newposte.htm -- Jim Cone San Francisco, USA "Kaichie" wrote in message *** I NEED SOME HELP IN THIS**** As the financial manager of ABC computers, you are ready to make some decisions. You are trying to see where revenues are going€”is the company ready to expand, and if so, when? There is a lot of data that you have, but columns of numbers are not as easy to understand as a graph. You plot revenue as a function of time. You do not want to just know what has happened in the past, you want to create a model that will help you predict what will happen to revenues in the future. You can do this if you can fit the data to some function, such as an exponential, quadratic, rational, polynomial, or log plot. To increase your understanding of these, choose one equation of each type: linear, quadratic, polynomial, rational, exponential, and log. Plot each equation on the same graph. Discuss and compare the appearance of each graph. Describe the plots shape, the effect of any constants, and behavior for very large or very small x or y. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A good place to get lots of information on Excel charting is Jon Peltier's
site: http://peltiertech.com/ "Kaichie" wrote: *** I NEED SOME HELP IN THIS**** As the financial manager of ABC computers, you are ready to make some decisions. You are trying to see where revenues are going€”is the company ready to expand, and if so, when? There is a lot of data that you have, but columns of numbers are not as easy to understand as a graph. You plot revenue as a function of time. You do not want to just know what has happened in the past, you want to create a model that will help you predict what will happen to revenues in the future. You can do this if you can fit the data to some function, such as an exponential, quadratic, rational, polynomial, or log plot. To increase your understanding of these, choose one equation of each type: linear, quadratic, polynomial, rational, exponential, and log. Plot each equation on the same graph. Discuss and compare the appearance of each graph. Describe the plots shape, the effect of any constants, and behavior for very large or very small x or y. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using formula to create multiple versions of a Graphs | Charts and Charting in Excel | |||
how do i create radar graphs in excel? | Charts and Charting in Excel | |||
Can excel create 4 Y-axis graphs? | Excel Discussion (Misc queries) | |||
Automatically Create Graphs | Charts and Charting in Excel | |||
How do I create two stacked column graphs together? | Excel Discussion (Misc queries) |