How to calculate parameters and construct one Laird-Gompertz curve?

[imeneses]

3,228 8
3,310
3,389
3,436 4
3,462
3,497 8
3,505 4
3,583 4
3,652 4
3,687
3,709
3,750
3,761 6
3,846
3,957 4
3,996
4,000
4,009 6
4,032
4,036 8
4,051
4,078 8
4,096 7
4,108
4,124 9
4,134
4,156
4,166 7
4,171 7
4,172 4
4,187
4,215 8
4,240
4,242
4,263
4,268
4,282
4,286
4,289 7
4,306
4,312
4,320
4,324
4,331 7
4,347
4,350
4,367
4,370
4,374 8
4,385
4,387 6
4,392 6
4,396 4
4,403 4
4,425 7
4,440
4,453 7
4,459
4,463 7
4,486 7
4,489
4,489
4,508 9
4,510 6
4,511
4,516
4,518 8
4,524
4,537 8
4,547
4,553 6
4,566 7
4,570
4,579
4,582 7
4,590
4,597
4,607 9
4,609
4,615
4,615
4,617
4,631 4
4,639 8
4,647
4,653
4,662 4
4,671
4,676
4,688 7
4,689 4
4,690 7
4,696 5
4,697
4,698
4,714
4,721
4,721
4,743
4,756
4,759 12
4,761 4
4,763
4,768
4,777
4,777 8
4,779 6
4,781
4,783
4,792
4,795
4,809 5
4,811 6
4,814 9
4,820
4,824
4,834 6
4,837 8
4,841
4,868 7
4,877 6
4,879
4,893
4,893
4,893 10
4,900 6
4,903
4,903
4,919 5
4,930
4,959 7
5,012
5,018 6
5,029
5,062 7
5,067 10
5,070
5,080
5,082
5,096 10
5,119 8
5,124
5,146 5
5,146 5
5,162 5
5,213
5,256
5,265
5,286
5,299 8
5,311 7
5,313
5,318
5,318
5,346
5,351 7
5,354
5,378 11
5,394
5,398
5,452 8
5,453
5,455
5,462
5,470
5,508
5,509
5,587
5,614
5,629
5,635
5,690
5,693
5,712
5,728 11
5,783
5,795
5,837 6
5,876 7
5,902 11
5,946
5,950
5,951
5,951 8
5,966
5,975
6,029 12
6,039
6,058 8
6,121 12
6,123
6,209
6,268
6,294
6,331 10
6,370
6,374
6,391
6,415
6,450
6,515
6,529
6,542
6,586
6,608
6,621
6,645
6,662
6,675
6,685
6,707 9

[AliGW]

1. Please explain what you are trying to do.
2. What is Kingsoft?
3. Don't assume that members know what a Laird-Gompertz curve is.
4. Attach a workbook (instructions at the top of the page).

[MrShorty]

I agree with what AliGW said -- you can't just dump a problem on us without helping us actually understand the problem.

If my internet searches were successful, I found an Wikipedia page for a Gompertz function: https://en.wikipedia.org/wiki/Gompertz_function This function is non-linear (at least, in the short time I looked at it, I could not find a way to linearize it) so it will require non-linear regression techniques to perform the regression (in Excel this usually involves Solver). Another internet search for "non-linear regression in Excel using Solver" found this page first (https://engineerexcel.com/using-exce...ar-regression/ ), but there were many hits. Assuming your Laird variation of the Gompertz equation is still non-linear, you should be able to use the techniques on this page to put together a spreadsheet that will perform the regression and draw the chart. Let us know what part(s) you have trouble understanding.

[imeneses]

First of all thank you so much fo replying me. And so sorry to dump my question just like that.
Kingsoft is a free Office version. Laird-Gompertz is a nonlinear model used for fish fish larvae growth. L=L0.exp(k(1-exp(-Gx)))

Sorry and thank you again
Isabel

[MrShorty]

So my guesses were good enough. Were you able to put together the elements of a non-linear regression in your spreadsheet? (I'm not seeing any references to Kingsoft/WPS as an essential tool here, but assuming Kingsoft/WPS has an available solver type utility that can handle non-linear regression models, it shouldn't matter which spreadsheet you use.)

[imeneses]

Let me check if my excel has a solver utility
Thank you

[imeneses]

No this free version doesn´t have this utility. Need to try in another compputer