| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Use of excel curves as a valid way to estimate unmeasured data
Hi--
I am reviewing a scientific manuscript for publication. In the article, they graph data in excel and use the curve fitting function to estimate days when nadirs are reached. To me, that seems like a misuse of trendlines, but I'm appealing to the statistically savvy people on this group. Here is the type of data-- Day Result 1 114% 4 107% 8 92% 13 81% 28 79% 42 92% 68 84% 91 89% 112 92% Based on an excel curve, the authors estimated that the actual nadir occurred on day 24. However, in my mind, that's an inappropriate use of the curve fitting function. Comments? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i estimate garch parameters(gamma,alpha and beta)in excel | Excel Worksheet Functions | |||
| Why is * valid if Excel data validation list has no blanks or *? | Excel Worksheet Functions | |||
| how does excel calculate curves of best fit? | Excel Discussion (Misc queries) | |||
| how do i plot curves in excel? | Excel Discussion (Misc queries) | |||
| Does anyone know of a template for bid estimate excel sheets? Is. | New Users to Excel | |||
Threaded Mode
