Compare estimate and actual values


I have attached an excel spreadsheet that simulates what I am trying to accomplish. The sheet E values contains known embryonic days. The sheet y=LN(E-k) contains a known value for y, which as shown in the sheet is 5.29. These values are what are consider actuals. The k value needs to be scaled from 0-10 in increments of .01. The event + species sheet contains simulated values that I hand scaled. These values should be scaled using 3 digit precision from .5 to 2.5 in increments of .001. the scaled values need to get as close as possible to the actual values for the know events. The errors sheet give the difference between the known and the actual and the error squared sheet squares the error values. I need to predict the optimal value for k, species score, and event score. The errors squared total should be below 1.0. I also want the RMS value and a scatter plot of the actual and scatter plot of the predicted species and event scores.

Skills: SAS, Software Development, Statistics

See more: actual estimate excel, 22 squared, ln, Estimate, compare spreadsheet, excel digit, species score, event spreadsheet, excel software development, spreadsheet development, excel plot days, scores spreadsheet, development sheet, spreadsheet events, oracle count compare values, spreadsheet total values, excel compare target actual, can detect hand using, matlab code mean square lms, running programs machine values type int, calculating mean square error python, statistics event, excel estimate, mean square error calculation python, estimate excel

About the Employer:
( 0 reviews ) United States

Project ID: #5066145

1 freelancer is bidding on average $55 for this job


Though I have understood the requirements, I need to confirm before taking up the project. Please let me know some suitable time when you can come online.

$100 USD in 3 days
(13 Reviews)

Hi there, I'd like to help you with this project. But unfortunately I could not see your attachment. Thanks.

$55 USD in 3 days
(0 Reviews)